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

Filed under:
|
|

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

Related posts about sql-server-2005

Related posts about sql