Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Design Help

Author  Topic 

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-03-04 : 15:52:23
My requirement is to read a flat file which has 'n' rows(One row each for each Policy_Number). I will then have to update a single field in an existing table for each of those policy_numbers.

I was thinking of storing the policy numbers in a staging table and then writing a stored procedures to do the update on the other table.

But folks here dont want me to create a new table for this. Is there another way I can do this? Any help appreciated.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-03-04 : 19:30:43
i would say table variable or temp table #staging
Go to Top of Page
   

- Advertisement -