OK I see your point, but it would also be bad practice to outer join on a constant. I think it's another reason to keep join conditions separate to filter...

Matt Marston (2/14/2013)

---

okbangas (2/14/2013)

---

My explanation might not be 100% accurate, but this is indeed the documentation I found when I ran into the issue demonstrated in the question. That it...

If my computer showed that time I would be concerned that it's in US format and not Australian (UK) format! :w00t:

And...

Oh this is very cool! Thanks for the link. I had some reports...

If your SSRS server is querying the operational database (OLTP) directly then I would put them on different servers. SSRS will use the OLTP server to process queries but other...

One issue with stored procedures in reporting services is that if the stored procedure is quite complex, e.g. has multiple select statements, that SSRS has trouble parsing them correctly to...

Thanks krysys for the suggestion.

I ended up using a row_number() over (partition by) construct to achieve what I needed, I should have followed up.

Thanks though.

Christian Buettner-167247 (1/29/2013)

---

bitbucket-25253 (1/29/2013)

---

davoscollective

A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1...

Interestingly, if you change the seasons to be three each on the correct months it gives the same result as the correct answer. (Correct months as per USA seasons,...

Wow, spinning up SSIS tasks on the fly to take advantage of multithreading. This is exploding my mind at the possibilities.

Thanks for this article, it's a great example to...

"Stairway to R" interactive lesson, great place to start & totally free.

http://tryr.codeschool.com/[/url]

NPV is a fairly straight-forward formula, assuming you have all your cash flow values in the same row, and you know the rate of return.

Unfortunately IRR has no straight forward...

Reading deeper into this story, it probably wasn't a patch to blame

"this was the result of Task Sequence distributed to a custom SCCM Collection. The Collection had been created/modified...

I think that you've done it the best way possible with 2005.

My apologies I didn't see that it was for BIDS 2005. I've logged on to one of my old SQL Server 2005 machines and luckily it had BIDS 2005 installed...