Jacob Wilkins (7/15/2015)

---

If I understand what you want, you don't need to partition the result, since you want the number sequence to persist across all the values, based solely on...

While there is added security through obscurity by using coded names and numeric sequences, it becomes very difficult for people to remember them or to distinguish them one from another....

Sean Lange (4/24/2015)

---

My guess is that if you had a single document stripped down like your example it would also take a lot of time to find the statement you...

Sean Lange (4/24/2015)

---

All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it across so many...

Michael Valentine Jones (3/31/2015)

---

It amazes me when they make a movie of an old TV series that I thought was terrible even when I was a kid.

Lost in Space

The Brady...

Steve Jones - SSC Editor (3/30/2015)

---

I agree. I've started to try this:

;

WITH myCTE...

Koen Verbeeck (3/30/2015)

---

Such a bad habit to start a CTE with

;WITH

I hate it :-D/quote]

I totally agree! This leads to sloppy code development and debugging nightmares. Besides, it's ANSI standard...

Gary Varga (3/23/2015)

---

He had extremely fond memories of it and felt that watching the series again, but a quarter of a century on and though adult eyes this time, would...

David.Poole (3/10/2015)

---

Years ago I raised the point that NOSQL actually meant NO-RDBMS and got shot down in flames. With the adoption of CQL, N1QL, AQL and lots of things...

Andrew..Peterson (3/10/2015)

---

Great, so...

It all comes down to this: use the right tool for the right job. NoSQL databases have their uses and function well in that space just as RDBMS databases...

I believe that this is consistent in style with operators such as IN.

Good introduction Steve! I've never used the SOME function before.

I think it's also pertinent to point out that the reason all 8 rows returned was because of the use...

I have to agree that in most business organizations, the IT department is treated pretty much the same as the maintenance department. It's always seen as a cost center,...

Yet, not surprising when you consider that the parent table has 1.85M rows, the child table has 7.5M rows, and the validation table has 54K. The indexes were optimized...