I have to laugh! :hehe:

And that then leads to the question of borrowing a book from a guy who...

As if we don't have enough to discuss in this thread! 😀

I go with Books, BookReviews and BookAuthors.

This is a style issue...

Obs (11/20/2007)

---

My opinion says that yeah, this was a meant to be spot the flaw in the design (hence the title). Understandably, you could say flaw #1 are the...

Obs (11/20/2007)

---

harald_m_mueller, I think your missing the spirit of what Steve is trying to put out. Yes, there could be a better description of what requirements are, but as...

This (and some of your others) is a great comment, Harald.

You have written exactly what I was thinking and often think in these situations. Very nicely done! 🙂

harald_m_mueller (11/20/2007)

---

Sorry if...

Just for fun :D, here's the same sort of thing using the recursive CTE technique...

[font="Courier New"]DECLARE @String VARCHAR(255)

DECLARE @Delimiter CHAR(1)

DECLARE @Occurrence INT

DECLARE @Num_Fields INT

SET @String = 'A,B,C,D,E'

SET @Delimiter = ','

SET...

Nice work Jacob.

Here's a 3rd way, this time using XML PATH...

SELECT

OrderHeader.Name AS 'OrderHeader/Name',

OrderHeader.Address AS 'OrderHeader/Address',

OrderHeader.Code AS 'OrderHeader/Code',

...

Steve,

It looks like this...

-- Declare some local variables. Actually, we are creating...

Yes, I know about that (it's in...

I'm with Adam, check out MVP Erland Sommarskog's article on this: http://www.sommarskog.se/dyn-search.html

However, for the example presented by the article, can someone tell me what's wrong with simply this?...

select

...

Hi Peso - wrong site for the yak reference isn't it?

I just realised, we can use this little trick...

SELECT

ColA

Hmmm - I'm surprised!  I reckon you should use Jason's since what I gave won't give you what I think you want for some...

Hi Sho,

This works against your sample data, but I've a feeling you're going to post more data where this doesn't give what you're looking for!

/*

Summary

Method1     Method2     Method3     Method4

----------- ----------- ----------- -----------

2539        1976        1057        2476