Hello and welcome to the forum.

You almost certainly don't need a cursor for this but to get the best help we'll need a bit from you.  It's much easier to...

This may sound like an extremely basic question but what's the difference between an execution error and a syntax error in this case?  The message that I get suggests that...

• This reply was modified 6 years, 2 months ago by Neil Burton.
• This reply was modified 6 years, 2 months ago by Neil Burton.

But why are you copying the code the get the answer in the first place..?

Trust but verify 🙂  Besides, a true smart-alec would have known that a '\' would be...

I copied,  pasted and ran the code as-is and got the wrong answer.

It'll have to be a cowboy outfit.

I did have a solution that worked without a calendar table but I spotted a mistake.

It's probably worth pointing out that there is no 31st of June.

• This reply was modified 6 years, 3 months ago by Neil Burton. Reason: Mistake spotted

Haven't been to Edinburgh since I was about 14, but planning to go there next...

We have a table with one column as UTC and another as local time.  So far this hasn't caused any (major) problems but I'm pretty sure that it will bite...

There are, essentially, no moving parts or complex electronics to go wrong.  It just works.

I would suggest that you look a little closer. There are a hug number of...

The Mark I mirror is a device where the phrase 'if it ain't broken, don't fix it' is extremely apt.  There are, essentially, no moving parts or complex electronics to...

I used to have a pair of running shorts with a key pocket at the back.  One morning I waved my wife off to work, took a look at the...

Yes I agree this website is slowing down. Not just performance but activity as well.

On another topic of slow...here was this last weekends goods from the smoker.

<li style="list-style-type:...

It's transactional replication. We do rebuild indexes on the publisher but they shouldn't get replicated.  The other reason this is unlikely is the timings of the growth events doesn't coincide...

And they've changed their minds.

• This reply was modified 6 years, 5 months ago by Neil Burton.
• This reply was modified 6 years, 5 months ago by Neil Burton.

I'm not sure that it's the kind of thing that will affect many people immediately.  It's going...