However, the main part of the issue appears to have been to do with Namespaces.

;WITH XMLNAMESPACES('http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd,

'http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition' AS cl,

DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition')

, base_bin AS (

SELECT

itemid,

creationdate,

modifieddate,

name,

xmlcontent = CAST(CAST(content AS VARBINARY(MAX)) AS XML),

type,

createdbyid,

modifiedbyid

FROM...

For those looking for sample content. This is straight out of SSRS's database... If you have an SSRS instance, it's available to you....

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">

<AutoRefresh>0</AutoRefresh>

...

I've got 5 years of...

Christian Bahnsen (1/24/2012)

---

I find a calendar table with pre-defined columns for month, fiscal month, etc., and other columns like YYYY-MM is invaluable for aggregating and sorting data like this.

Joining the...

I was surprised this didn't cover ROLLUP, CUBE, or GROUPING SETS myself.

TheSQLGuru (1/24/2012)

---

1) as others have stated that triangular join (xx <= yy) is gonna kill you performance wise as number of rows increases.

2) cursors are still the fastest supported way...

That's what I was thinking... I had to harken back to Advanced Concepts in C... at least it was...

And it seems that Steve has corrected the question 🙂

Steve make Happy Panda now!

I too must jump in and ask for the question to be corrected 🙂

Having implemented Resource Governor, I opened up a workload Group, because for the life of me I...

Hugo Kornelis (1/20/2012)

---

paul.knibbs (1/20/2012)

---

No I wouldn't....

I...

I had actually read that already, thanks!

No the SP I have plus the format file above actually works.... Up until then I had been trying to get by without a...

I'd like to point out that this is just a modification to the stored proc that somebody else put out there a while ago

http://www.codekeep.net/snippets/41a15075-29ea-4d7d-bb9f-6bd2eec45807.aspx

GSquared (1/18/2012)

---

What happens if you have a cursor step through the rows in sys_mail tables that you need, and call sp_send_dbmail using the values from that table?

I've done that before,...

L' Eomot Inversé (1/11/2012)

---

Nice and simple.

I'm very surprised there's only 34% correct so far, although I would expect the wiggle on whether no other user is connected to a...

cengland0 (1/10/2012)

---

mtassin (1/10/2012)

---

Oracle supports storing timezone with dates.

http://docs.oracle.com/cd/B14117_01/server.101/b10759/functions179.htm

Using the portability defense really isn't a good idea... each DB server is different enough, that queries that can run on all of...