>>Here it is http://forums.asp.net/t/1305210.aspx
>
>That IS terrible programing!
>That guy hard coded some warehouse in its SP.
>No optional parameters no nothing.
>What if I want to get values for ALL warehouses? That SP didn't work at all.
>And he/she always hope that the table will have ONLY one record in table for some condition.
>Maybe that is true BUT that is only HOPE! :-)
>
>

Check what this guy came up with. I don't understand how does this select work, but he claims it does.