473,396 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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 3482
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

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

Similar topics

3
by: Paul | last post by:
Hi, I'm trying to add a modified datetime and userid to all 72 tables in my SQL 2000 database. I have the script to do one table, and a cursor, but it won't run across all tables. Any help would be...
2
by: Amy | last post by:
This is what I want to do: 1. Delete all tables in database with table names that ends with a number. 2. Leave all other tables in tact. 3. Table names are unknown. 4. Numbers attached to...
2
by: Anthony Robinison | last post by:
Looking for a better way to implement this stored procedure. The issue is that at the end of the procedure, when you try to drop the temp table after you open the cursor, you get an error stating...
2
by: Salad | last post by:
I am having a problem with linking to FoxPro DOS tables in Access2000. Simply opening the tables are EXTREMELY slow. Let me tell you how make my connections to these tables. I could easily be...
0
by: com | last post by:
Reconcile Query Wizard Add-In For Access 1.2 http://www.soft30.com/softdown-134-15080.htm Free utility to build a reconciliation query that identifies differences between two tables in Access....
3
by: Steve Teeples | last post by:
I am new to database work. I have a very simple database with only two tables linked by a 1:1 relationship. I've read the tables contents into a dataset and bound the two tables to textbox...
4
by: SQLNewbie | last post by:
I have the following cursor that I am comparing 2 tables, the production table and a copy of the production table, I want results of all address's that are like the address1 field...the problem...
9
by: Ots | last post by:
I'm using SQL 2000, which is integrated with a VB.NET 2003 app. I have an Audit trigger that logs changes to tables. I want to apply this trigger to many different tables. It's the same trigger,...
2
by: kizmar | last post by:
You'll have to excuse me as I'm familiar with T-SQL (SQL Server), not so much DB2 when creating stored procedures... I'm trying to create a procedure where I build multiple temp tables (DECLARE...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.