From: Lars Zeb <larzeb@...>
Date: 2008-01-30T14:15:01+09:00
Subject: Re: newbie file write problem

I expected it was something like the following for each input line:
 IF EXISTS (SELECT * FROM Sic WHERE Code = '3291')
      BEGIN
        UPDATE  Sic
               SET     Descr = 'ABRASIVE PRODUCTS'
               WHERE   Code = '3291'
            END
         ELSE
            BEGIN
               INSERT INTO Sic
            SELECT '3291', 'ABRASIVE PRODUCTS', getdate()
         END