I have a CSV file with IDs of rows. I want to use that to make a SELECT statement selecting the IDs within that CSV file.
There is 1 million rows and I want to select about 95,000 of those.
I want to SELECT and import these rows to another SQL Server database using the SQL Server Import and Export Wizard.
I'm using MSSQL 2005 with SQL Server Management Console.
Best Answer
Probably best to:
Unless you want to use SSIS? Then you can design a package to do it easily without importing the whole file directly.