Viewing 3 posts - 1 through 3 (of 3 total)
yes , DTS .
May 30, 2006 at 6:26 am
#640657
you have 2 problems :
1 you can't use distinct with order by
2 your case is not good
1 you need to make a virtual table like vt.xxx,vt.yyy ..... from(
2 after...
August 1, 2005 at 11:57 pm
#578724
all u need to do is not BDate = CASE @CheckBDate WHEN = 0
BDate = CASE WHEN @CheckBDate = 0
July 13, 2005 at 12:58 am
#573779