antonio.collins (4/14/2008)

---

i agree. there seems to be more and more demand for ordered processing, but i'm sure codd and date would say that order should be irrelevant from a...

Jeff Moden (1/22/2008)

---

The PK Clustered Index you have might be good for something else, but it's no good for this query even though the execution plan say's you're using the...

Jeff Moden (4/14/2008)

---

Matt Miller (4/14/2008)

---

As of right now...

As of right now - "straight T-SQL" wins...

Cory Ellingson (4/14/2008)

---

I had tried that, and when I...

Simply ordering by the datetime field itself and not the "display version" would get your data in the right order.

GSquared (4/14/2008)

---

I agree with Jeff that SQL isn't the way to do this. Every front end app I've ever worked with will do this better.

If, somehow, you absolutely must...

To follow up on Brian's comment, the bolded part is the "servicename" for the instance:

'Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp'

In a named instance that will usually be formatted as MachineName$instance.

So you'd have to dynamically change...

rbarryyoung (4/11/2008)

---

Yeah, but that shouldn't matter, Namespace declarations are just labels,...

rbarryyoung (4/11/2008)

---

Matt: unfortunately, I do not actually have any control over this XML, as it is a Microsoft error message returned by Service Broker. I just quickly mocked...

This is not a complete answer to your question, but removing the xmlns notation allows your queries to work just fine (once you fix the issues with the single quotes...

Keep in mind that Reporting services does NOT install on any of the home editions, due to some missing components (Windows Auth) in the OS (removed from the home editions)....

Have you tried the OPTION (RECOMPILE) query hint on that statement? Without it, it will generate an exec plan based on whatever is passed in the first time, and...

I find most questions are worded fine. Some amount of badly worded/incorrect questions would be expected IMO, so I'm not at all surprised - besides - they tend to...

If you have a lot of these to do - you could use a TALLY table to help build this instead of a cursor. with a fairly sizeable number...