RH says:

Hmm, no, I wish. Not for columns of XML type holding XML documents.

IAC I'm not able to figure out a way...

There are a couple of different ways to handle this but the quick and dirty way is to have a special token, 'ALL', and disallow nulls.

You can do this with...

>>

SELECT INTO on a temp table with an identity column is so very fast that it's nearly as fast as SQL Server 2005's ROW_NUMBER() over

<<

That's extremely cool, Jeff -- not...

>>

Before you use any of those that have a self join or correlated subquery that use the ">=" or "<=" or any other inequality method to generate row numbers,...

There are a number of ways to "fake" the rownumber function in sql 2000 -- here is one I particularly like:

http://support.microsoft.com/kb/q186133/

nope, not your only solution.  Table vars don't work in SELECT statements... but table-valued functions do <g>.  Even in nested SELECTs and all kinds of other screwy syntax.

>L<

hi Kathleen,

I'm not from MS and this comment isn't specifically about your licensing structure... but...

>>

I was on an interview recently and talked about our report solution and one of the...

If you want to render the HTML as it came from the database, IMHO Reporting Services would not be the right way to do it. 

Reporting Services, by definition, are...

What version of IIS and what OS are you running?

Also, any chance you are accessing the server via a VPN that could be doing the rewriting?

>L<

First of all, I didn't say </br>.  I said <br/>.

Second, I see that you have used CHR(13) and CHR(13)+CHR(10) inconsistently, which can be an issue in another RS situations --...

What error did you get with the <br>?  Maybe you just have to use well-formed HTML (ie <br/&gt.

Is the report being delivered as embedded...

Nice.  the difference in time is more pronounced at 40k rows than 20k, although if you keep going up the time to create the delimited string becomes too unbearable to test.

Question:...

If the report attachment is fine through Outlook but not fine through OWS this is *not* likely to be "something in the core of RS", more likely to be something...

(mid-coffee)

a join seemed to worked, I think...  would it have been better to use APPLY? TIA, I've never tried it.  And thank you for the article!

>L<

SELECT o 

Hi Kevin,

You've already got a solution that works for you -- I would agree that writing some dynamic sql makes sense here --  but I have another thought for you...  

In...