So with the current table you need to have two more columns From Date and To Date.

Else have a new table as Price Master as detailed above.

Let me know if...

A typical Price Master table would look like the one below:

Product ID--------Price------From Date-------To Date

P001-------------100-------1/1/2013---------12/31/2013

P001-------------150-------1/1/2014---------12/31/2014

P001-------------175-------1/1/2015---------

Your logic would pick up the Price based on the current date residing between From Date and...

Thanks Jeff! I'll certainly refer these resources.

I think, I posted this question in wrong forum. Will post in SQL Server 2005 General Discussion. See you there 🙂

Oh, OK! Let me consult my architect and figure out the best solution. Thanks Jeff!

Agreed Jeff! That could be the reason why Microsoft also changed pie-charts to display disk status in 'My Computer' ;-).

Well, do you have any SQL script for getting the status?

Luke L (5/18/2009)

---

Is there any reason why you can't just do this all in one query in your database using a Join?

Instead of creating 2 datasets, just create...

Thanks peterzeke! Appreciate your detailed suggestions. I'll go through the links and re-analyze the requirement of pie charts.

Just came to know that Lookup can be another option. It works in SSRS 2008. Not sure if it's available in 2005. Let me check.

Rod at work (10/8/2013)

---

We have now migrated to SQL Server 2012, with SSRS 2012. Does SSRS 2012 allow for multiple sorts, or do you still suggest that we use a...

Hey BSRLong,

Where are you? And where is your solution? 😉

Raunak Jhawar (10/7/2013)

---

TFS is a great tool for source code version management but again TFS inherently would not serve your second requirement. You can fetch this data by querying the...

Jack Corbett (9/12/2013)

---

Rod at work (9/12/2013)

---

Jack Corbett (9/12/2013)

---

While it isn't ideal because it requires the report to be re-run if they change the parameter, I usually...

SSRS as such doesn't allow validations of parameters. But you may handle this using expressions to some extent. If your parameter meets certain criteria, then only assign dataset or set...

Thanks Jeff! That's indeed a valuable information.