ALTER PROCEDURE [dbo].[Spstore] @Storeid char(5), @startDate datetime, @endDate datetime AS BEGIN SELECT * FROM [dbo].[sales] where Stor_id = @Storeid and ord_date >= @startDate AND ord_date <= @endDate END
Storeid
startdate
enddate
SELECT * FROM [dbo].[sales] where Stor_id = @Storeid and ord_date between @startDate AND @endDate
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)