Viewing 15 posts - 136 through 150 (of 541 total)
You will need to recreate the report and add a subreport.
April 30, 2014 at 11:30 pm
It all depends on your business rules.
If the rule is that you must identify each row uniquely within a table then you need the default primary key.
How will you join...
April 30, 2014 at 10:01 am
I fixed your sample code and added default parameter into the sproc.
CREATE TABLE ind_state (
ind_stat_id INT
,ind_state_name VARCHAR(50)
)
INSERT INTO ind_state
VALUES (
'1'
,'Pondi'
)
,(
'2'
,'TamilNadu'
)
CREATE TABLE ind_state_dist (
ind_dist_id INT
,ind_dist_name VARCHAR(100)
,ind_stat_id INT
)
INSERT INTO ind_state_dist
VALUES (
'1'
,'mahe'
,'1'
)
,(
'2'
,'KaraiKal'
,'1'
)
,(
'3'
,'Chennai'
,'2'
)
,(
'4'
,'Salem'
,'2'
)
CREATE TABLE...
April 30, 2014 at 9:33 am
try this:
((ISNULL(Lkp_DATEENROLLED) ? (DT_DBDATE)"1901/01/01" : Lkp_DATEENROLLED)
!=
(ISNULL(DATEENROLLED) ? (DT_DBDATE)"1901/01/01" : DATEENROLLED))
April 29, 2014 at 2:59 pm
Jeff Moden (10/28/2013)
I just didn't have the time to warp the data into a table.
Dwain's solution is pretty much the same (just missing pre-aggregation but not a big...
October 29, 2013 at 12:32 pm
dwain.c (10/27/2013)
Jeff Moden (10/25/2013)
Hey Alex,Throw your test data into some readily consumable code and I'll be happy to show you how to do this.
I'll be a little more...
October 27, 2013 at 11:03 pm
Jeff Moden (10/25/2013)
Throw your test data into some readily consumable code and I'll be happy to show you how to do this. See the article at the first...
October 27, 2013 at 11:03 pm
Thank you Sean and Geoff.
Geoff you're right about
#2 it is 12:00 - 12:59
#4 thank you.
May 20, 2013 at 12:07 pm
There is a table in ReportServer DB called RunningJobs but it does not update instantly during report execution.
So you have to tweak RSReportServer.config RunningRequestsDbCycle and set it to 15 or...
April 26, 2013 at 1:09 pm
Sean Grebey (4/19/2013)
AndrewSQLDBA (4/18/2013)
What tool? Redgate had a large collection of different pieces of software. Have to be more specific.Andrew SQLDBA
Sorry, SQL Compare.
A tool we can use to make sure...
April 19, 2013 at 1:48 pm
alchemistmatt (4/18/2013)
Matt
By how much does your dba database grow daily?
Alex S
Good question; I hadn't checked yet. Turns out I can use the FileStatsHistory table data to answer your question:...
April 19, 2013 at 1:33 pm
alchemistmatt (4/16/2013)
Expand [Filename] to NVARCHAR(255) when creating table #BACKUPS. I have...
April 17, 2013 at 4:32 am
This is awesome.
Thank you.
April 15, 2013 at 3:04 pm
Have you tried log shipping?
Log shipping only copies and restores tran logs and you only need a full backup restored once on your destination.
March 21, 2013 at 3:45 am
this is how it was done in the past
http://www.sqlservercentral.com/Forums/Topic1142962-391-1.aspx
March 21, 2013 at 3:41 am
Viewing 15 posts - 136 through 150 (of 541 total)