Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i have an SQL table with App 4,000,000 lines
i want to start the load fro line 3500000
how can i do it with out a condition in the load script ,
thanks
gidon
Load your table like
Load
Statements
..
...
From Location
Where RecNo( ) > 3500000;
Regards
For your SQL load statement write a code like
LOAD Region, Country Where RecNo() > 3500000;
SQL SELECT Region, Country
FROM Emp;
Write this statement Where RecNo() > 3500000
if you want the filter in sql server, I think
Table:
load
*;
SQL
select * from (
SELECT ROW_NUMBER() OVER (
ORDER BY (SELECT 1)) AS RowNumber,
*
FROM YourSqlServerTable
) a
where RowNumber > 3500000;