convert to UDF from select statement
Posted
by jeff
on Stack Overflow
See other posts from Stack Overflow
or by jeff
Published on 2010-05-06T22:54:54Z
Indexed on
2010/05/06
22:58 UTC
Read the original article
Hit count: 156
How would one go about converting this into a UDF? I'll pass the product_id to the UDF.
Running SQL 2k5
SELECT
sum(qty) as qty,
product_id
FROM vProductQuantity
WHERE
product_id = @product_id
GROUP BY product_id
© Stack Overflow or respective owner