Posted by Tony Rogerson on 12/05/05 18:53

Rich,

So you've never had a requirement as a developer to show a comma seperated
list on the screen, i've done a lot of CRM development and that requirement
is very frequent.

Concatenating on the server scales significantly better than passing back
all the rows to the client/middle tier.

In SQL Server 2005 we can do it in one very simple statement utilising FOR
XML extensions, this makes for less code, less complexity and the logic is
coded once in a central location - do you not agree that is good?

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Rich Ryan" <ryanrj@sbcglobal.net> wrote in message
news:OIKkf.3048$rq3.2138@newssvr19.news.prodigy.com...
> Joe, I'm with you on this one. These young gunners seem to think of RDMS
> as
> a file access mechanism. Just read the MYSQL Newsgroup. BTW I'm about your
> age.
>
>
> "--CELKO--" <jcelko212@earthlink.net> wrote in message
> news:1133687403.902376.122910@g44g2000cwa.googlegroups.com...
>> Could you explain why you want to violate
>>
>> 1) The foundation of RDBMS, First Normal Form?
>> 2) The most basic rule of a tiered architecture?
>>
>> If you have a solid reason, woudl you mind publishing it, since that
>> would overturn 30+ yers of RDBMS and 40+ years of Comp Sci.
>>
>
>

[Back to original message]