Viewing 15 posts - 1 through 15 (of 29 total)
I would suggest building a 'Calendar' table that contains fields that contains fields pertaining to your fiscal year and fiscal period information. It could also include the regular calendar...
May 3, 2016 at 1:20 pm
Hi Jeff,
For us, yes. We had backups and file transfers happening between locations.
Bill
September 29, 2015 at 10:28 am
Hi EB,
I had been in a similar situation shortly ago. In a nutshell, our issue was an inadequate storage array. I would analyze disk performance using iPerf or...
September 28, 2015 at 9:57 am
Just wanted to post a solution I've implemented with help from:
and
http://www.sqldbpros.com/2012/05/create-a-list-in-your-ssrs-tooltip-not-impossible/
The first link explains a method to create a 'KeyField' that joins multiple values into...
April 23, 2015 at 9:05 am
The blades were upgraded to 5.5 about 6 months ago. About a month ago, firmware was been updated on the blades to current levels.
It is on Windows 2008 Standard....
April 1, 2015 at 2:43 pm
Yes. Log files are clean.
This issue appears to be only on the updates from a SQL task. Inserts via a Transform Data Task have been ok.
April 1, 2015 at 12:01 pm
Thanks Aaron. I'm planning on moving from an old DTS package to SSIS once we convert to 10. I will remember that.
Will a Data Conversion component catch those...
February 18, 2014 at 6:23 am
Hi Aaron,
I understand your dilemma. I also import from a version 9 database nightly into SQL. 10 is supposed to be coming soon here...
I'm afraid I can't offer...
February 17, 2014 at 6:26 am
The link is similar to what I referred to in the first part of my reply. Yes. It is a hyperlink between reports.
The bookmark method can link within the...
October 31, 2013 at 1:26 pm
Hi DBA,
There isn't a way to replicate excel-like tabs except doing so with images, and then linking to a different report.
An alternative that may give you what you need is...
October 31, 2013 at 11:49 am
One solution is to create a Calendar table.
You can have as many date related fields as needed.
The structure might be something like this:
Date CalendarMonth ...
July 26, 2013 at 11:06 am
Hi Mark,
This will do the trick for you:
If Not Exists (Select ....)
Begin
RAISERROR ('Aborting report because no data was found.', 16, 1)
End
Else
Begin
Select ....
End
I found this in another post some time ago,...
December 14, 2011 at 2:25 pm
I would use the sub-report method.
Use an 'outer' table or matrix so that you can control the page breaks by customer. Then embed the detail sub-report in...
September 23, 2011 at 6:26 am
Viewing 15 posts - 1 through 15 (of 29 total)