So, you have a current solution but would like a better approach?

You could try with EXCEPT or NOT EXISTS.

Here are the examples.

select PArtNumber,

Item

from #Table_Orig prev

CROSS APPLY dbo.DelimitedSplit8K(VALUE, ' ')

WHERE prev.FileVersion...

From the first line, it seems that you don't have permissions to SELECT data from a table.

It would help if you tell us what were you trying to do.

To help you, we would need some consumable DDL, sample data and expected results based on the sample data provided as noted in the article linked on my signature.

I know...

You could also avoid using dynamic SQL, even if it might reduce performance a bit.

You could try this.

DECLARE @ReportLevel AS VARCHAR(10);

SELECT *

INTO #TempLevels

FROM tblLevels AS a

INNER JOIN tblReports AS b...

Do you have some column to identify the night shift?

Otherwise, you would have to code exactly for that employee and it will fail when another employee takes the night shift.

Just another possible solution.

SELECT *

FROM DelimitedSplit8K(@test, ' ') x

WHERE CHARINDEX( '@', x.Item) > 0

For the code of DelimitedSplit8K please read the following article:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Use the same solution 😉

For this person or for his/her company?

Congratulations Lynn. Best wishes for the newborn...

I don't understand completely your problem. Please read the article linked on my signature to guide you on your posts and get better help. If you give me DDL, some...

You can't. You need to repeat the CASE statement for every column needed or change the logic.

Sean Lange (9/27/2013)

---

Luis Cazares (9/27/2013)

---

Sean Lange (9/27/2013)

---

Luis Cazares (9/27/2013)

---

Today, I'm really pissed off with the database and network administrators. Because of the lack of good planning and best practices, instead...

To add to what has been posted, you could read this article:

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)[/url]

EDIT: There's a good solution but you might not like it. Use TRY_CAST()...

+1 I've never used it before and had forgotten this function.

You need to add a MAX (or MIN) to your price columns and group by the others.