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'
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'
8 freelancere byder i gennemsnit $17 timen for dette job
hi i can run this store procedure within C# i have expertise in C# with more then 7+ years of experience please ping me for further discussion Thanks
Hello good day, I have 3+ years of experience in C#, SQL and .NET. I can help your fix the error with the stored procedure. If you award me the project, I'll start working on it right away. Thansk