Sean Lange (2/6/2014)

---

marcipesa (2/6/2014)

---

something like this?:

http://stackoverflow.com/questions/17604893/how-can-i-match-the-sum-of-a-subset-of-items-to-a-target-number%5B/quote%5D

Yeah something like that. Notice the looping, this is a performance killer in sql. You have the added complexity of a number of...

Sean Lange (2/6/2014)

---

ChrisM@home (2/6/2014)

---

Hey Luis I don't know if you can see what I've just seen on this funny little mobly but you my friend may just be the first!...

How are you choosing index 2 over index1?

Why would you choose index 2 over index1?

What happens when you run each query two or three times?

What do you mean by this, Jeff? Match up with what exactly?

Hey Luis I don't know if you can see what I've just seen on this funny little mobly but you my friend may just be the first! Whether you are...

Any time. Have a look at LIKE in Books Online when you get the time, it's tremendously useful.

Use NOT IN ().

Why are you using LIKE?

Post the actual execution plan as a .sqlplan attachment - there may be scope gor optimisation that you've missed.

p.swathi4 (2/3/2014)

---

I had setup linked server and when i query the it gives me below error.

QUERY:

SELECT top * from [Servername].[WH_SYSTEM].[dbo].T_ENCOUNTER_PHYSICIAN

WHERE PhysicianID LIKE '[0-9]%'

Output:

Msg 7357,Level 16, State 2, Line 1

Cannot process...

p.swathi4 (2/3/2014)

---

I had setup linked server and when i query the it gives me below error.

QUERY:

SELECT top * from [Servername].[WH_SYSTEM].[dbo].T_ENCOUNTER_PHYSICIAN

WHERE PhysicianID LIKE '[0-9]%'

Output:

Msg 7357,Level 16, State 2, Line 1

Cannot...

Try this. The results are very close to your desired results set, and I can't tell if it's because the arithmetic in the query requires modification or if the desired...

Michael Meierruth (2/2/2014)

---

Thus are you referrring to CROSS...

Exceptionally difficult. Extending Jeff's request for clarification, here's a stab at something which may help to describe the problem.

SELECT

CASE...

Can you confirm which version of SQL Server you are using? Your code fails with an error (Ambiguous column name...

You should investigate the results from the SELECT part of your INSERT query, not just this time, but every time. The same applies to UPDATEs and...