I finally got it. Yours worked but when I added some more data it broke it.

INSERT INTO [dbo].[TestTable] ([keyfield], [datefield], [valuefield]) VALUES (14, '20080902 00:00:00.000', 4)

INSERT INTO [dbo].[TestTable] ([keyfield],...

Msg 207, Level 16, State 1, Line 38

Invalid column name 'valset'.

You are calling cte2 from withing cte2. I'm trying to figure out what you are trying to do.

The data is correct. On the 15,16,17,20 there is a 6. I don't want to pull the 20th because it is not sequential. The 18th is a...

Given an employee table( with columns Emp_ID,Emp_Name,Emp_Salary), how would you find out the fifth highest salary?

with SalaryRank as

(

select Emp_id,Emp_name,Emp_salary,

dense_rank() over (order by Emp_salary desc) as SalaryRank

from Salaries

)

select *

from...

I just spent two days determining if the table variable approach was faster than the CURSOR approach.  It was a no-brainer.  The CURSOR approach was faster.  And it became even...

Is there any way to keep protect stored procedures in a multi-user environment?

Everwhere I've read about SQL Server and source control say it is "fully integrated" but thats all they say.

I want to know if it works like VSS does with my...