Drat. You're right.

Oh well...

:ermm:

As proof of the technique, I offer...

DECLARE @TestTable TABLE

(

id INT

,testValue NVARCHAR(10)

,someNumber INT

);

INSERT INTO @testTable

(id, testValue, someNumber)

VALUES

(1, 'First', 10);

INSERT INTO @testTable

(id, testValue, someNumber)

VALUES

(2, 'Second', 3);

INSERT INTO @testTable

(id, testValue, someNumber)

VALUES

(3, 'third',...

If she gets any rows, she will get a zero trhough the case statement; that's correct. But if there are no rows she will only get null, and that's what...

halifaxdal (2/25/2014)

---

Hello,

I have an existing query:

SELECT

i.Division,

DocStatus,

...

mandavli (1/6/2011)

---

I have written scalar function named getCalcvalue that accepts 2 parameters and returns one parameters.

Now I want to call this from stored procedure.

so I have statement

declare @selVal as...

First off, it is good practice to use meaningful names for your parameters so when you revisit your code next year or someone else does they know what is expected.

That...

For years I took my vacation at the Pennsic War. A week or ten days in the Middle Ages, no cell phone, no computer, just battles and parties and a...

I originally learned the technique against SQL Server 2000, and never thought to improve it. Thanks for the suggestion! It's not bad for 25 years or so, but I can...

Thank you for pointing that out. I based the holidays on a list from the company where I worked at the time, and they didn't take that one off. It...