How can I take the 900 records from file and pass into the select statement ?
I have a file which contains the Serial number .The total number of serial number may be 10 or 100 or 10000 or more.
So I am using this serial number and fetching the data from sql server.There is simple select statement and in that IN clause I am passing these serial number.BUt there is limitation of IN clause. We can pass 1000 record only.
So I have to capture 1000's record from file and pass into SQL statement and then again pass next 1000 serial number.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.