Early in my career I had difficulty saying no and it nearly wrecked my life both personally and professionally. Afterwards, I've tried to live by the motto that "You...

One of the...

Good demonstration. Too many folks don't realize that an INTERSECT is essentially like an INNER JOIN (or rather it's the other way around!).

Eric M Russell (10/1/2015)

---

I simply tell family and friends that I work in Information Technology and then tell them what the company does. I don't provide more detail about my...

Interesting comments Steve. I too, have seen the "big data" bandwagon that so many have jumped onto recently as though it's something completely new. There are relatively new...

David.Poole (8/27/2015)

---

The point I was trying to make was that by using and extremely close relation of SQL on the NOSQL store you almost encourage people to use the wrong...

maximilianorios (8/27/2015)

---

The problem sometimes is people became fans of something and try to stick a solution into everything when it's the opposite, we need to understand the problem to find...

Very interesting article. I've had my eyes opened quite a bit lately concerning NoSQL environments and I've reached the following conclusions:

1. NoSQL solutions definitely have their shining moments and...

I know that there is a lot of concern and even some fear about the capabilities of AI, however I don't think that we have to worry about it for...

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...