Viewing 5 posts - 1 through 5 (of 5 total)
have got the desired result.. Thank you very much
November 29, 2012 at 3:08 am
Thank you very much for your help... but I cant create a table with the columns D1, D2 etc like..
CREATE TABLE #Temp1
(
clientid int,
tagid int,
tname varchar(max),
d1 int,
d2 int,
d3 int,
d4 int,
d5...
November 29, 2012 at 2:21 am
Now I have to get the row sum of each column from D1 to D4.
Example: the desired result set would be like the below
Cid TagId Name D1 D2 D3 D4...
November 28, 2012 at 8:44 am
Yeah Roll up works here. I have already tried.. but it is not working in inner query. So I have taken another outer select query and got the desired result.....
November 28, 2012 at 8:36 am
I want the rollup of D1, D2 etc for each name.
Example: If the result set like the below..
Clientid TagId NameD1D2D3D4D5
147American100050030000
148Hispanic0001000200
147American100050030000
148Hispanic0001000200
I want the result set like the following..
Clientid TagId NameD1D2D3D4D5
147American100050030000
147American100050030000
147 ...
November 26, 2012 at 2:38 am
Viewing 5 posts - 1 through 5 (of 5 total)