Here is the error I am receiving when I run the script file after the first successful run, in which the columns were removed from the promotion table.

Msg 207, Level...

Ian:

some more info.. the promotionschedule table is being created in the same script file, so I am checking to make sure that it was created before the insert as well....

Hello Ian:

Yes, I am checking for the existance of a column in the promtion table prior to inserting into the promotionschedule table. Later in the database script some columns are...

I am using the conditional check because the startdate column is being dropped from the table after we migrate data to new table. We have a script we run in...