Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

stored proc

I want a stored procedure that accepts 3 param (userid,fromdate,todate) from table "JobCard"

and it should display 3 columns from this table(Ticket#,Description,Duration).

I am new to storedprocedures so need help in executing/creating it.
0
Moizsaif123
Asked:
Moizsaif123
1 Solution
 
Carl TawnSystems and Integration DeveloperCommented:
Maybe something like the following (assumptions made about a couple of columns since you haven't provided a schema for the table):
CREATE PROCEDURE spGetJobCardDetails
    @UserId INT,
    @FromDate DATETIME,
    @ToDate DATETIME
AS
BEGIN

      SELECT [Ticket#], [Description], [Duration]
           FROM JobCard
           WHERE [UserId] = @UserId
               AND [Date] BETWEEN @FromDate AND @ToDate

END

Open in new window

0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now