This is a change to a report that I created that's in testing--hasn't been released. I really appreciate the info but it's almost "TOO MUCH INFO".

I'm working with a...

Okay, I'm confused. I have the @RowNum = RowNum in the last code snippet I posted. And that would be the clustered index, but I don't want to use it...

Thanks for the replies.

To the person with the link re running totals, thanks much, that's where I originally got this code. The "with tablelockx" (not viewing it right now-spelling?) never...

I really appreciate all the replies. I figured there had to be a way to specify an index on this, but could not find it in any of my books....

I got the Running Balance code off the Internet and it worked well. Until I tried to do it again.

Oh, the report has been through many iterations but it runs and is now in Crystal with the SQL Server stored proc as a data source. It's currently in testing...

Yes, I checked them and they were missing. Which is another odd thing. I've never had to add them myself.

I've done that. It won't Verify and if I try to Change DataSource I just get in a loop. I feel like I need to reinstall Crystal or SQL Server,...

Thanks for all the suggestions. I changed it to a varchar in Crystal and just convert it to a datetime in the proc. It works although there's some string manipulation...

I get the same results that you show. However, when I put it in my stored proc, I get no results and I should. Don't know if anyone wants to...

Thanks! It worked great!

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

--===== Create the...

I did post some sample data and table structure. Wish I'd copied it somewhere.

I'll try again below here:

OBJ_ID MATRIX_CAT MX_VALUE

16109 ...

Yes, I wondered if you'd recognize Lawson.

I'm kind of a SQL Server newbie and don't have any direction or standards here but my logic created something no one else, including...

Sure. It's a long one--it branches off into one of two options--I think I'll just paste the top part to remove some bulk. Also my IT guy is installing virtual...