Viewing 15 posts - 526 through 540 (of 2,010 total)
Another late comer here, good luck Barry and best wishes for a speedy recovery.
-Luke.
March 15, 2010 at 6:50 am
So I may not be understanding your data all that well, some sample data and the relevant DDL of the tables would make this more helpful, check the first link...
March 12, 2010 at 2:26 pm
I'm not sure about doing this as a direct update vs. report manager but if you're looking for other avenues, I'd think you might want to try the webservice and...
March 12, 2010 at 11:18 am
I've used a variety of tools and am currently in a shop that used the ideara Diagnostic manager tool. IT seems to get the job done. I'd say...
March 12, 2010 at 9:33 am
Have a look at the sp_spaceused system stored procedure in BOL.
I think it will get you want you want.
-Luke.
March 12, 2010 at 9:10 am
Where I work now we have a small break room with a fridge micro etc, but that about it. I clear my head by taking a walk outside...
At previous...
March 12, 2010 at 7:21 am
Update OracleServer..OracleSchema.GM_ITM
SET LST_BUY_CST = (SELECT a.PS_COST
FROM SQLServer.SQLDatabase.dbo.GRS_COST_COMPARE a
INNER JOIN OracleServer..OracleSchema.GM_ITM b ON b.ITM_CD=a.ITM_CD),
LST_BUY_CST_CHNG_DT=GETDATE()
WHERE ITM_CD='042470'
AND
EXISTS
(SELECT a.PS_COST
FROM SQLServer.SQLDatabase.dbo.GRS_COST_COMPARE a
INNER JOIN OracleServer..OracleSchema.GM_ITM b ON b.ITM_CD=a.ITM_CD)
The portion I put in...
March 11, 2010 at 2:14 pm
CirquedeSQLeil (3/11/2010)
Jeff has quietly passed the 20,000 pt mark. No fanfare???Congrats Jeff.
Congrats Jeff! I wonder how long it be 'til he catches Steve?
Cheers,
-Luke.
March 11, 2010 at 12:09 pm
SQL Noob (3/10/2010)
March 10, 2010 at 1:39 pm
Job Name or Job ID? If it's the JobName, that is the same as the ScheduleID from the Reportserver database which you can use to join to the catalog...
March 9, 2010 at 12:34 pm
I can't say that I've ever done it without recycling the service. Even if it's possible, I'll still always stop/start the service because that way you know that...
March 9, 2010 at 11:45 am
I may be reading this incorrectly... Can you confirm the GUID that you get is that the GUID for the Subscription or something else? If it's the subscription you...
March 9, 2010 at 11:36 am
I suppose I don't get what you are trying to accomplish here.
You could put any number of textboxes, rectangles, lines or whatever else you see fit on the...
March 5, 2010 at 1:22 pm
Here's a link... http://lmgtfy.com/?q=ssrs+vs+crystal
From the 1st few results it looks like you might something from both sides of the discussion. Beware though that some of the info is a...
March 5, 2010 at 1:20 pm
I'm sure other may have better suggestions, but I'd think about using optional parameters. Pass in your data for table 1 and pass in A and B optionally. ...
March 4, 2010 at 2:25 pm
Viewing 15 posts - 526 through 540 (of 2,010 total)