Ah, reading fail. I didn't spot...

R.P.Rozema (9/15/2011)

---

And add distinct to return only unique values.

edit: sorry, missed the group by

edit 2: the requirement "non duplicate rows" is not met yet. You could try something like this:

SELECT...

Hmm, seem to have missed a bit?

USE databasename

GO

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT all'

EXEC sp_MSForEachTable 'DELETE FROM ?'

EXEC sp_MSForEachTable 'ALTER TABLE...

Assuming I've read your requirements properly (your requirements are insane btw, sounds more like an academic problem than a real world one). . .

First, lets create some sample data: -

DECLARE...

Congratulations! Well deserved, your articles are always useful and insightful.

My advice will be unpopular, but I struggled to find my first development position so started off working for free at an NHS business intelligence solutions provider.

I had some difficulty...

What you're talking about is pretty much impossible to do accurately.

For example, to get the country out of that string, you'd need to already have a list of every country...

Beware, as I alluded to and GSquared explained, without an...

Could do with a way to order the results. Does this work for you?

;WITH addID AS (

SELECT field1, field2, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS rn

FROM #tmp1)

SELECT CASE WHEN...

I suspect that you are too busy to have had any opportunity to read any of the numerous blog posts on this subject that litter the internet.

So for your convenience,...

Read this link for how to post performance problems[/url].

From just looking at your code, it's difficult to suggest much other than the obvious.

SELECT A.[Product Number (SKU)],A.[Serial Numbers],

A.[Sell Through Quantity],A.[Seller -...

SP1

---

--EDIT--

MysteryJimbo (9/9/2011)

---

FWIW I can reproduce but...

Reproduced on 2k8 R2

I tried to get into software development for 3 years; calling, sending CV + Cover letter, and visiting many business both big and small in an attempt to get an...

There's no problem with the link provided by Gianluca, but if you can't access it then...