Viewing 15 posts - 4,831 through 4,845 (of 9,643 total)
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...
July 1, 2009 at 10:15 am
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...
July 1, 2009 at 9:52 am
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...
July 1, 2009 at 9:50 am
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.
July 1, 2009 at 9:16 am
Nice article and very helpful for 2000 and 2005. As mentioned the capability to script data is now part of SSMS 2008.
July 1, 2009 at 8:56 am
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...
June 30, 2009 at 3:24 pm
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...
June 30, 2009 at 2:58 pm
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...
June 30, 2009 at 1:33 pm
Sounds like you could use Rollup or Cube see this article in BOL.
June 30, 2009 at 1:28 pm
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?
June 30, 2009 at 1:10 pm
Lynn Pettis (6/30/2009)
Bored here at work today. I have things to do, but just can't get motivated.
Glad I'm not the only one that happens to. I'm in .NET...
June 30, 2009 at 1:06 pm
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...
June 30, 2009 at 12:06 pm
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?
June 30, 2009 at 12:02 pm
YSLGuru (6/30/2009)
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...
June 30, 2009 at 10:24 am
Viewing 15 posts - 4,831 through 4,845 (of 9,643 total)