C'mon Tony, get it right! Here is the code pasted in as a 'snippet' and using & e n s p ;

[font="Courier New"]USE [master]

GO

CREATE DATABASE [Test_DB] ON PRIMARY

   (

            NAME =...

....and this is what happens when copy and paste from the 'rendered' tab in the prettifier in IE6. I'm baffled as to why the difference. I get the same in...

Pasted in from rendered code...

CREATE FUNCTION capitalize ( @String VARCHAR(8000) )

/*Returns a copy of s with its first character capitalized,

and the rest of the characters lowercased....

We`re making progress now with the struggle to produce nicely-formatted SQL. We are a few tweaks short of a SQL Server forum still (Having a SQL Server forum that can`t...

Jeff,

Obviously, I'd prefer to do cut 'n paste from SSMS/QA, but this seems to be denied us now for some reason. I've got an adaption of the S-T Prettifier doing...

I just got bored doing something else and suddenly thought of a completely different way of doing this. Using the slightly more complicated data example I used in my BLOG...

Not forgetting (modest cough) Enumerating Group Members - which works in 2000 (for short resultsets) -but I agree that the XML trick is very cute

Jeff,

This is really ingenious! It would never have occurred to me. However, I hope that nobody gets too enthusiastic about using it as a general way of parsing data.

[font="Courier New"]

DECLARE...

I can't edit the post I did earlier (it puts in extra line-feeds wherever I've pasted anything in) but if you are using IE6 or IE6, the code will look...

Hmm. Interesting about the averages. The averages in the example come straight from the CUBE (I hope) and the SUM() calculation is merely to do the pivot rotation. I suspect...

Yes, Redgate have a proper prettifier code in C# that is used in SQL Doc to produce HTML output which is much better than mine. I expect they could use...

I hope this is a solution, or at least points the way to one! Unfortunately, I'm having real difficulty posting code into this forum for some reason, so please excuse...

Jeff,

I've been bleating about this in a big way to Steve and Tony too. What is the point of having a forum in which one cannot paste TSQL code. At...

Don't get too excited in anticipation of C2 auditing. When I tried it it just gave a blizzard of irrelevant information along with the nuggets, which were, as a result,...

[p]I think that everyone who has responed to this thread are correct, in that for a production system one would never want to update a record in an audit table,...