Viewing 2 posts - 1 through 2 (of 2 total)
Try the count with a nolock option. It will be a lot faster.
If you regularly import data. you'll probably never update the sql data anyhow. it is just storage...
October 15, 2009 at 2:10 am
#1066124
An actual answer to the question could be:
If there is no other way than to use a cursor here is a simple example you should be able to translate to...
March 12, 2008 at 3:43 am
#788443