I do not know of a Global variable that reports last execution time, but you can get it by querying the ReportServer database, but it would probably be easier to...

A staging table is not a temporary table it is a permanent table which is used to get the data into the SQL Server database and then you use T-SQL...

Please do as Lowell has suggested in his last post. You definitely want you triggers to handle multi-row changes.

If you are going to another server I would recommend looking...

Wayne has probably provided the best solution, but you can get transaction information from the sys.dm_tran* management views. So you could write a script if you really wanted.

Nice article and very helpful for 2000 and 2005. As mentioned the capability to script data is now part of SSMS 2008.

The error message seems to be pretty clear to me. You need to add the Login to the database without assigning a default schema. I'm not sure why...

What about network traffic?

I agree it does appear to be caused by the Convert in the final WHERE clause.

You appear to have lucked out so far with IsNumeric() actually working the...

As a follow up to my other post, I do agree with GSquared that this stuff is usually easier to do in the application/report. For example SSRS (SQL Reporting...

Sounds like you could use Rollup or Cube see this article in BOL.

So are you saying that when you have no value for Sum(Fields!Count.Value) you also have no value in Fields!MetricSort.Value? Can you post a sample dataset?

Glad I'm not the only one that happens to. I'm in .NET...

In these cases I have created stored procedures on the source and then called the stored procedures. I have seen dramatic performance improvement in these cases.

Are any of the...

What's the data type for problem_code?

Could you move the filtering of problem_code into the derived table? If you do this, do you still get the error?

YSLGuru (6/30/2009)

---

UPDATE #2:

I managed to get this work, at least partially. If I explcitly turn on the 3 SET OPTIONS (that my app turns off) within the definition...