Viewing 6 posts - 1 through 6 (of 6 total)
Honestly, I'm really excited.
I really like the spirit.
I thought, I posted a simple question. And I'm surprised by the solutions, counters and clarifications on each thread. The reason why it...
March 21, 2010 at 1:46 am
puneet shadija (3/17/2010)
Select A.*
from Table2 A left outer join Table1
on A.PId = B.Pid and A.SSN = B.SSN
where B.Pid is NULL
Extremely sorry for being late.
Puneet, Good Code. And is...
March 20, 2010 at 2:37 am
GilaMonster (6/29/2009)
Add the columns in the index key. Not possible if there's lots or if they're of a type that can't be included.
Thanks for the reply.
As you said, let me...
June 29, 2009 at 5:46 am
Christopher Stobbs (6/29/2009)
If you using 2000 you can't use include...
How sad...!!!
Is there any alternate approach in sql 2000, to implement the same.
🙁
June 29, 2009 at 5:33 am
GilaMonster (6/29/2009)
Compatibility mode 80?
How can I check the compatibility mode is 80?. Im using sql server 2000.
June 29, 2009 at 5:22 am
Hi,
Thanks for the help.
That worked.:w00t:
Take care.
June 18, 2009 at 7:22 am
Viewing 6 posts - 1 through 6 (of 6 total)