Much simpler than you think - join to a tally table on dbo.SOP10200.QUANTITY.

What folks often forget about tally tables is that they are a source of rows as well...

Hey Gus, reckon you're still...

WayneS (12/3/2010)

---

Chris Morris-439714 (12/3/2010)

---

CirquedeSQLeil (12/2/2010)

---

Jack Corbett (12/2/2010)

---

For those not on twitter and who don't have my blog in their feed reader (shame on you!), here's the blog post I mentioned,...

The two-stage method mentioned by GSquared is outlined here.

Lemonwood makes an excellent bow, wonder if orange is any good?

CirquedeSQLeil (12/2/2010)

---

I am going...

Hi Wayne, no I've not done...

@leroy - thanks.

@scott - your method will almost certainly perform better than mine, with two analytical functions.

Maybe not - there's not enough info.

scott.pletcher (12/2/2010)

---

Barring some type of "fuzzy" update, the fastest way is probably to save your results as a temporary table, then use that table to UPDATE the original data and...

Try this, Tim:

DROP TABLE #Sentences

CREATE TABLE #Sentences (Sentence VARCHAR(100))

INSERT INTO #Sentences (Sentence)

SELECT 'QualificationsLength' UNION ALL

SELECT 'DepthMustBeNumeric' UNION ALL

SELECT 'HeightMustBeNumeric' UNION ALL

SELECT 'WidthMustBeNumeric' UNION ALL

SELECT 'DepthNotValid' UNION ALL

SELECT 'HeightNotValid' UNION ALL

SELECT...

Tim-24860 (12/2/2010)

---

I wonder if anyone could help me with a problem I'm having.

I have some data in a table that contains many joined words e.g. ThisIsASample

What I would like to...

Break? What do you mean?

Avoid? Yes of course - don't write your CTE as...

You might find it easier to use a temp table to hold your ranges. Finding the dupes is straightforward:

DROP TABLE #Person

CREATE TABLE #Person (Number CHAR(5), Firstname VARCHAR(20), Lastname VARCHAR(40), Email...

-- make some sample data, about 100,000 rows

DECLARE @variable TABLE (OneRowOfData VARCHAR(200))

INSERT INTO @variable (OneRowOfData)

SELECT '12345|name|domaine|category|2010/11/15|2011/10/30|2|' UNION ALL

SELECT '12346|name|domaine|category|2010/11/15|2011/10/30|2|' UNION ALL

SELECT '12347|name|domaine|category|2010/11/15|2011/10/30|2|'

INSERT INTO @variable (OneRowOfData) SELECT * FROM @variable

INSERT INTO...