You may want to make a reference table for the possible code selections, (or if you have one, add another column) and you can select from that table inside the...

Try this:

DECLARE @Task TABLE( PK integer IDENTITY(1,1),

                                        Last_Name varchar(10),

                                        First_Name varchar(10),   

                                        Task_Number integer,

                                        Detail_Action_Date smalldatetime)

INSERT INTO @Task

SELECT 'Jones', 'Rod',  2000, '09/29/06' UNION ALL...

Look up CASE in BOL...

I'm grasping at straws here too, but can you add one row to PH2007 and see if that works? 

Have a great weekend you bunch of trouble makers! 

NOT TOUCHING THAT ONE!!!   He could slam three floors down just with an UPDATE statement...   

Again, Sushila, I think your vault may getting too big! 

Is the clone sayin' it's sane?  Or is this some religious connotation?

I have no idea what this means?  Do you understand, "Fiesty Sushila"? 

Well, he is fiesty like the ol' RGR'us....  I dunno.  Maybe too much time on the keyboard has affected his brain...  Or maybe its a clone and they made an...

Glad to see things are back to normal and everyone is complimenting one another...   

(Ninja was semi-explained on another post, but I do...

I can read, funny guys!    You can quit talking about me in the 3rd person...   

(and...

Do you have to UPDATE?  Can you TRUNCATE DB1.dbo.t1 and re-populate it with the tempDB.dbo.T1Temp data, (although I'm not sure why this is coming from tempDB)? 

Wait a minute!  Does that mean that I have to put "bulldozer" in my resume?