Viewing 15 posts - 1,066 through 1,080 (of 1,183 total)
No indexes or triggers on target table.
Recovery model is Simple and I've tried with recovery model of bulk-logged with no change.
I'm not sure if tempDB or the DB running the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 10:30 am
UNTESTED!!!!!
But at first glance, isn't this the correct syntax?
aReturnKeyPrm.Direction = ParameterDirection.Output;
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2007 at 4:21 pm
This also works....
SELECT
IndicatorName, DHBName, PHOName, PracticeName,
Numerator, Denominator,
sum(Numerator) OVER (PARTITION BY IndicatorName, DHBName) as DHBnumTotal,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 23, 2007 at 6:29 pm
You can also add the 2000 server as a linked server on one of your 2005 databases. This would give you the ability to use the 2005 features on the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 23, 2007 at 6:01 pm
What I was referring to is how are the emails being opened? Any report attachment that we send out will be fine if opened through the Outlook application, but if...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 23, 2007 at 5:52 pm
I'm pretty sure that the only things you need to do in the RDL files is...
- change the namespace.
- delete the entries for interactive width and interactive height.
I've had to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 23, 2007 at 5:46 pm
In SQL 2000 it's under user defined functions. In 2005 it's under Programmability > Table-valued functions.
This is all provided that your login has execute permissions on the function. If you...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2007 at 8:23 pm
You need to define the owner during the execution.
select dbo.split(name) from table
And actually since this is a Table-valued function, you need it to be in the FROM part of the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2007 at 6:54 pm
I believe this has been addressed in RS 2005 with the addition of the "Manage all subscriptions" option in role settings, but I'm not positive.
~~Sorry~~
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2007 at 6:51 pm
Are you experiencing the problem through the web exchange interface, outlook or both?
Have you tried sending the report to a hotmail or other type of email service?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 19, 2007 at 6:40 pm
That is not an easy task at all. If you can log into the 2005 report server and then "Edit" each report's definition, then you can save those report (rdl)...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 17, 2007 at 5:05 pm
This can not be set on a per-report/subscription level. You are correct, it can only be set server level.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 17, 2007 at 4:58 pm
With Visual Studio 2005 you can step through stored procedure execution. I've not done this, but I know you can.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 12, 2007 at 9:51 am
I read somewhere that it would be faster. I've never tested it though....
I'll have to look into that today. ----
I tested on a table with 1.5mil rows and it seems...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 11, 2007 at 3:58 am
Change the Count(*) to Count(1)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 10, 2007 at 8:23 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,183 total)