maybe

http://www.sqlservercentral.com/articles/Hierarchy/94040/

Found this article:

http://www.sqlservercentral.com/scripts/LAG/89769/

If you had 2012, you could use LAG or LEAD to look at previous/next records and do math on values between records, but since you can't...

Task 2: Use REPLACE. Look it up in Books On Line.

Task 1: Find all records that begin with 'THE '. Play with RIGHT() to strip it off.

...

Here's a solution... tried it and it looks like it works:

https://skamie.wordpress.com/2012/05/21/ssrs-format-option-for-milliseconds/

Thanks for the DDL... that' helps a lot. But could you post the result that you are looking for? Then someone can figure out how to do the query.

I'm just trying to protect myself from the infamous MDB corruption issues. That and allow for a lot of data... so we'll see. Just don't know how I...

oh, sweet! That's handy! So I just have to use Windows Scheduler directly instead of using a job (which probably talks to Windows Scheduler)... Okay.

Thanks!

So you have data that's not clean? You might want to look around here for Fuzzy Matching articles. If you have SQL Server Enterprise, you can use it...

REPLACE is your friend...

One of these should do it:

http://www.sqlusa.com/bestpractices/training/scripts/commadelimitedlist/

Most if this is trivial once you set up the calculated column/field/whatever you call it in the dataset. Then anywhere you want to show this value, you'd use the...

You could set the Fill color of a cell using something like this:

=IIF(Previous(Fields!Company.Value)=Fields!Company.Value,"Red","Transparent")

Here's how I did it.

Steps:

1. addd a tablix to your report.

2. Add Company, PurchaseOrder, PurchaseDate fields to the tablix.

3. Right-click the body line (with the lines).

4. Add Group: Parent Group

Group...

If you're in your dataset, you'd create a calculated column and use IIF(Parameters!MyParam="9999","ShowThis","Show That") Then just use the calculated value instead of the numeric value. Then you can...

ROFL... maybe I need a binary calendar?