kramaswamy (11/28/2011)

---

Jason that's a pretty cool function. I'm curious why it's not used more often? Is there any reason to use LEN instead of DATALENGTH, other than if you are...

Use DATALENGTH instead.

DECLARE @i VARCHAR(99)

SET @i = '123 ' --- the #'s 1,2 and 3 plus two spaces

SELECT len(@i), datalength(@i)

Lowell (11/26/2011)

---

when upgrading to a higher version, you'll want to rebuild the indexes and update statistics.

There are a lot of similar posts, where the upgraded server performs poorly until those...

domciccone (11/28/2011)

---

Both excellent responses. Thank you. I tried the "mailto:" approach and it works very nicely but I probably can't use it as a solution because we actually...

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...

mister.magoo (11/28/2011)

---

Do your users have email applications on their desktop?

If so, why not just use a mailto: action?

Go into the textbox properties, select Action, Go to URL and enter an...

You'll also need to insert a space before the time portion.

CDate(DateValue(dateadd("d",-1, Globals!ExecutionTime)) + " 04:00:00")

Is this a typo in your post or in your code ...

Parameters!Duration= "3"

Should be .....

Parameters!Duration.Value= "3",

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...

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....

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...

Well, that's not true. You...

Are you going to ALWAYS have two values?

Yes = Procedure

No = depends 😀 but probably a procedure of some type.

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...

What is the overal task? Why do you need to enumerate through the columns?