Greetings,
I'm trying to retrieve the most recent date for each code.
for example:
Table A
code Date
code111: 02/10/2005
code111: 03/10/2006
code111: 03/10/2007
code122: 04/10/2000
code122: 03/10/2003
code122: 03/10/2007
I'm trying to retrieve the most recent date for each code and use it...
Thanks you..what is 1? It creates an error:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Your help is greatly appreciated
Hello All:
I'm trying to select all the characters that appear before a hyphen. For example, I'd like to retrieve 'Sports' from a field with the value 'Sports - rating'
Any help!?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.