Viewing 4 posts - 16 through 19 (of 19 total)
Thank You it worked.
select Col1, Col2, Col3
from
Tab1
where
Col2
=
May 18, 2006 at 9:36 pm
#638907
For COL2 = Q, I want to show all records where COL2 = Q or COL2 is null but Value in Col1 (rows with Null Col2) should not match with...
May 18, 2006 at 1:04 pm
#638846
No, this won't work as I will only know the value for col2.
May 18, 2006 at 12:37 pm
#638841
Thanks for your comment.
Running "Update Statistics" after truncate/inserts or when we start to have problem. I have tried it during Performance problem but got nothing out of it.
JM
May 14, 2006 at 6:03 pm
#637760