Solved

stored proc

Posted on 2014-03-12
1
247 Views
Last Modified: 2014-03-12
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
Comment
Question by:Moizsaif123
1 Comment
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39923277
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now