ChrisM@Work (12/15/2016)

---

Indianrock (12/14/2016)

---

Yes ORM-generated sql. Ours is a version called Domain Objects written by a former developer here. Others include Entity Framework and Hibernate. That sql...

TheSQLGuru (12/14/2016)

---

You may have missed it Lynn, but this is an ORM app. I doubt very much it is going to be reworking that query much at all, almost certainly...

Luis Cazares (12/14/2016)

---

Just a word of caution.

Handle the quotes correctly on Scott's and Lynn's examples. You might end with strings with the value 'NULL' instead of NULLs for the columns....

This is what make SSC so great. The multiple solutions offered for a single problem.

junk.mail291276 (12/14/2016)

---

Hello,

I have a stored procedure that takes a project ID as a parameter and returns a list of results on that project. Now what I'd like to do is...

Jacob Wilkins (12/14/2016)

---

Oh, I wasn't even any kind of thought at that point.

It's less the number of earth-round-the-sun circuits completed and more my lack of any sort of graceful...

Jacob Wilkins (12/14/2016)

---

Well, the fact that you beat him doesn't change the fact that he beat me 🙂

Just means two people beat me, so I'm even older and slower than...

Jacob Wilkins (12/14/2016)

---

Lynn Pettis (12/14/2016)

---

Jacob Wilkins (12/14/2016)

---

The problem is that when StartDate is not null, you convert EndDate to VARCHAR and then concatenate it with a bunch of strings without...

Jacob Wilkins (12/14/2016)

---

The problem is that when StartDate is not null, you convert EndDate to VARCHAR and then concatenate it with a bunch of strings without checking whether it is...

This works:

DECLARE @startDate DATETIME,

@endDate DATETIME,

@Description VARCHAR(10),

@Code...

Doug.F (12/14/2016)

---

Here's the Query:

SELECT

[description],

CASE WHEN startDate IS NULL

THEN

CASE WHEN endDate IS NULL

THEN '(''' + [description] + ''',''' + 'NULL' + ''',' + '''' + 'NULL' + ''',''' + code...

First minor change to the code you posted earlier:

SELECT DISTINCT TOP 2000

CollateralGroupRequest02.SERVICE_REQUEST_ID AS PrimaryKey ,

...

Enough.

This is what is going to kill you in trying to improve the code:

Changing indexes is not always...

One, is there a difference cpu/elapsed time between the queries?

Two, scans are not always bad.