Viewing 3 posts - 1 through 3 (of 3 total)
From Books On line: The syntax for declaring a cursor is:
DECLARE cursor_name CURSOR
[ LOCAL | GLOBAL ]
[ FORWARD_ONLY | SCROLL ]
[ STATIC |...
June 13, 2006 at 6:15 am
First I would recomend cleaning out "extra" chars like ".,-:;" etc. Secondly I would remove any common parts of company names or at the very least make sure that they...
February 16, 2006 at 5:26 am
Try Using a Table Variable:
Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources....
February 6, 2006 at 7:22 am