Home

/

SQL Func Sales By Store

Func Sales By Store

CREATE FUNCTION SalesByStore(@storid varchar(30))
RETURNS TABLE
AS
RETURN (SELECT title, qty
        FROM sales s, titles t
        WHERE s.stor_id = @storid AND t.title_id = s.title_id)

GO
SELECT * FROM SalesByStore  ('8042')