Viewing 15 posts - 211 through 225 (of 1,183 total)
kramaswamy (11/28/2011)
______________________________________________________________________
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. SelburgNovember 28, 2011 at 1:36 pm
Use DATALENGTH instead.
DECLARE @i VARCHAR(99)
SET @i = '123 ' --- the #'s 1,2 and 3 plus two spaces
SELECT len(@i), datalength(@i)
______________________________________________________________________
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. SelburgNovember 28, 2011 at 10:59 am
Lowell (11/26/2011)
There are a lot of similar posts, where the upgraded server performs poorly until those...
______________________________________________________________________
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. SelburgNovember 28, 2011 at 10:41 am
domciccone (11/28/2011)
______________________________________________________________________
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. SelburgNovember 28, 2011 at 9:42 am
I've found the one and only thing that can mitigate the impact of this kind of stress is communication.
I was recently involved in a rather large company acquisition/merge project...
______________________________________________________________________
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. SelburgNovember 28, 2011 at 9:30 am
mister.magoo (11/28/2011)
If so, why not just use a mailto: action?
Go into the textbox properties, select Action, Go to URL and enter an...
______________________________________________________________________
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. SelburgNovember 28, 2011 at 7:32 am
You'll also need to insert a space before the time portion.
CDate(DateValue(dateadd("d",-1, Globals!ExecutionTime)) + " 04:00:00")
______________________________________________________________________
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. SelburgNovember 28, 2011 at 7:23 am
Is this a typo in your post or in your code ...
Parameters!Duration= "3"
Should be .....
Parameters!Duration.Value= "3",
______________________________________________________________________
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. SelburgNovember 28, 2011 at 7:19 am
I'm not sure if the "code" approach would work, but it's worth a try.
Another solution is a bit of a trick.
Add a parameter in the procedure that supports the report...
______________________________________________________________________
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. SelburgNovember 28, 2011 at 6:50 am
i'm making a bunch of assumptions on what how your report works, so bare with me... 😀
say your report simply lists all tables in the selected db's.
1. create the report
2....
______________________________________________________________________
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. SelburgNovember 23, 2011 at 11:59 am
You won't be able to use a multi valued parameter for the connection that way.
I would work it into the datasource's procedure. Something like ....
having the main proc accept multiple...
______________________________________________________________________
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. SelburgNovember 23, 2011 at 11:31 am
krypto69 (11/22/2011)
Thanks guys..sounds like there's no real way to enumerrate...
yeah guess I could always add an extra numeric alias ..but was hoping there was something intrinsic
Well, that's not true. 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. SelburgNovember 22, 2011 at 2:45 pm
Are you going to ALWAYS have two values?
Yes = Procedure
No = depends 😀 but probably a procedure of some type.
______________________________________________________________________
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. SelburgNovember 22, 2011 at 2:02 pm
I'm still not clear on what you mean.
Are you saying you are using a query to populate a table (that holds table/column names) then iterating through that and selecting data...
______________________________________________________________________
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. SelburgNovember 22, 2011 at 2:00 pm
What is the overal task? Why do you need to enumerate through the columns?
______________________________________________________________________
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. SelburgNovember 22, 2011 at 1:39 pm
Viewing 15 posts - 211 through 225 (of 1,183 total)