Thanks. I did consider including the first improvement, but decided to go with the less efficient...

I don't see a question here. If you're asking what the best approach to use is, it really depends a lot on what skills you have.

Personally, I like SSIS,...

Both Mark's and Kevin's solutions use a non-SARGable join. Here is a version where the join is SARGable. It also allows for variable length ranges. If you...

ScottPletcher (11/3/2016)

---

drew.allen (11/3/2016)

---

ScottPletcher (11/3/2016)

---

You could try limiting the pattern matching to only the text between "[whitespace-char]WHERE[whitespace-char]" and the next occurrence of "GROUP BY" or "SELECT". Of course that's also...

You should NOT be using SQL Profiler, which has been deprecated. You should be using extended events.

Drew

Assuming that the obvious solution isn't what you were looking for, try the following.

SELECT

CID,

MyCodes,

SUM(CASE WHEN MyCodes IN ('Full', 'part', 'Contract') THEN Hours END),

FROM MyClrTbl

GROUP BY ID, MyCodes

Although, it looks like...

I...

hegdesuchi (11/3/2016)

---

hi ,

Thank you!

I used distinct and got the answer.

I have to stage the data from XML file into different tables and then use joins to put them...

ScottPletcher (11/3/2016)

---

You could try limiting the pattern matching to only the text between "[whitespace-char]WHERE[whitespace-char]" and the next occurrence of "GROUP BY" or "SELECT". Of course that's also not perfect,...

Yes, I forgot to move the ORDER BY clause to the main query when I copied the first query to create the second query.

There is an extra END in the...

I think that UNPIVOT/PIVOT is overkill for this particular situation. I was able to get very close to your results using four simple CASE expressions.

SELECT *

,CASE WHEN wtt.Status =...

This looks like actual patient data. If so, it is a serious HIPAA violation. We don't need the name and phone number to solve your issue and it...

I stated on another thread that the number of different posts for this same query indicate that the OP is purposely fragmenting the discussion to hide the complexity of the...

The problem is here:

Insert Into Product (CustomerID, ProductId, OrderID, Quantity, Date1)

SELECT @CustomerID, @ProductId, @OrderID, 1, GETDATE()

From Product Where ProductId = @ProductId And CustomerID = @CustomerID AND OrderID <> @OrderID

UNION

SELECT...

Given the numerous threads the OP has started on what appears to be the same exact query, I think that this task is simply too complex to be handled in...