I need a count from a query.

See more:

C#

ASP.NET

SQL

Hi,
I have a problem with the get a count with my regular fields.
This is my procedure

ALTER proc [dbo].[GetTotalJobs]
@keyword nvarchar(100) =null,
@location nvarchar(100) =null,
@company nvarchar(100) = null,
@title nvarchar(100) =null,
@take int,
@skip int,
@counts int out
as
begin

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON;

WITH CTE AS
(
SELECT   ROW_NUMBER() OVER (ORDER BY id desc ) Sno, Id,Title, CompanyName, LocationName, JobDescription,  DATEDIFF( dd ,CreatedDateTime, GETDATE()) AS CreatedDateTime from Job as c WITH (NOLOCK) 
where  CompanyName like '%'+ @company+'%' or Title like '%'+ @title+'%' or LocationName=@location or JobDescription like '%'+@keyword+'%' or Title like '%'+@keyword+'%'  
group by Id, Title, CompanyName, LocationName, JobDescription, CreatedDateTime
)
select * from CTE WITH (NOLOCK) where Sno between @skip and @take
end

In this procdure I want to return count also as output parameter @counts

Please help me...
Thank you....