Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
How to get count of values in stored procedure
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Sivakumar
8y
366
1
Reply
Hi,
I want to get count of Job status like count of open,count of closed jobs and count of processing jobs
This is my procedure :
USE [SmartJob
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[GetJobStatus]
@CompanyID INT
AS
BEGIN
SELECT [StatusID]
,M.Value 'Status' FROM Jobs J
JOIN Master M ON M.MasterID=J.StatusID
WHERE CompanyID=@CompanyID;
END
Please help me
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
how to count group by in sql server
Use of ADO.Net and its function