What I laid out for you is how to do it.

If the optional parameters handling is a problem, just implement your case function as a two-parameter version that has null-handling...

Please show us the code from your program, that generates this error.

(Note that this is a programming forum.)

That was Adam Machanic's session. ...

Well you could write something like this, or its equivalent in CLR:

Create function dbo.fnMAX(

@p1 SQL_Variant

, @p2 SQL_Variant = NULL

, @p3 SQL_Variant = NULL

) Returns SQL_Variant

AS

Begin

Declare @val SQL_Variant

Set...

Robert klimes (11/20/2008)

---

I am trying to script out users,roles, and logins calling SMO from t-sql. I have the sql down but I am having trouble finding the correct smo namespaces...

Matt Miller (11/22/2008)

---

Since we're into contratulating everyone - Barry, I GOT to say - love the new Avi pic! It reminds me of a skit by Eddie Izzard, called...

Jonathan Kehayias (11/21/2008)

---

GilaMonster pointed this post out to me at the end of a session we were sitting it at PASS. Now she is teaching her session called "The...

Well, I am leaving for PASS '08 right now, and I know that Gail is already there, so I'd recommend reposting this as a new thread, and hope that Jeff...

Well, let's see:

Usually on my cell phone as I...

We would need to know the relationships between these items in order to answer that.

What changes did you end up making?

Not sure what "can this be used in SQL 2005?" means.

If you are saying that you have a COM component and you want to call it from SQL 2005, then...

Actually, quite a few (maybe even most) DDL commands and...

It's worse than weak, it makes your app non-functional. You do realize that under this scheme, your users would not be...

Marios Philippopoulos (11/13/2008)

---

I recently created 3 UDFs that handle regular-expression operations in our SQL environment, and just yesterday found out that after a while the system runs out of memory...