470,596 Members | 1,574 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

how to reconcile two tables using cursor.

6
Hi! I'm new here.
Here's my problem.

How can u reconcile two tables using cursor?
I would like to create a new table reflecting the matching records of the two tables I've compared.
how will i do this?
please help.
Jun 25 '07 #1
7 3249
pbmods
5,821 Expert 4TB
Heya, ssshhh. Welcome to TSDN!

What database server software are you running?
Jun 26 '07 #2
ssshhh
6
thnx for the welcome.
I'm using ms sql server 2000.

im doing a reconciliation report.
how can i insert the matching records into a new table?
Jun 26 '07 #3
bartonc
6,596 Expert 4TB
thnx for the welcome.
I'm using ms sql server 2000.

im doing a reconciliation report.
how can i insert the matching records into a new table?
Now that we know your RDBM, we can direct you to the proper place to post.
That would be in the SQL Server/MSSQL Forum.

Also, please take some time to check out our Posting Guidelines. Thanks.
Jun 26 '07 #4
pbmods
5,821 Expert 4TB
Moving to the MS SQL forum....
Jun 26 '07 #5
ssshhh
6
am i not in the mssql forum already?
Jun 28 '07 #6
debasisdas
8,127 Expert 4TB
Use joins for your purpose and create the table based on that.

If u want to continue the process create a view instead.
Jun 28 '07 #7
pbmods
5,821 Expert 4TB
Heya, ssshhh.

am i not in the mssql forum already?
You are now ~_^
Jun 28 '07 #8

Post your reply

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

Similar topics

2 posts views Thread by Anthony Robinison | last post: by
2 posts views Thread by kizmar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.