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.
LVL 4
Moizsaif123Asked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems 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
All Courses

From novice to tech pro — start learning today.