huh, weird. I definitely expected an error.

Oh well, then.

MsSqlSystemResource is a hidden system database that is only accessible through the pre-defined objects in the "sys" schema, supplied by Microsoft. It is not intended to be accessed directly...

Alternatively, you could use dynamic SQL to pre-generate a seperate function for each table that you want this function to apply to.

we still don't know what you are trying to do.

You need to use dynamic SQL if you want to treat the tablename as a variable.

However, you cannot use dynamic SQL in a user-defined function.

You'll have to use another approach.

Show us an example of your csv file.

glad I could help!

Definitely not. In fact I would say that it is more the reverse:...

If on the other hand, you are already committed to a DW approach, then I would say that your original idea is on the right track. I would simply...

I agree with Jeff, and just to add to it: From a relational design standpoint, this is better implemented as a PrimaryEmailID attribute (column) of the Employee table where...

Heh. I remember the first time that I saw it. A co-worker called me over to his desk asked me what I thought it meant. I looked...

Please post the sql code from the stored procedures and the XML qeury plans for your DEV and production environments.

This trigger text should be able to extract it for any Server-level trigger:

select

CAST(eventdata().query('/EVENT_INSTANCE/DatabaseName[1]/text()') as NVarchar(128))

OK, well this is ugly as sin, but it will work:

Select

Case When Min(substring(COLUM_NAME, 1, 1))

= Max(substring(COLUM_NAME, 1, 1))

Then Min(substring(COLUM_NAME, 1, 1))

Else '' END

+Case When...