SQL Func Sales By Store MS
SQL
Download (.zip)
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')
|