I usually try to make the query work outside the function first.

For example let's say i want to write a function which gives me monthNumber of the date passed...

Bob Hovious (8/25/2009)

---

Yes, I understand that it is an example. But it is inconsistent to hard code a set of values and then to say that a count...

Bob Hovious (8/25/2009)

---

If you are going to hard code the WHERE clause to be (1,2,4,8), why don't you just go ahead and say = 4?

What if someone makes a typo...

Two ways you can do it:

1) If you can add an extra parameter to your stored procedure then the following is a very simple solution, similar to what was suggested...

This is one of the way you can do it.

DECLARE @Table TABLE (

HeaderID INT NOT NULL

, InQty DECIMAL (18,6)

, UsQty DECIMAL (18,6)

...