Tell me, is this (third post) just fixing the symptom, not the problem?

smer (5/18/2016)

---

Thanks Lynn Pettis for your code...

code showing many rows . It is possible to have one row result year to date ,only i have to pass the @processdate...

smer (5/18/2016)

---

Experts !

Below iam posting the table, sample insert and query ,which i am using. I need when ever i give the end date like '1/7/2014' the results comes ...

Tac11 (5/18/2016)

---

Jack, you said "Another way to explain it that the included columns should be columns that you don't search on, but will return" , I got it, thanks for...

Lynn Pettis (5/18/2016)

---

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Grumpy DBA (5/18/2016)

---

jasona.work (5/18/2016)

---

Brandie Tarvin (5/18/2016)

---

Oh, my. SS just rebuked someone for asking what SS thinks is an...

Really?? You still trying to pad your post with this nonsense? Please, give it a break and stop it.

Or like this:

d e c l a r e @ProcessDate datetime = '20151005'; -- spaces added to allow code to be posted

select

dateadd(month, datediff(month, 0, mt.START_DATETIME), 0)...

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Grumpy DBA (5/18/2016)

---

jasona.work (5/18/2016)

---

Brandie Tarvin (5/18/2016)

---

Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question....

GilaMonster (5/18/2016)

---

No it doesn't.

Nolock can ignore locks of others because it doesn't take shared locks. If it...

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Grumpy DBA (5/18/2016)

---

jasona.work (5/18/2016)

---

Brandie Tarvin (5/18/2016)

---

Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it...

Grumpy DBA (5/18/2016)

---

jasona.work (5/18/2016)

---

Brandie Tarvin (5/18/2016)

---

Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question. And in this case it probably is, but SS is...

Why do people choose to ignore good advice and just push for the answer to their question like that is the needed solution. Not saying their question shouldn't be...

celia.moreno (5/18/2016)

---

The main question is if it is possible to manage/limit processors used per database.

We have to add some logic to this data and this will penalize processor disponibility...

b ghanekar (5/18/2016)

---

I want to ignore the "Sale" transactions from FIFO processing where no preceding buy transaction is available or there is no inventory available.

I am doing it this way...

Kris-155042 (5/15/2016)

---

I originally posted this in the wrong section....sorry

We have a server on 2012 R2 Windows and 2014 SP1 Enterprise SQL. It seems to run out of memory even though...