Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
distinct by a column
ok call me stupid but here is another one lets say instead of getting the max we want to merge them input 62997 'blue' 100004 'red' 62997 'green' 100008 'red' 100004 'black' output 62997 'blue, green' 100004 'red, black' 100008 'red'- pendarric
- Post #3
- Forum: Microsoft SQL Server: Programming
-
distinct by a column
Lets say we have a table with an id and a date I want to find the most recent date for each id. eg 62997 2000-12-16 63702 2000-02-02 100004 2001-03-14 62997 2000-02-22 100008 2000-03-26 should output 62997 2000-12-16 63702 2000-02-02 100004 2001-03-14 100008 2000-03-26 This is easy...- pendarric
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
cursors
I am having some trouble with an SQL query the data would look something like thie id attribute 1 blue 2 yellow 1 black 3 white 4 green 2 blue 5 green 2 brown 1 yellow 4 white the output needs to be like this. id attribute 1 blue,black,yellow 2 yellow, blue, brown 3 white 4 green 5 green,white...
