I think you can use a NullIf function in SSRS, but I'm not certain. If so, wrap that around the denominator, and wrap an IsNull around the whole operation....

Do you mean you need to have an on-the-fly credential, or you just need to specify a credential that has rights to the folder with the images, or something else?

The...

Reporting Services can do what you need. If you have a web portal already, it's pretty straightforward to plug in a report viewer and build some reports. You...

TAMMYAUDETTE (4/12/2010)

---

My experience:

Company sales are down, freeze on spending and I lost 3 team members to downsizing.

Bottom line, I'm trying to do it all myself. We still need to...

CirquedeSQLeil (4/12/2010)

---

Can't disagree about the mature technology - but my children always have their engines revved from pre-dawn to...

When you specify "External", it gives you the option of puting the path in there. It needs to start with "file:", then have a standard URL to a shared...

Jeff Moden (4/12/2010)

---

GSquared (4/12/2010)

---

Virtualization almost eliminates the need for it (federation) and the advantages of it. Improving virtualization will make "scale out" on SQL Server a moot point faster...

Yeah, the "high performance children" thing isn't a mature technology anyway....

Assuming,...

Jeff Moden (4/12/2010)

---

Bill Kline-270970 (4/12/2010)

---

I work in a multi db platform environment. We use both SQL Server and Oracle. I'm just a newbie when it comes to Oracle...

I'll give the same advice I always give on the subject of pivoting: Do it in the application, not the database, if it's for presentation to human eyes. Excel,...

Microsoft has an article on estimating index disk space at http://msdn.microsoft.com/en-us/library/ms190620.aspx. It includes data on the effect of nullable columns, which at least implies that indexes can contain null...

Save it as a string?

Yes, it does, because it makes that kind of query faster.

Well, the answer to #4 is let the front end application do it. Presentation data belongs in the presentation layer, not in the database. That won't get you...