I think that someone was barking up the wrong tree when they wrote the requirement ... but, since some folks suggested doing it...

Only if I absolutely had to put up with the same cruddy requirement that William has obviously been blessed with.   It's simple data...

As CK suggested... but different...

 SELECT UserID,

        Category,

        PayPeriod,

        ISNULL(CAST(DeleteFlag AS VARCHAR(12)),'Literal Null') AS DelFlag

        ISNULL(CAST(IntegerTest AS VARCHAR(12)),'Null Integer') AS IntTest

   FROM TimeWorked_Temp

Is first name always guaranteed to be there?  If not, what happens to the comma?  Is Middle Initial always guaranteed to be there?  Can the last name have a space...

Ah... sir... you have created "Death by SQL"... if two processes fire the trigger at the same time, who will win on the input buffer table you've created.  Do the...

You're welcome and thank you for the feedback...

Cool... nice work around, Robert.

Stef, I gotta ask... why are you adding a column to a permanent table?  Why doesn't the table already have that column?  I'm obviously missing something here...

We're all in this together and I'm pullin' for ya" --Red Green

And, thanks for the feedback, Robert... that's what this is all about.

Thanks, Commando... I appreciate the feedback...

Yep... if you try to execute the whole thing... it's a single "batch".  During "compile" time, the whole thing is evaluated and since the column doesn't actually exist, yet, the...

If you don't already have one... now is the time to make a "Tally" table... Here's how...

--===== Create and populate the Tally table on the fly

 SELECT TOP 11000...

Or... Use OSQL with the -h-1 option.  Don't forget to set the -s option to a tab... you can't do THAT from the command prompt... you will need to make...

Not sure Michael is set on this... FULL joins return all rows from both tables 1 time, Cross joins will produce either a partial or full cartesian join (ex. if...

Bingo!... Nice job, CK...

Matti and John... you guys are "spot on" about temp tables.  John, I absolutely agree... lot's of times, a good set based solution will require NO temporal structure whatsoever.