thanks.

They're both views but for the base table, BaselCollateralData I'll try adding a clustered index on the DataDate column and a non-clustered index on the Collateral ID.

hi,

Thanks for your reply.

I should mention that the remote linked server referenced by BOCTEST is an iSeries (so not a SQL Server). The stored procs I am checking are stored...

thanks everyone, will get to work

hi,

it would be Tuesday

An example from last month:

May 27th was Bank Hoiliday Monday, so if the [Date] columns shows any date after 22nd May then it cannot be deleted.

So that's...

StackOverFlow: calculate 3 working days before in stored proc using Holidays lookup table

thanks I got some answers on StackOverflow, one even using master..sp_spt