The word "Darwinism" comes to mind...

Ed Wagner (5/21/2015)

---

Jason A. Long (5/21/2015)

---

MikeTomkies (5/21/2015)

---

I have implemented Jason solution and understood it after reading the article thank you Jason. I see luis has improved it which i will...

MikeTomkies (5/21/2015)

---

I have implemented Jason solution and understood it after reading the article thank you Jason. I see luis has improved it which i will give it a try tomorrow...

I agree... I definitely like Luis' solution better.

Yes, I'm very familiar with how to do a cross tab query using aggregated case expressions... Unfortunately, that simply wasn't the 1st solution...

Take this for a spin. It seems to match your desired output...

-- Test Data --

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

DROP TABLE #temp;

SELECT

Part,

FifoCode

INTO #temp

FROM

( VALUES ( 'xxx', ' 1:2.0:2:2.5'), ( 'yyy',...

When I made the same switch myself, about 5 years ago, I used the 2008 version of this book... Microsoft SQL Server 2012 Reporting Services 4/E

It had me up and...

Here's another set of examples...

SELECT DATEADD(yy, DATEDIFF(yy, 0, CURRENT_TIMESTAMP), 0) AS FirstOfCurrentYear

SELECT DATEADD(qq, DATEDIFF(qq, 0, CURRENT_TIMESTAMP), 0) AS FirstOfCurrentQuarter

SELECT DATEADD(mm, DATEDIFF(mm, 0, CURRENT_TIMESTAMP), 0) AS FirstOfCurrentMonth

SELECT DATEADD(wk, DATEDIFF(wk, -1, CURRENT_TIMESTAMP),...

Steve Jones - SSC Editor (5/20/2015)

---

Disclosure: I work for Red Gate.

If you want to get Prompt and show it helps, I'd get some queries you normally write, and time the...

Alan.B (5/20/2015)

---

I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes...

Intellisense tends to work best when you give it a little help...

Stare your query like this...

SELECT

*

FROM dbo.MyTable mt

Now you should be able to go back into the select list...

SELECT...

If the rows are identical, how can can you have a "maximum"?

Are you trying to delete duplicate rows or simply trying to grab just 1 row from a set of...

Brandie Tarvin (5/20/2015)

---

Grant Fritchey (5/20/2015)

---

Again...

AAARRARARRGGGGHHHH!!!

Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint....

Yes I do. Thank you very much. Your answer, combined with Gail's, makes perfect sense. Case sensitive collation isn't something I use on a regular...

+1

Agree 100%

A "SELECT DISTINCT" won't do it. The INT column is unique is the original data and the same colors showing up more than once...