Viewing 3 posts - 1 through 4 (of 4 total)
My bad this one is sql server 2000...
It seems I'm in deep...
November 9, 2009 at 11:09 am
#1076800
I got this error on your code :
row_number' is not a recognized function name.
I'm running on sql server 2005
November 9, 2009 at 11:02 am
#1076795
In fact there should be only one row in the result. The order of priority is Width, Height, Depth
In the real world there is thousands of product code. ...
November 9, 2009 at 10:44 am
#1076782