Would SSIS / ETL be a good solution, do you think?

http://www.developer.com/db/article.php/3497511

I'm not sure I fully understand the question, but we do something similar (I think) to what you're asking.

The application knows the logon user (e.g. dmn\jdoe)

But then it connects to...

Scott Coleman (8/7/2009)

---

Some problems call for an actual algorithm that can't be expressed in a single query. You might consider doing the column split in your web code instead...

Jeff Moden (8/17/2009)

---

Here's what you said, Beverly...

Think about...

Wow, Jeff. Way to make someone feel really good.

I had about a day to get this working before I went on a week off due to the...

Thanks so much for the replies, guys! I'm on holidays for a week but will try these out when I get back!

I should mention that I don't care at all what sequence the categories come out in. Right now the NTILE query is causing them to be alphabetical, but that's...

So what I've done on my website is the ASP code only looks at the column number when it changes categories, and ignores it from then on. So that...

Thanks, that looks promising. Is there a way to tell it to keep all of the items for one category together, though? If it has to be that...

barkha.javed (5/7/2008)

---

Hi Deepti,

As recommended by JayKay that's what I do too.

Example:="Report Period: " & Format("dd-mm-yyyy",Parameters!StartDate.Value) & " to " & Format("dd/mm/yyyy",Parameters!EndDate.Value)

To show multivalue parameters can try something like this:...

Wow, thanks that looks pretty easy! I'll try this first thing tomorrow!

(And no, it could be any status before and after MR status so your generic method is great)

Thank...