Sorry, but what means "DIY"?

Hello,

execution of:

select EmployeeID, LastName, FirstName, MiddleName, Department, 0 as EmployeeLevel

into #tmptbl

from Employees where SupervisorID = (Select EmployeeID from #tmptbl where EmployeeLevel = 1)

gives error message:

The SELECT...

Indeed. "set @j-2 = @i--" is also a nice joke. Good idea for placing some T-SQL bombs in our companies 🙂

Hello,

it's worth to be mentioned that ++ and -- operators don't exist in TSQL. The following example code:

declare @ int = 1, @j-2 int, @k int

Set...