Advertisement
Dazzer1966

RDLC with parameters

Aug 3rd, 2020
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.28 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[JobsReportParams] (
  2.     @FromDate DATETIME
  3.     ,@ToDate DATETIME
  4.     )
  5. AS
  6. SELECT installation_date
  7.     ,company_name
  8.     ,customer_name
  9.     ,job_value
  10.     ,admin_fee
  11.     ,url
  12.     ,files
  13. FROM tbl_jobs
  14. WHERE tbl_jobs.installation_date BETWEEN @FromDate
  15.         AND @ToDate
  16.  
  17. RETURN 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement