Hi,

thousands of records can enter (happend)from one table to another table's field ?
what query will use. by the help of loop etc.

table name contract,
field name contractno.
field type is numeric

regards.

Mateen Martin
[email protected]

I'm sorry.

I cannot parse your question. What do you want to do?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

First, with native SQL (like Query Analyzer) or within programming logic such as (ASP, VB, etc...) ?

If using Q.A., you might want to look into the
INSERT INTO <table1>
SELECT col1, col2, ... coln
FROM <table2>
WHERE <cond>

-and-

SELECT col1, col2, ... coln
INTO <table1>
FROM <table2>
WHERE <cond>

-or-

using a T-SQL batch with a CURSOR to loop through your input and dump it into a table.

-or-

DTS -or- BCP to load your table...


If using ASP or VB or some other language, you could use a loop like DO WHILE or DO UNTIL with INSERT statements, or you could use one of the above INSERT/FROM or SELECT/INTO statements, or some ADO cursor looping...

You werent too specific about your environment or needs but I suspect you might want to look at the INSERT/FROM and SELECT/INTO in Books Online AND, get yourself a copy of Wrox' SQL Server 2000 Programming - its gonna help you a lot.

Hope that helps....

thanks for response.
I am using asp.