By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

Validating records in a table

P: 3
Hi I have a file with the following entities loaded in a temp table

idno
Caseno
passport no

Now I need to validate that this records are avalaible before going to the marching of this values in my temp table with my main table. How do I validate this records in my Temp Table. There are lots of records in the table so I think I will need a cursor. I am new to Sql. Someone pls help me asap
Feb 9 '10 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Among the three columns, which is the link between your temp table and main table??

~~ CK
Feb 9 '10 #2

P: 3
Thanks a lot I got it sorted and my DTS Package is running smoothly. In production now. Thanks
Feb 12 '10 #3

sashi
Expert 100+
P: 1,754
Why not share the solution with us :)
Feb 13 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.