You can rewrite the query but execution plan are same for both t-sql (index scan)

select * from contact where patindex('%a',first_name)>0

Please check below sql , might help you

select top 50 * from

(select top (90) percent * from table_name order by column_name ) t

order by column_name

Try to access the table same order in each procedure and use NOLOCK hint to avoid the sahred lock(while access the table ). It may help some exetend

Use table Variable instead of temp table

this may help if you Ignore only first number char from Str

select * from Table where isnumeric(left(column_name,1))=0

Below sql may help you ...

SELECT SUBSTRING(result,1,LEN(result)-1) AS [O/P]

FROM (SELECT LTRIM(SNO) + ','

FROM #ad

...

What about this...

exec ( @s1+ ' UNION '+ @s2 )

U can Use below sql query to count the record from any user table

select rows

from sys.sysindexes

where id = object_id('Table_Name')

and...

Server version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2...

Error message

The definition for column unique must include a data type.

Version

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005...

Error Message while execute statment

MSG 173 level 15

I Wish you all Happy Christmas!!!:smooooth:

T-SQL code

declare @t table (

CustomerName VARCHAR(30),

CustomerRefNumber int,

InvoiceNumber VARCHAR(20),

InvoiceAmount ...

I will do from next time . Thanks

Thank You , Greate Help