Not something I recommend. The view will have to be recreated every time a new agents table...

DBayliss, if you can follow t.brown's advice, that would be the best solution to your issue. If you are constrained from making changes to the existing schema, here are a...

We've had the same issue due to permissions and we've had the same issue due to missing or out of date dll files on our server.

Was this package developed by...

Yeah, the comment that led to...

jrichards54

Just a quick FYI: Next time you reply to someone's post and want to quote it, just hit the quote button instead of reply. It will use the forum code...

tua022012 (9/10/2012)

---

Thanks for your link. It's useful for our community.

Same material can be found at: Production executive interview questions[/url]

I hope it's useful for you and you like it. Please continue...

jasona.work (9/7/2012)

---

Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

Even if it is something that a seasoned DBA (not...

jrichards54

Can you post the latest installation log for SQL Server? The one from when you attempted to install and the it failed due to a blocked install.

Also, what features did...

jcrawf02 (9/7/2012)

---

Brandie Tarvin (9/7/2012)

---

All,

Tomorrow's SQL Saturday post is going to be about SQL Server resources. I'm including things like this forum, Tek-Tips, a few blogs, Twitter hashtags.

Does anyone have recommendations...

All,

Tomorrow's SQL Saturday post is going to be about SQL Server resources. I'm including things like this forum, Tek-Tips, a few blogs, Twitter hashtags.

Does anyone have recommendations for resources that...

You can use an expression to calculate based on a value of a variable. The variable will be what you alter based on what's coming in.

Because I don't know anything...

I believe you have to nest your IIF code to account for all possible permeations of the parameters. It's been a while since I used SSRS, though, so I'm not...

It's been too long since I used SSRS that I can't answer the first part of your question.

RE: The \ mark, are you absolutely positive that the expression is correct?...

The only way to do this (and it's not a good way) is to create an expression that populates a T-SQL task that creates the Excel spreadsheet on the fly.

The...

I don't remember what the default environment is set up on 2k5. I use Empty Environment so that I can connect to whatever I want. But when SSMS is opened...