Hugo Kornelis (2/5/2016)

---

Yes, you are right. I had overlooked that. Both rewrites of the ORDER BY are incorrect, it needs to be kept as it was (with the ISNULL or...

drew.allen (2/5/2016)

---

Hugo Kornelis (2/5/2016)

---

I didn't go over all your modifications, but this one just struck my eye.

I think you intended this to be:

ORDER BY MC.TerminationDate...

Hugo Kornelis (2/5/2016)

---

I didn't go over all your modifications, but this one just struck my eye.

I think you intended this to be:

ORDER BY MC.TerminationDate DESC,...

Some observations to add to SpaghettiDBA's comments:

1.Remove any unnecessary tables from the FROM list. Begin with the two left-joined views. Since they are left joins, they cannot restrict the output,...

No - thanks for pointing this out Luis. I was in the middle of building...

I agree with Luis, at least one of your columns is INT. Try this:

SELECT *,

CAST(

CAST(x.ThisYear AS char(4)) +

RIGHT('0'+CAST(Fiscal_Year_End_Month_Nbr AS varchar(2)),2) +

RIGHT('0'+CAST(Fiscal_Year_End_Day_Nbr AS varchar(2)),2)

AS datetime)

FROM ( -- sample...

kkbear (2/4/2016)

---

I want to concatenate month and day in two columns to get date format with mm/dd. So I use below script.

CAST(b.Fiscal_Year_End_Month_Nbr + '/' + b.Fiscal_Year_End_Day_Nbr as datetime) as [Fiscal...

Or using the hardcoded crosstab model, this - which I find much easier to manipulate than dynamic SQL.

;WITH ExtraGroup AS (

SELECT LOB, Attribute, Value, grp = ROW_NUMBER() OVER (PARTITION...

Try this filter:

WHERE run_time BETWEEN 0 AND 300

Stuart Davies (2/4/2016)

---

BL0B_EATER (2/4/2016)

---

ChrisM@Work (2/4/2016)

---

Stuart's BS...

Brandie Tarvin (2/4/2016)

---

Stuart Davies (2/4/2016)

---

BL0B_EATER (2/4/2016)

---

ChrisM@Work (2/4/2016)

---

Luis Cazares (2/3/2016)

---

This got me by surprise. I'm not searching for jobs, but it got my attention because it was totally unexpected (but possibly...

SteveD SQL (2/4/2016)

---

Hi All,

In most of my tables I have Active and Inactive columns as most of the time I can DELETE record I just need to 'inactivate' them.

I was...

Better still, write it in a way which is most likely to be performant as well as correct. It's very little extra work:

-- SARGable Solution

DECLARE @StartDate DATETIME = '20130101'; --...

Stuart's BS guru would be a...

silverbullettruck (2/3/2016)

---

Here's the situation with the LOB = MNS. MNS has two different properties for the XLOB (ML and MS), for those two different XLOB values there are differing...