MS SQL Store procedure $15 max
Budget: $10 – $30 USD
got 2 sp and having a issue the first one when run
exec spGetReportDepartSalesALL @Storeid = '1001', @lodate = '07/28/2021 00:00:00', @hidate = '07/28/2021 23:59:59', @Stationid = '', @departlist = 'DRINKS', @cashierid = '1001003'
work
when run via c# it show up like this and does not work
exec sp_executesql N'spGetReportDepartSalesALL @StoreID, @lodate,@hidate,@Stationid,@departlist,@cashierid',N'@cashierid nvarchar(4000),@departlist nvarchar(6),@Stationid char(2),@StoreID char(4),@lodate char(22),@hidate char(22)',@cashierid=N'',@departlist=N'DRINKS',@Stationid='01',@StoreID='1001',@lodate='06/29/2021 12:00:00 AM',@hidate='07/28/2021 11:59:00 PM'
exec spGetReportDepartSalesALL @Storeid = '1001', @lodate = '07/28/2021 00:00:00', @hidate = '07/28/2021 23:59:59', @Stationid = '', @departlist = 'DRINKS', @cashierid = '1001003'
work
when run via c# it show up like this and does not work
exec sp_executesql N'spGetReportDepartSalesALL @StoreID, @lodate,@hidate,@Stationid,@departlist,@cashierid',N'@cashierid nvarchar(4000),@departlist nvarchar(6),@Stationid char(2),@StoreID char(4),@lodate char(22),@hidate char(22)',@cashierid=N'',@departlist=N'DRINKS',@Stationid='01',@StoreID='1001',@lodate='06/29/2021 12:00:00 AM',@hidate='07/28/2021 11:59:00 PM'