much more like

1

2

3

4

into 1,2, 3, 4

nope but 1 2 3 4

into 1, 2, 3, 4

thank you i appreciate it

ok thanks guys am still waiting i appreciate it

Thank you so much,its not actually my code i just want to simplify it and make it better

Thank lutz your always very helpful, guess i should know the difference...ah

Thank you i appreciate it

i meant how could i view the stored proc a report is using if the report has so many Procs in its data set in ssrs

Thank you that works, i have one more question;how can you view the stored proc a report is using if the report has so many Procs in its data set

thanks for your answer based on the query how would i make the result set to group on the D.sellername

i think it works if i run into any more problems you ll be the first to know thanks i appreaciate it i wish i could buy you a round...

Thanks ll try it i appreciate your answer

i dont know how alll i want is the result set to grouped on the names,i know its difficult i cannot come up with the solution myself thats why i...

it doesnt matter as long as the result includes all the columns, you can exclude the id column because i dont know if its possible to include that in the...

here is sample data;

1Nicholas Edet802009-12-22 00:00:00.000

2Nicholas Edet952009-12-22 00:00:00.000

3Nicholas Edet902009-12-22 00:00:00.000

4Emanuella Edet762009-12-22 00:00:00.000

5Emanuella Edet802009-12-22 00:00:00.000

6Emanuella Edet972009-12-22 00:00:00.000

7Emanuella Edet762009-12-20 00:00:00.000

8Nicholas Edet952009-12-20 00:00:00.000

9jackson Devo702009-12-21...