Just to encourage you, I have a table of the following "specs"...

52.1 GB

100 Million Rows

529 Bytes Average Row Size

With the Clustered Index in place, it only took 1 minute and...

You didn't read the article at the...

IIRC, you can edit the title of your own original post.

And, are you seriously stuck with SSRS 2008?

In other words, do like I previously suggested... read'n'heed the article at the...

If you're using >= 2017, the TRIM function in T-SQL will handle the removal of double quotes and spaces and whatever other leading/trailing characters you may have to work with. ...

You're still writing SQL as if you were in BASIC or Fortran. Let's start off with the create table statement. By definition, and not as an option, table must...

Sorry... originally missed the meaning here and took the post down and replacing it with the following...

Just use a WHERE NOT IN.  If something more sophisticated is desired, we'd need...

I strongly disagree... especially when someone claims that such a thing is a "practice", either...

Heh... it's funny... I see so many people saying that people who are resistant to change are stuck in a rut.  I guess it's never dawned on those people that...

Note to self: PPTS.

The problem is very likely that you're simply not doing any log file backups.  Full backups do nothing to clear the log file.

If you want to be able to do...

You need single quotes around the data that you're passing for @tempdata.  I've added them in Red... one before the starting bracket and one after the ending bracket.  Otherwise, your...

The method that both Ken and Phil are using is an arcane method known as a CROSSTAB and is a much more flexible manifestation than a PIVOT.

You can read more...

Another name for "conditional aggregation" is a CROSSTAB.  MS use to carry a full entry in BOL on it until they came out with PIVOT.  You'll be able to tell...