Home

/

SQL Func Sales By Store MS

Func Sales By Store MS

CREATE FUNCTION SalesByStore_MS(@storid varchar(30))
RETURNS @sales TABLE(title varchar(80), qty int)
AS
BEGIN
    INSERT @sales
        SELECT title, qty
        FROM sales s, titles t
        WHERE s.stor_id = @storid AND t.title_id = s.title_id
    RETURN
END 

GO
SELECT * FROM SalesByStore_MS  ('8042')