Embed a CASE statement into the SELECT... syntax. You're restricting yourself to one group only, so there's no sense in using a GROUP BY clause.

Something like:

select

...

Jez (11/19/2007)

---

table variable vs #table- possible but you cannot create an index on a table variable.

But the question remains - should I extract the records I need from...

By the way - you didn't mention in which direction it "exceeds". If vertically (i.e. rows>65K) then yes - the options discussed...

GilaMonster (11/15/2007)

---

Matt Miller (11/15/2007)

---

Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure"...

Jeff Moden (11/15/2007)

---

Sorry... must still have the "ranger eye's" going on from lack of sleep the other day... I just say the results you posted for the run.

Thanks for fixing...

Jeff Moden (11/15/2007)

---

Matt,

Reformatting code that you've copied from those "Code" windows is actually pretty easy (although I wish...

use testing

go

IF OBJECT_ID('dbo.weekdays') IS NOT NULL

DROP FUNCTION dbo.weekdays

go

--steal code directly from Jeff Moden's article and turn into a function

create function dbo.weekdays(@startdate datetime,@enddate...

I've been beating the heck out of this drum lately - but an actual regular expression will help you find all of the various issues you're looking at here. ...

Jeff Moden (11/15/2007)

---

You mean on the dynamic SQL by itself or the whole Phone Test #1?

Thanks for the great tip (we call them "oolies" in...

AM -

Jeff Moden and I were just having a bit of a conversation about that in another thread. He just posted an example that will work on a...

Jeff - I was going to quote you...but I didn't know what to pick up. You're right - most of the examples in there are fairly disgusting SQL.

That being...

Jeff - one last update on Phone Test #1.

I got the results to match. two smallish updates:

- changed the AND t.N < LEN(m.Doc)-14 to AND t.N < LEN(m.Doc)-11...

The original data is the output of Phone Test #1....

First - test results. Took a while to get the code realigned correctly after the copy/paste operation. I made one change to your code (making the @sql variable...

You can get a running start at it by filtering for things that contain <\. By far and large I don't think you will find that sequence "in the...