To repeat (emphasis mine):

Sean Lange (12/6/2016)

---

I sure wish JC would get off his high horse once in awhile. His constant diatribe about portability is a joke. Then he berates posters for not making...

As was asked earlier, can you post the execution plan as a .sqlplan file.

My only other question is why the dynamic SQL for a query that doesn't need it?

How many rows of data are you expecting to be returned with query posted?

SQL Server may be doing and clustered index scan (also known as a table scan) because it...

Jeff Moden (12/3/2016)

---

As you can see, the neat thing about nice simple answers is that they're nice and simple to...

Did nobody see my solutions? My first one even I said had a problem with a leading zero but in my second posting I fixed that.

Updated:

DECLARE @sec INT;

SET @sec = 50096;

SELECT @sec;

SELECT

CAST(DATEADD(SECOND,@sec,0) AS TIME),

CASE WHEN @sec < 43000

THEN CAST(CAST(DATEADD(SECOND,@sec,0)...

Too much work. Looks like we are using SQL Server 2012 based on where this question is posted. The following will work on SQL Server 2008 and newer:

DECLARE...

ThomasRushton (12/2/2016)

---

Let me guess - this is the Canine...

BWFC (12/2/2016)

---

Luis Cazares (12/1/2016)

---

Lynn Pettis (12/1/2016)

---

For someone who has been "around" SSC as long as "he" has, he sure hasn't changed in all these years.

I stayed away and thinking I...

For someone who has been "around" SSC as long as "he" has, he sure hasn't changed in all these years.

I stayed away and thinking I will bypass him in the...

Lynn Pettis (11/29/2016)

---

manie (11/28/2016)

---

Lynn Pettis, can I sue because I fell of my chair laughing and broke my leg!! Wahahahaha!!!! You guys are...

trhorner (11/29/2016)

---

Normally I would agree, but in this case I was going across two versions. That being said, I have received my answer so no need for anyone on...

Don't think...

chrisn-585491 (11/28/2016)

---

Lynn Pettis (11/28/2016)

---

Iwas Bornready (11/28/2016)

---

Yev.d (11/24/2016)

---

Happy Thanksgiving to all!

You don't have to be an American to count your blessings and be thankful. 🙂

mjh 45389 (11/24/2016)

---

t.franz (11/24/2016)

---

Who do you...