Bob posted some code here. Bob's code looks OK, but I think the formatter saw a single quote in the comment and hence was thown out of phase.

-- based on...

GilaMonster (3/18/2009)

---

Ooooohhhh..... Nice!

Jack Corbett (3/17/2009)

---

This has been a light day for me posting code. I've mainly...

kevin.reynolds (3/18/2009)

---

I feel Im running the risk of being lynched, but I agree in general with foxjaaz.

Im a database developer but I too am frustrated with the snail pace at...

Roy Ernest (3/18/2009)

---

Grant Fritchey (3/18/2009)

---

I'm going to hell for this one, I just know it.

I was checking up on the status of what I think is a bug that I...

Chris Morris (3/18/2009)

---

Grant Fritchey (3/18/2009)

---

I'm going to hell for this one, I just know it.

I was checking up on the status of what I think is a bug that I...

Lynn Pettis (3/17/2009)

---

I did a Varsity Girls game this evening, and the other Law some coaches have a problem with is Law 11, Offside. I'll leave that for another...

While I like the color highlighting and wordwrap, there's something distinctly odd with it.

I use IE6 (Company Policy) and the code backgroup tends to come out as random gray/white horizontal...

foxjazz (3/17/2009)

---

I agree. If I can do more stuff without the use of cursors, I am happier.

Some things just have to be looped. Like for instance, sequence numbers.

but we will...

If you look in SSMS Options under Query Execution, you'll find that the GO batch separator can be changed.

I wouldn't recommend it though.:D

While features may be deprecated, simply removing (or disabling) a feature would break so much code that no-one would use the new version!

By the way, you may think you know...

Did this actually appear as intended?

SET @xml =

'

'

I would have thought there should be something between the quotes.

Just don't touch anything with it on....

http://en.wikipedia.org/wiki/Biological_hazard

I tried this and found that it depends on the indexes avaialble.

Using a 1.2 million record table as follows

CREATE TABLE [dbo].[tblInvoice](

[SpecialGLIndicator] [varchar](50) NOT NULL,

[DocumentNumber] [bigint] NOT NULL,

[PostingDate] [smalldatetime] NOT NULL,

[DocumentDate]...

I think JJ B is over-sipmplifying a bit, but I think what he's getting at is similar to my experience.

First you get the request, from which report layouts and display...

I noticed that Colorado switched yesterday and is now on Daylight Saving Time. 🙂

Time for an early lunch? 😀