Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[JobsReportParams] (
- @FromDate DATETIME
- ,@ToDate DATETIME
- )
- AS
- SELECT installation_date
- ,company_name
- ,customer_name
- ,job_value
- ,admin_fee
- ,url
- ,files
- FROM tbl_jobs
- WHERE tbl_jobs.installation_date BETWEEN @FromDate
- AND @ToDate
- RETURN 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement