Jeff Moden (5/19/2016)

---

Lynn Pettis (5/19/2016)

---

Steve Jones - SSC Editor (5/19/2016)

---

drew.allen (5/19/2016)

---

Would it be possible to limit posts based on the number of visits? I noticed that most of the...

Rod at work (5/19/2016)

---

Lynn Pettis (5/19/2016)

---

Here is a simple way to swap two values to ensure StartDate is less than EndDate:

d e c l a r e -- spaced to...

Steve Jones - SSC Editor (5/19/2016)

---

drew.allen (5/19/2016)

---

Would it be possible to limit posts based on the number of visits? I noticed that most of the spam comes from people...

Here is a simple way to swap two values to ensure StartDate is less than EndDate:

d e c l a r e -- spaced to allow posted from current location

...

Rod at work (5/19/2016)

---

Very simple question here. I've used SSRS on and off over the last 4 or 5 years. Often I've had to put up 2 parameters; a begin/start...

Lynn Pettis (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

drew.allen (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big...

smer (5/18/2016)

---

May be like that !

declare @ProcessDate datetime = '1/15/2015'; -- spaces added to allow code to be posted

select

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

Lynn Pettis (5/18/2016)

---

drew.allen (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in...

I'm thinking that...

drew.allen (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things...

Love OPs that change the requirements midstream. Show things as calendar year, then suddenly it needs to be fiscal year. Big difference in how things are computed.

Here is updated code. For 2015-10-05, it will go back to 2015-07-01 for the start of the fiscal year.

If @ProcessDate is 2016-06-30, it will still go back to 2015-07-01.

select

...

This is the first you...

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...

Found this on my Facebook newsfeed: https://www.packtpub.com/packt/offers/data-week-2016?utm_source=facebook&utm_medium=cpc&utm_content=us2&utm_campaign=data-week-2016.