Viewing 6 posts - 1 through 6 (of 6 total)
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.
May 23, 2014 at 2:20 am
#1715976
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...
February 12, 2014 at 6:04 am
#1688312
thanks everyone, will get to work
July 5, 2013 at 7:40 am
#1630074
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...
June 10, 2013 at 8:19 am
#1622461
StackOverFlow: calculate 3 working days before in stored proc using Holidays lookup table
June 10, 2013 at 2:23 am
#1622332
thanks I got some answers on StackOverflow, one even using master..sp_spt
June 7, 2013 at 10:21 am
#1622130