While this is very useful for returning a list to be examined manually, it's not appropriate for most automated name matching. For instance, if you were running this against first...

I went ahead and just used dynamic sql. I was able to do all the dynamic operations in memory only for our purposes, so performance hit shouldn't be an issue.

I need "person" and "type" to be variable as well. It's that combination that I'm having issues with.

The DBAs are on equal footing with the developers here. It's important for the DBAs to understand what the developers are trying to accomplish (customer service, maintainable code, etc.), as...

Also, remember that 'select' always returns a count ('x rows affected') unless you use SET NOCOUNT ON.

This may not be at all what you're looking for, but I have been *really* impressed with the ApexSQL Documentation product - creates a helpful out of your database! Not...

In our case, we couldn't do the memory table (table datatype) because we the procedure could be being called by another one, and it could be inside a transaction that...

Hi there,

We ran across the same situation - wanting to record use of a stored procedure, including its final status. Originally, we just added a line to the stored procedure...