CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

Lynn Pettis (4/14/2010)

---

And I did. Just waiting...

You need to convert this all to dynamic sql. And, the object names (in this case, the column names), can't be dynamic. Something like this:

DECLARE @sql VARCHAR(8000)

SET @sql =

'SELECT...

You're using CharIndex wrong... you reversed the parameters.

Try:

SELECT CHARINDEX(char(153),'AAAAAAAA™BBBBBBBBBBBBBB')

Lynn Pettis (4/14/2010)

---

And I did. Just waiting now to...

Mister Ken, I think the problem with the original query you posted is that you built a derived table, and properly aliased it, but then when you joined it to...

CirquedeSQLeil (4/14/2010)

---

WayneS (4/14/2010)

---

In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?

The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query....

Tammy,

Glad to be able to help you out. We know you're an "accidental DBA", and most people here will try to help you out.

One reason some people won't help out...

In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?

The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You want...

TAMMYAUDETTE (4/14/2010)

---

I reallly feel like this is something that is simple, but I'm completely missing the logic.

I have a report I'm building, a report of SKU numbers with sold...

bill.brazell (4/14/2010)

---

This is looking very promising. Thank you.

As for the output, I'd prefer that it not include the name of the delimiter, only the value. i.e. "Ping" instead...

In the next-to-last INSERT, you have TBMLxxx. It also looks like you did a cut-and-paste and have several lines of -- this should return TBM419, when TBM419 is not in...

Did you get the column converted to a datetime data type? If so, that constraint won't help you.

UPDATE myPoorlyDesignedTable

...

Awesome! thanks - it's been added to my code snippets templates.

And as is typical for code coming...

Hey... ya snooze, ya looze. 😉 😀