Forget everything about table structure and table size...

Just replace NOT IN and IN from your query with EXISTS and NOT EXISTS. You will get good performance in your delete query.

Select 1 as [aliasname]

Result: 1 row(s) affected

Your result is [1 row(s) affected] so @@rowcount will have value 1.

SET NOCOUNT ON / OFF doesn;t matter with it.

As i read your question i found that you have page size problem with SSRS view and PDF view. Please check Page size property for both or you can check...

You should put Exit Sub before error label statement...OR put your original code so we can find your problem and give proper solution...

It is much easy in Excel...

Open Excel and Add value in A1 cell -> GBP500

Write in B1

=LEFT(A1,3)

Write in C1

=RIGHT(A1,LEN(A1)-3)

After that you can add Excel data into your Table...with 2 column