Viewing 5 posts - 1 through 5 (of 5 total)
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.
September 4, 2015 at 4:20 am
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.
July 3, 2014 at 6:07 am
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...
April 29, 2014 at 2:57 am
You should put Exit Sub before error label statement...OR put your original code so we can find your problem and give proper solution...
December 4, 2011 at 9:42 pm
It is much easy in Excel...
Open Excel and Add value in A1 cell -> GBP500
Write in B1
Write in C1
After that you can add Excel data into your Table...with 2 column
August 23, 2011 at 11:20 pm