ISNumeric() function have this tendency to trick you in, especially if you want to type cast the data

nice trick question .... very nice start of the week !!!

very nice question

Thanks Ford !!!

+1 .... good knowledge base question

Excellent question to get the lazy Monday going .. 😉

good interesting question

as far as CTE is concern they do come handy ...

I'm assuming that "UsersRSDesk" table will have all the "AssignedToRstEmpID" related data in that table.

following trigger will do the trick for u ...

CREATE TRIGGER dbo.TR_UsersRSDesk

ON...

nice weekend question 🙂

nice basic question

To Err is human .... 🙂

if one ignore the "String or binary data would be truncated." error .. which i do

so good question ...

Just a tiny little advice to author,...

+1 to koen ... 🙂

good question ... people tends to forget these basics !!! 🙂

looks like a assignment question to me ... Or he is just so happy to get the answer 😛

+1 to SQLRNNR for making this point