Sorry I should have been more specific

This will replace the null PaymentDtTmStart in your stored proc with a minimum date and your

PaymentDtTmEnd with today's date .

...

Since this is a stored procedure, you could detect a null in the input variable and assign a value to the variable accourdingly ( if start date is null you...

http://www.novicksoftware.com/udfofweek/Vol2/T-SQL-UDF-Vol-2-Num-2-udf_DT_ToJulian.htm

Did you eliminate the sored procedure as the culprit in this case. How are the stored procedure run times, on the first day compared to a week after, when...

Having an index on col1 in Table D might help to an extent. You might already be doing that...if so ignore this message

Sorry about that...it should be a stored procedure.

you could get max(batchID) in your trigger and use plus 1 for this batch.

You might have concurrency problems if you do this.

Another solution will be

Have table for next...

Glad to help

None mentioned about using the new rank , or row_number functions. It sure is possibe using them..

well, How about splitting the select and update statements. Declare another variable, select your aggregate data into the variable and use the data to update the table.

If you have multiple...

If you can you locate the report in the report manager website. Click on the report and then on properties and then click on Edit under report definition. ...

I know you are trying not to modify the stored procedure. But I don't think there is a way to add additional values to a dataset that is fetched...

this sounds like a more easier solution than what I proposed.

If you use this query you can get all tables in a database

select table_Name from information_schema.tables where table_Type = 'BASE TABLE'

Use a cursor / loop to loop thru the...