Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

How do we bcp using row_number()

Since I have a table which has no unique key / PK, what is the best way for me to do bcp to just grab record which not being collected, I have  column in the table call date_time which has getdate() values, so usually our data has around 50 millions to copy for each month, so I'm thinking to run this bcp daily can I us row_number() here ?
ASKER CERTIFIED SOLUTION
Avatar of Amgad_Consulting_Co
Amgad_Consulting_Co
Flag of Egypt image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

I have find out another solution which using date and time function in sql server