Ya beat me to it with the numbers table... well done...

By the way... and really think about this... do you ever want to allow a rollback on the sequence? The answer is no, not ever...

We had a similar problem at work... caused an average of 640 deadlocks per day with spikes to 4,000 per day. Here's how to fix it...

Step 1... Rewrite the...

I agree with the others... it depends on two things... how they're written and how they're called.

One of the worst things you can do is create aggragate columns in a...

martin.griffiths (2/27/2008)

---

I'm currently trying to write a query that will extract the first two words from a string. I'm using charindex and substrings and it's getting quite messy! Has anyone...

Adam Haines (2/26/2008)

---

Thanks for pointing that out. It makes sense as the clustered index actually affects the sorting of the data.

In this case, the sorting of the...

Does that mean that you're all set or is there still a problem?

Lookup "hierarchical queries [SQL Server]" in Books Online... what you're asking for is how to expand a hierarchy...

There's a style #126 in 2k... but no style #127... at least none that I can see under CONVERT in BOL...

Ummm... why is Cross-Apply necessary here? Seems to be a bit of overkill when the simple substrings would probably do just fine...

Something like this will get you started...

SELECT OBJECT_NAME(sc.ID) AS Name,

so.XType,

sc.Text

FROM...

Just a different approach... note that this is only good if within 60 minutes as the OP seemed to indicate wanting... (09:13)...

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET...

Nicely done folks...

That's because you didn't do like Matt did... you must include a delimiter on either side of what you're searching for...

Ummm... looking back at some of the code in this thread...

Make sure that the INDEX you're using in the hint is a clustered index... there's the possibility that a...