You have forgotten that not all of the UK has the same bank holidays.

Your case statement isn't doing anything, it always returns the value of ExpiryDate.

Your problem is that you can't compare things to null using anything other than 'is null'.

why would you want to do this in a cursor?

but if you really do, you need to get the next record in the while loop, or @@Fetch_status will...

Having just moved from SQL 2008, I'm finally able to use this improved version of the splitter function.

I have just one comment, the ISNULL(NULLIF(LEAD(s.N1,1,1) over (order by s.N1)-1,0)-s.N1,8000)...

I think you just need this where clause:

where column_2 = 'Y'
and (Column_1 <> 4  or column_3 = 'X')

You don't have a 'top 1000' clause in your select statement when you are actually testing this do you?

You solution 1 works fine, the problem must be in your code that is drawing the chart.

If you add some SQL to your solution to do the group...

You should be doing something along the line of

insert into answers
select appropriate fields
from #myTempTable 

(this is obviously a very simplistic example, you may need an unpivot...

The reason your loop never stops is because @@rowcount is updated by the insert statements.

However, your whole code example is not a good way to write SQL code....

The sql string that you are creating to execute is just wrong. There's the change Sue_H explained, but you also need to declare @r in @sqlrun, set it...

We use R to do similar processing. As we don't have SQL 2016, we use the standalone version of R called by a SSIS package which reads and writes to...

TomThomson (12/17/2016)

CELKO (12/14/2016)

You are missing...

You have posted the part of your problem that works, not the part that doesn't work, so it is impossible to help you.

If you post the code you are using...

Your function does what you expect it to do, so if you are seeing wrong results somewhere, it is being caused by how you are calling it.

Try selecting from the...

Removing the 'As Lastname' and 'AS Firstname' words should fix it