whatsthehampton
Programmer
Hi Guys,
I'm using this sproc in sql server 12 locally.
CODE -->
ALTER PROCEDURE [dbo].[Admin_Metrics_GetApplicationsByJobID]
(
@JobID int
)
AS
SET NOCOUNT ON
select
uniqueappid,
cast(a.appdate as datetime) as xdate ,
sum(appcounter) over (order by appdate rows unbounded preceding) as cumulativeapps,
(u.uFirstName + ' ' + u.uFamilyName) as x2name
from tbl_Applications a
INNER JOIN tbl_MD_userDetails u
ON
a.UserID=u.UserID
where jobid=@JobID AND astatus > 0
group by a.appdate, a.appcounter,a.uniqueappid, (u.uFirstName + ' ' + u.uFamilyName)
order by xdate;
RETURN
However my remote server is version 11 and this code appears not to work - I guess the highlighted line.
Does anyone know what I could use in place for sql 11 please?
It's used for a chart that shows a running order of job applications in a line chart.
Cheers,
Jack
I'm using this sproc in sql server 12 locally.
CODE -->
ALTER PROCEDURE [dbo].[Admin_Metrics_GetApplicationsByJobID]
(
@JobID int
)
AS
SET NOCOUNT ON
select
uniqueappid,
cast(a.appdate as datetime) as xdate ,
sum(appcounter) over (order by appdate rows unbounded preceding) as cumulativeapps,
(u.uFirstName + ' ' + u.uFamilyName) as x2name
from tbl_Applications a
INNER JOIN tbl_MD_userDetails u
ON
a.UserID=u.UserID
where jobid=@JobID AND astatus > 0
group by a.appdate, a.appcounter,a.uniqueappid, (u.uFirstName + ' ' + u.uFamilyName)
order by xdate;
RETURN
However my remote server is version 11 and this code appears not to work - I guess the highlighted line.
Does anyone know what I could use in place for sql 11 please?
It's used for a chart that shows a running order of job applications in a line chart.
Cheers,
Jack