Awesome,

That's what I want...

Thank You!

Thank You For your help...

However I want only FirstName and LastName

the logic would be for FirstName = From Left to ' ' (First Space)

the logic would be for LastName =...

No No Please don't say Sorry.

I really appreciate your help.

I think i got it. Here is the final query.

Select

* from Test1 t1

Inner Join Test2 t2...

Hi Evil,

Thank You for your reply. Could you please help me with right-down the query?

Thank You for your reply. I really appreciate your sample data.

Your query is good for sample data. However I have 3m rows in my database and i want, IF are...

Hi Guys,

I am thinking how i can solve my problem. I am thinking if someone can help me with my this question.

Let say here is my SP

Create Procedure...

Jason Thanks that's what i want.

Quick question. Let say i have three update statement instead of two

Update Test

Set UpdateField = Low

from Test

where MinDuration < 12

IF @@ROWCOUNT=0

BEGIN

Update Test

Set UpdateField =...

Ok, I am sorry if i am not explain you very well.

Let me try again. I change the Query Little bit...

Table Name = Test (Here is my main Table)

ID,DTypeID,MinDuration,MaxDuration,UpdateField

1,123,0,12

2,345,6,18

3,111,12,24

Here...

Let me correct something for make more sense.

Instead of Right and Left, Is High and Low.

Here is my SP (Inside SP)

-- I am update above table

Update Test

Set UpdateField =...

Awesome its work fine. Thank you Guys!

Good Question...

I am dam sure about this ALL SPS/INDEX/VIEW/TRIGG/ and so on are same (Prod/Test)

If i ran Same SP without any changes on Prod giving me Error and On test...

Awesome.... You are right the problem with two (Not IN) If i remove both logic SP Works fine with No problem. The Problem with One Not IN i think that...

I am Refreshing this Database from Production to Test (Everything is same except One day old data)

I will do that.

Quick Question. I am running same procedure in different Server and its working fine with no Problem. I ran this SP 10 time no deadlock problem.

Could...