The solution pointed to by Piet is a good starting point. I'd modify it to do something more along these lines:

SELECT

Catalog.Type,

Catalog.Name,

...

paul.knibbs (8/15/2014)

---

I turned 7 in the middle of 77--I just about remember all the bunting being up for the Silver Jubilee. Can't remember if that was the year that everyone...

Glad I could help. That UPDATE() function is a pain because it doesn't do what you think it should.

I didn't delve deeply into the data, but I generally avoid using BETWEEN when working with datetimes. For example a query with DateTimeColumn Between '2000-01-01' and '2000-12-31' does not...

There are so many variables in play. Server load, network load, locking and blocking that it is hard to be sure what is causing the problem.

Is the...

I agree with Koen and Phil, if this is a complete "wipe and load" then I wouldn't bother with partitioning since it just adds complexity. The Load and rename...

Not that I'm aware of. When you do export from a report, it exports the entire report.

Let's talk some basics. There are 2 types of data sources in SSRS, shared and embedded. A shared data source is a an XML file with a data...

Kevin and Sean both hit on one part of your problem, you are never referencing the virtual inserted or deleted table so you are getting every row in Users where...

LutzM (8/8/2014)

---

Expanding on Jacks solution, but eliminating the need to "hope" for @@DateFirst being either 1 or 0, here's an approach that's totally independent on the setting of @@DateFirst.

the biggest...

Jeff Moden (8/8/2014)

---

That's a recursive CTE that counts. Please see the following article for why that's a bad...

Steve has posted what is probably the answer, but it would be much easier to help if you posted an example of the query.

It sounds like you have cascading parameters and PPCQuery is a dataset that populates a parameter that is dependent on the value(s) in you are selecting in the Division parameter....

kherald provided a solution. Here's my take which still lets you use 0 for Sunday instead of 1 and also takes into account the Language setting of your SQL...

Tools for which option?

I believe you can find some scripts in the scripts section of this site that will automatically generate audit triggers for...