Not really. It is a pretty heavy duty procedure and it could cause more problems if the results come out unexpectedly.

I will have to run this process once a month...

Thank you. I didn't want to do that but I just kind of have I guess 🙁

I am going to go for the cursor...

At least I don't feel too guilty...

Yes, that is correct.

The procedure will use one field from each record of the selected list. and run it to process it.

The table will contain about 100K unique records

[AVG_DAYS] = AVG (dateDIFF(DAY,CTR_CREATED,CTR_UPDATED)),

CTR_UPDATED conditions are:

When CTR_UPDATED is not null ; if CTR_UPDATED> then month's upperbound then upperbound

When CTR_UPDATED is not null ; if...

Hi Chris,

I just realized a minor problem on the code you sent.

To handle [AVG-DAYS] we said to use when it is current month data CTR_UPDATED will be getdate()

So in...

Used stored procesure only and worked beutifully.

Performance is excellent.

Excellent. I will do that.

Never thought of that since I always used views for Crystal reports.

I learned new tricks today, I appreciate that .

I will display the results in Crystal reports for management.

And they may use it pretty often during each month.

Thank you very much.

I will have to double check my numbers but this seems to be the solution I was looking for.

If I wanted to create a view for this...

-same post multiple times; sorry

I have one problem here:

[AVG_DAYS] = AVG (dateDIFF(DAY,CTR_CREATED,CTR_UPDATED)),

How do we handle [AVG-DAYS] when CTR_UPDATED is null ?

when it is current month data CTR_UPDATED will be getdate()

when previous...

How can I handle AVG_DAYS when is CTR_UPDATED null.

Because if it is nul:

l for the current month we have to use current date time.

...

It seems like it doesnt like the parenthesis around (#Dates)

I am getting an error.

Msg 102, Level 15, State 1, Line 36

Incorrect syntax near ')'.

The syntax seems to be correct

I just added that.

Thank you.