Very Useful script. Thanks...

Wat about the select list in the select statement. Are the columns fixed for one and both table search?

I have developed the sp for an interface with multiple controls on...

if IsNull(@ID,0) 0

Select ... where col = @ID

else

Select ...

Theatrical Release of Star Wars?

Nice well demonstrated article. Still alot of confusions in my mind that WHY to through this long procedure of creating project, adding query files (if talk about the example in...

From where to get the Notes / details of happenings of the Summit, if someone cannot attend.

Declare @aa numeric(10,2)

Set @aa = 1.60

Select case when @aa between cast(@aa as int) and cast(cast(cast(@aa as int) as varchar(10)) + '.25' as numeric(10,2)) then cast(cast(@aa as int) as numeric(10,2))

when @aa...

1. You SHOULD be able to insert data with or without Identity column.

Can you post the Insert statement?

2. To change the NON-Identity column to Identity column, go to the...

Very common issue.

Both options are workable. I think OP would be a better person to decide if his/her requirement is met of not.

Thats right. And thanks for pointing.

Also, '1d1' is a Numeric Value but generate error on conversion. The values are valid from '1d1' - '1d308' (if I am not wrong).

But it...

You can duplicte records by Count(*)/ Group By or Row_Number.

But how will you find out the latest update in those duplicate records. Is there any UpdatedOnDateTime column in your tables?

if you are willing to ignore records with non-numeric value in MPANCORE,

try this

select *

from thangela.NpowerNorthern_v1 a

INNER JOIN EPPS.dbo.Customers b ON case when IsNumeric(b.MPANCORE) = 1 then b.MPANCORE else -1...

Server-side Profiler trace will be the best option.

check this for help...

http://sqlserverpedia.com/wiki/Running_Traces_with_TSQL

As said by others, details required.

It will be better to avoid un-necessary indexes.