Brandie Tarvin (8/19/2016)

---

blink

blinkblink

Ummmm, that's how I learned it. Books and a small PC and...

And then we have people that think they can learn our job from a book.

Sean Lange (8/19/2016)

---

Jeff Moden (8/19/2016)

---

Heh... Cross out the "S" and...

Here is my solution:

declare @test-2 table(

PatientNumber int,

DischargeDate date

);

insert into @test-2

values (1,'2015-11-30'),

(1,'2016-01-01'),

(1,'2016-03-04'),

...

Grant Fritchey (8/17/2016)

---

Lots of different standards on this. My one suggestion, regardless of the method you arrive at, be consistent in applying it. Doing some stuff one way, other stuff...

CELKO (8/15/2016)

---

Me! Me! 😛 But which one? There have been:

1) go up or down from "x5" alternating.

2) go up or down from "x5" in a uniform random distribution.

3) go...

You might want to make your link clickable.

The Dixie Flatline (8/12/2016)

---

Lynn, have you tried using your tally table and substring([input],N,1) to reduce the [input] string to a series of individual characters?

You could put all your special...

Solomon Rutzky (8/12/2016)

---

Lynn Pettis (8/12/2016)

---

We aren't exactly sure. Some of them are from copy/paste from other sources into our application, some we have no idea at this point and...

Depending on the query, the column(s) in the INCLUDE clause could benefit the WHERE clause or the ORDER BY clause. It really comes back to "It depends."

It depends. ...

When you use the INCLUDE to add non-indexes columns in an index, that data is actually copied from the heap or clustered index into the nonclustered index. The included...

You are going down the path I was, just couldn't recreate the problem with a simple setup.

Solomon Rutzky (8/12/2016)

---

Lynn Pettis (8/9/2016)

---

Actually the upper ranges are being converted to '&#NNNNN;' where NNNNN is the numeric value of the Unicode character.

Here is the itvf I created for the...

With a simple setup I can't...