Sorry, but I agree with Jeff Moden's reply. The leading comma thing is a bit irritating but to each his/her own. With one or more tables it is...

Tim:

Sorry for the late response. Hopefully by now you have found the solution. The question does raise an eyebrow. Basically, when was the last time a given...

I have had from time to time the unfortunate experience of coming across too strongly. I have seen where others REALLY tend to bash folks. From what I...

String maniputlation? Hmmm. While I value your article and would in no way fault your approach, there are much better alternatives - that are not too far off...

I cannot exactly help you with your script debugger issue but I can offer alternatives to using it.

In the past, I would use a popup box. In the case...

Great Article. Interesting approach. Thank you for the contribution.

-Mike

Very nice article. It sound as if this util grew and grew and became what it is over time. Those are the best kind of tools. And...

The parameters are for creating content of the report. If this is a data-driven subscription, then how you produce the recipient list relative to the report wil determine if...

I have my problem solved. The COMMENT field as you stated ealier is infact the solution. Formatting the message is another story....

Since the variable values are available via...

I am using a data-driven subscription

Passing params into the Comments section would be very helpful. I just don't see how it is done. an example message is as...

Sorry for not having posted sooner. I am still reading the thread. Aside from RBAR UDFs as I have suggested earlier, perhaps you can preprocess your data outside...

From what I can tell so far, you are trying to parse a whole row of information into columns to form a single record where some of the columns themselves...

Use the Tally table, join to it, then use intrisinc SQL functions because you will have postive indexes to work with. Good luck.

No doubt RBAR is going to occur with UDFs. The tally table idea is going to be a join. The UDF will defintely work. So what do...

I have a library of UDfs that do exactly what you are looking for and much, much more. however, I sense your aversion to UDFs so I am not...