#3

The short answer is use slow, proprietrary dynamic SQL to kludge a query

together on the fly with your table name in the FROM clause.

The right answer is never pass...

#2

>> a generic function that concatenates results of a

query into a string ...<<

In a client server architcture, the display is done by the front end,

not in the database...

Just before it's time to go to bed and hopefully get some sleep.

As for big name quotes is also ask, what now follows...

Okay, I'll jump in with my standard link on dynamic SQL. SQL Server MVP Erland Sommarskog has written some fine stuff on that at http://www.sommarskog.se/dynamic_sql.html .

Without knowing your query, table structure and indexes it will be difficult to tell what is going on. As always with dynamic sql ...

The only thing I can think of is NO_OUTPUT if you use xp_cmdshell in your s_proc.

HTH

TEST

Yes! Now you can change history without notice.

Isn't that brilliant?

Use of a cursor for calculation of the median (financial or statistical ?) ???

CREATE TABLE #dist (c1 int)

INSERT INTO #dist VALUES (2)

INSERT INTO #dist VALUES (3)

INSERT INTO #dist VALUES (1)

INSERT...

Stefan,

which messages do you mean? Can you post an example?

set nocount off/on ?

Not that I don't like any visual stuff, but IMHO the best front end for most of the job is Query Analyzer, because only with QA you are forced to...

If you are sure that you don't have data longer than 8,000 characters you can use a somewhat messy workaround. Open the table in EM and change the data type...

I am not going with the author or the mainstream here.

As I'm too tired to write a pamphlet and in addition have only a very limited english vocabulary compared to...

Hey, fhanlon, you were quicker

Yes, I also checked the book yesterday, so send the broken...