"Lorem ipsum dolor sit amet..."

+1

That is cool SQLRNNR.

I don't know if this would always work, but this at least works for the given puzzle to return it in 9 x 9:

SELECT TOP 9 SUBSTRING(s,...

eseosaoregie (4/21/2010)

---

I created the computed column...

try:

comp_column IN ('mon ','tue ','wed ','thu ','fri ','sat ','sun ')

Glad it was helpful.

Yes, I generally create a view limited to the records that will likely match. The Fuzzy lookup is very intensive and the more limited you are comparing against, the...

I would check the Custom Properties of the Fuzzy Lookup. If the Exhaustive property is set to True, I've seen it take forever. The Reference index settings may...

I enjoy an afternoon on the golf course (on company time and money) from time to time 🙂

Could you post a small sample file (~100 records) that has the rogue record in it? And perhaps a screenshot of what the package looks like, sources, transforms and...

Inside the Fuzzy Lookup transform, on the Columns tab, right click one of the links between the fields and select "Edit Mappings". There you can set a minimum similarity...

[font="Arial Black"]ARIAL BLACK[/font]

is there an advantage to using a fixed width font? or is it personal preference?

Glad most folks liked it. Here is the actual code (you'll have to remove the *'s around amp to make it work):

WITH cteData (ID, Colors) AS

(SELECT1, 'Blue'

UNION

SELECT2, 'Red'

UNION

SELECT3, 'Yellow'

UNION

SELECT4,...

Oops, and for the other days of week path:

DATEPART("dw", GETDATE()) != 2