with SET FMTONLY, it doesn't do any data changes, just gives you the schema of the result. So passing in any old default value for the parameters will be fine.

Run...

In general, IIF(X,Y,Z) equates to CASE WHEN X THEN Y ELSE Z END

IIF(X,Y,IIF(A,B,C)) would equate to CASE WHEN X THEN Y ELSE CASE WHEN A THEN B ELSE C END...

Actually - having just thought about it - I am wondering if it executes it using SET FMTONLY ON.

If I use the following:

SET FMTONLY ON

GO

EXEC stproc_test

Then it immediately returns with...

Very interesting...

Did you run a profiler trace? I'm intrigued now... 🙂

I tried to download it and have a look, but the download link was broken :/

My guess is that it is executing the procedures in order to look at the...

One bit to bear in mind is correct lexical state, for example

-- /*

Print 'hello'

-- */

prints hello, even though it is between two '/*' and '*/' markers. Might be worth replacing...

RBarryYoung (9/28/2009)

---

Whoa, before you change the subject yet again, Matt, I want to be clear on this. You do now admit that I never said "your test case is...

Really not a problem 😀

I'm not... What I'm...

RBarryYoung (9/28/2009)

---

And I supplied the SOP solution to a case like that. I am not going to spend my time trying to develop tools to handle every strange code mutation...

The simple answer - SSMS is tolerant to line breaks in any style, unix, mac or windows. unix line breaks are Char(10), windows line breaks are char(13) + char(10). If...

I think that's the case in forums in general, isn't it? There...

I'll post the reply here, rather than in the lots of times you've asked this question! 🙂

You haven't really been very specific about what you need, but probably the best...

There's some info on the following link that may help:

http://support.microsoft.com/kb/309802

Hope it does 🙂

Barry

That's a test case. Can you really not imagine a procedure like this, which would also cause the posted code to fail:

/*

* Procedure: stproc_CreateProcessRequestItems

*

* Purpose: Create process...