IF @BenefitYear = 2013 BEGIN INSERT INTO mainTable (userid,username,addr,ucost,unitcost90,benefityear,datecreated,createduser) SELECT userid,username,addr,ucost,unitcost90,@BenefitYear, current_timestamp,@BatchUser From stagingTable END
BULK INSERT pubs..publishers2 FROM 'c:\newpubs.dat' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)