Thank you very much!

An "EXECUTE AS OWNER" seems to resolve it 😀

From the first glace you have couple of issue here:

1. The trigger is not designed for multiple records meaning the INSERTED (and DELETED) table can return more than one row.

2....

As stated before, the issue is that a column (and therefore a case-statement) can only have one data type.

if you need a formatted print, you could convert the results into...

Why using a CASE in the first place? The following will get the same result:

SELECT a.gender, a.NAME FROM #temp a

WHERE (a.gender = 'M' AND a.leavetypeid IN (1,2,3))

or (a.gender =...

I recently discovered that a SQL 2005 Enterprise installation requires a server OS like windows 2003 server.

On a none server OS (like XP) you can only install the client components.