My table have to be like this
-
Hi i am having table like this: Name Dates N1 7-21-2008 N1 7-24-2008 N2 7-21-2008 N2 7-27-2008 N3 7-24-2008 Now i want o/p like this: Name Dates N1 7-21-2008,7-24-2008 N2 7-21-2008,7-27-2008 N3 7-24-2008
Thanks & Regards, NeW OnE, please don't forget to vote on the post
-
Hi i am having table like this: Name Dates N1 7-21-2008 N1 7-24-2008 N2 7-21-2008 N2 7-27-2008 N3 7-24-2008 Now i want o/p like this: Name Dates N1 7-21-2008,7-24-2008 N2 7-21-2008,7-27-2008 N3 7-24-2008
Thanks & Regards, NeW OnE, please don't forget to vote on the post
-
Well, what do YOU think the sql should be? Have a try, post your sql and then someone may help you.
Bob Ashfield Consultants Ltd
Ashfield wrote:
Have a try, post your sql and then someone may help you
Thank you. OP was beginning to sound like an annoying mooch who wants someone to do their work for them.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Ashfield wrote:
Have a try, post your sql and then someone may help you
Thank you. OP was beginning to sound like an annoying mooch who wants someone to do their work for them.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Ashfield wrote:
Have a try, post your sql and then someone may help you
Thank you. OP was beginning to sound like an annoying mooch who wants someone to do their work for them.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
Beginning to? Sounded like it from post number 2. :doh:
--------------------------- Blogging about SQL, Technology and many other things
-
Beginning to? Sounded like it from post number 2. :doh:
--------------------------- Blogging about SQL, Technology and many other things
Not just the past two or so, but the OP was going on about the same thing the other day. Did get some replies. It just goes to show how true it is with my sig from John Simmons ;-)
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon