Adi, thank you for you answer.

When I have to use dynamic sql, security is no problem, because it's an "in the house" job, used for reporting.

But I was hoping for...

I think the code of Listing 5 and Listing 6 is mixed.

QUOTE

Example of using a Subquery in a Function Call

To demonstrate using a subquery in a function call, suppose...

Just a part of the "old look" is back. Only the links to "Featured Contents" and "Featured Script".

Still missing the...

The next disaster has struck.

Since July 17, the QOD (question of the day) has no "yesterday's answer" anymore. Why? :crying:

Please "consult" the responsible manager for these changes.

Jeff and Craig, thank you for answering my question.

@Craig: The suggestion of using a report is not possible, I am sorry.

I made a report function in my Delphi...

Hi Jason,

No answer from me 🙁

All tests went fine.

But the DBA refuses to do the changes, as long there is no really need for it. :unsure:

Sorry.

What I learned from this discussion is: there is no easy 'set based' solution to the problem of unwrapping a csv with sql.

(a solution, like the other way around:...

Oops,

That's a massive answer 🙂

I'll study your answer. Thanks a lot.

My lookup table is just 20 records, and will never have nore then 50 records.

My drinks table is at most...

I think the key to this all is to transform the value '1,2' into

SELECT 1 UNION ALL SELECT 2

(or SELECT '1' UNION ALL SELECT '2', as then automatic conversion will...

Sorry Eugine,

I looked at the article you mentioned. An article from Jeff Moden is always a good reference. But this article is beyond my skills. 🙁

I have some control over...

Jeff, you're right, thank you for your explanation.

Sorry for my bold comment. :unsure:

LOL :exclamationmark:

Btw, I have a suggestion for the link you (Jeff and Phil) both mentioned:

[font="Courier New"]http://www.sqlservercentral.com/articles/Best+Practices/61537/[/font]

Forum Etiquette: How to post data/code on a forum

Lowell showed us an easier way,...

The result:

WITH TestData

AS

(

SELECT '####A##B#####C#####' AS TestString UNION ALL

SELECT '####A##B#######C###' AS TestString UNION ALL

SELECT '#A##B############C#' AS TestString UNION ALL

SELECT '#A##B##########C###' AS TestString UNION ALL

SELECT '#A##B####################C###' AS TestString

)

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TestString,

'#################################','#'),/*33 0..151534*/

'#################','#'),...

Sorry Jef, the REPLACE method which you explained in your article, enhanced by Michael Meierruth, was just what I was looking for.

Till that moment my mind was struggled in the...

Thanks, Phil and Lowell.

This will (after some modification for # in stead of a space) do the job:smooooth: