Home Forums SQL Server 7,2000 T-SQL Customize SQL Query RE: Customize SQL Query
John H Marsh
SSChampion
Points: 11671
More actions
July 11, 2009 at 9:42 am
#1023520
Hello,
Obviously I don’t know the structure of your DB, but would it not be possible to somehow replace the Cursor and Dynamic SQL with a Join on the NoSeriesMaster_Prefix table?
Regards,
John Marsh
www.sql.luSQL Server Luxembourg User Group