Viewing 15 posts - 1 through 15 (of 35 total)
This requirement is still is design phase an we are can change design of a table.
actual requirement is to retrieve data for multiple portfolio for reporting purpose.
June 3, 2014 at 3:31 pm
After adding following records
SELECT 'P2',NULL,'P4' UNION ALL
SELECT 'P4','T6',NULL
if i ask for portfolio P1's hierarchy
O/P should looks something like this
PortFolio Trade ChildPortfolio ChildTrade
P1 T1 NULL NULL
P1 T4 NULL NULL
P1 NULL P2 T2
P1 NULL P2 T3
P1 NULL P3 T5
P2 NULL P4 T6
June 3, 2014 at 2:53 pm
Thanks
ddl looks good
O/P i am looks at is all dates when flag changes it's value
so in case of
id = 1 dates are
3/1/2013 and 4/1/2013
and for id 2 date is...
May 9, 2013 at 3:24 pm
I used tried both way ony with telly table workedout grate perfomance wise.
Thanks once again fro your help
January 25, 2012 at 2:17 pm
Thanks all for you help
this worked out grate for me
January 25, 2012 at 2:05 pm
Yes id did help resolve my issue
Once again thanks for your help.
September 13, 2011 at 7:33 am
Thanks for your Help
This is not Homwork.
I I have similar Business rqeuirement . and to get answer from foram readers I just simplify my xml.
My original XML is really complex...
September 12, 2011 at 1:41 pm
I am running this query
declare @Filt XML='<Filter>
<List>
<Node1>100</Node1>
<Node2>10</Node2>
</List>
<List>
<Node1>200</Node1>
<Node2>
<Val>1</Val>
<Val>2</Val>
<Val>3</Val>
</Node2>
</List>
</Filter>'
SELECT
x.i.value('Node1[1]', 'varchar(1000)') AS Node1,
x.i.value('Node2[1]', 'varchar(1000)') AS Node2
FROM @Filt.nodes('Filter/*') x(i)
Whish gives me o/p as
Node1 Node2
100 10
200 123
and I am...
September 12, 2011 at 1:20 pm
yes My o/p is same as this
I want o/p something like this
dt ...
May 13, 2011 at 9:57 am
Viewing 15 posts - 1 through 15 (of 35 total)