FYI... The FIFO problem was the subject of an SSC competition some years ago. Many interesting techniques to take into consideration: The ‘FIFO Stock Inventory’ SQL Problem

I was going to post what Jeff posted. :Whistling:

Luis Cazares (4/15/2016)

---

Alan.B (4/15/2016)

---

nagkarjun1 (4/15/2016)

---

Hi Folks,

I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

Updating/defrag Stats...

MadAdmin (4/15/2016)

---

Hugo Kornelis (4/15/2016)

---

TheSQLGuru (4/15/2016)

---

Wrapping a function around a column in the WHERE clause is probably the second worst thing I see in aggregate in my consulting (with the first...

nagkarjun1 (4/15/2016)

---

Hi Folks,

I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

Updating/defrag Stats and rebuilding indexes...

Below is how you'd do it if the data is stored as money or varchar...

-- if stored as money data type

DECLARE @x money = '$154,111.85';

SELECT CAST(@x AS decimal(10,2));

GO

-- if...

Interesting read Wayne. Good work sir!

This:

drew.allen (4/7/2016)

---

The replacement depends on the collation, and the default collation is case insensitive. Using the CHAR() function, does not change...

"SQL Server 2016 Developer Edition, when released later this year, will also be free. ":w00t::w00t:

Steve Jones - SSC Editor (4/7/2016)

---

Well, I'm going to opening day in CO tomorrow, for the first time in like 10 years. I used to go ever year when I...

Cubs first series was a 2 game sweep on the road outscoring the Angels 15-1. We're already 5 games up on the Cards. Feeling good here in Chicago.

So it's the first query in your proc taking all the time, the part that does the insert into #TempUsers. Quite frankly that plan does not look too terrible and...

That was my first thought. 😉

You just have templates. I just found this article: http://byobi.com/blog/2013/04/ssms-templates-for-ssas-developers/%5B/url%5D

Great article Luis. I have learned something new today. I never played around with snippets but have a dozen ideas how they can make life easier.