Viewing 4 posts - 1 through 4 (of 4 total)
Sorry my mistake, these are datetime fields (but I'm using 2 fields - one to store date and the other for time)
Is there a way to do a select to...
January 23, 2013 at 8:09 am
OrderID is auto gen number but can use orderdate for this purpose.
If there is one order placed, then I want both min/max to contain the same long with rest of...
December 31, 2012 at 2:29 am
Many thanks and sorry about the earlier post.
Your methods works!
Thanks again for your help.
December 13, 2012 at 12:33 pm
Thank you for your replies.
Have already tried assigning local variables method by GSquared but returned the following error:
"A SELECT statement that assigns a value to a variable must not...
December 13, 2012 at 12:18 pm
Viewing 4 posts - 1 through 4 (of 4 total)