I can think of...

Of course, this won't carry over server settings, logins, databases, et al.

So unless this is a new instance with nothing much set up on it, there's a lot more work...

Ed Wagner (9/24/2015)

---

Maybe reading the requirements is a part of the question. The "count of subjects" is different than the "count of distinct subjects". So very many times...

Did you try this single-step process?

SELECT EmailAddressID , EmailAddress

FROM dbo.EmailAddress

WHERE EmailCheckSum = CHECKSUM('TheMostInterestingMan@dosequis.com')

AND EmailAddress = 'TheMostInterestingMan@dosequis.com'

Although there are no guarantees of the order of evaluation of...

LAG and LEAD always...

Steve Jones - SSC Editor (9/16/2015)

---

The way this works in most applications

- I get data from the db, including a checksum

- I present the data to a use that may...

samot-dwarf (9/16/2015)

---

Even if he would use the correct order, he must not use CHECKSUM because it is not case sensitive (if you are using the default collation for your DB):

SELECT...

Steve Jones - SSC Editor (9/15/2015)

---

sknox (9/15/2015)

---

I said "No, never" because as written (with the incorrect order), the checksum Bobby calculates provides no valid information (not even a hint, as...

Steve Jones - SSC Editor (9/15/2015)

---

The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there...

I think the explanation is just plain wrong.

I don't see anything which would produce data types or numbers with the precision and scale of (2,1) or (1,1) -- 0.999...

Manic Star (9/10/2015)

---

My first encounter with it was someone...

Amazing! That's the same combination I have on my luggage! 😀

Hugo Kornelis (8/19/2015)

---

I almost got this wrong, because upon first reading of the question I thought this was about an execution plan operator.

Luckily, I remembered that the operator that the...

Alvin Ramard (8/17/2015)

---

Steve Jones - SSC Editor (8/17/2015)

---

Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.

I'll change the question, but I'm...

And here starts the obligatory pedantry. 😛

is not quite correct. The correct statement is:

In a conditional split transformation,...