There are several options for these problems called gaps and islands. You could look for more information, but here's a good article: https://www.simple-talk.com/sql/t-sql-programming/the-sql-of-gaps-and-islands-in-sequences/

Here's an option:

WITH CTE AS(

...

Hardy21 (7/22/2014)

---

You can pass selected values as comma separated string. With below method, you can insert only selected values to table.

DECLARE @weekdaySelected NVARCHAR(50)

DECLARE @tableT TABLE

( ClassName NVARCHAR(10),

WeekdaySelected NVARCHAR(50))

SET @weekdaySelected...

Following Anthony's 8 parameters idea, but replacing the 7 IFs with a single WHERE. 🙂

DECLARE

@class char(1) = 'A',

@sun bit =...

Hey Bob,

I suggest that you stop using rCTEs to count as they're a form of hidden RBAR and will cause problems. And low row counts don't justify the use of...

So you went and read the page for the exam on Microsoft Learning https://www.microsoft.com/learning/en-us/exam-70-461.aspx. You can find a section called Preparation Options whoch include a variety of ways to prepare.

Additional...

Why? How do you know you should get to 20, 40, etc? What are your expected results? Could you post sample data in a consumable format?

You still need the groups and column identifiers....

Because the cursor is set to delete one ServiceLogID at a time.

Even after reading the comments, I'm not sure that it's a good solution, but I don't know the entire...

jarupan (7/18/2014)

---

Hi Grant,

This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I...

The problem is that you're using old outer join syntax. You just need to change it as it's no longer supported.

SELECT a.assignee,

...

I'd say that the hardest feature to learn, is the one that you don't care about. I can learn many things as a developer, but don't ask me for HA...

Sorry, not from me. I'm not sure I can work something out without some sample data to test.

Even if Jeff posted his great article, I wanted to post this thread where I compared the performance in 2 different scenarios.

http://www.sqlservercentral.com/Forums/Topic1537999-392-1.aspx

You could try it yourself and compare results. 😉

You seem like a fast reader. It...

Maybe a simple preference to use cross tabs instead of pivot. That's my case at least.

Cross tabs...