Temp table and While loop is going to be almost as slow as a cursor when it comes to RBAR. The only advantage is the lack of locking and...

Matt Miller (3/13/2008)

---

Jeff Moden (3/13/2008)

---

They have the advantage of a "continuing scope" when compared to multiple EXEC's. You can do a lot of things to a temp table in...

You're not trying to return the output to the screen are you? And, according to Matt's fine testing, ID<'X' is the fastest. I don't think a NCI will...

And I appreciate the feedback. Thanks, Z.

Heh... I knew I liked you for some reason... I was the Sr. Ping Jockey forward of frame 52 on...

I absolutely agree!

How about an indexed view? Possibly a sorted index view. Yeah, I know, might require a TOP with an ORDER BY in a view which is normally a...

BCP or a Proc run by CmdShell with a BULK INSERT in it. Both can be scheduled by the Windows Task Scheduler.

p.s. A thousand rows isn't really enough to show the timing difference on something like this. Try it on a million rows more than once.

If your numbers look like "A123456" and "X123457" and you want just the "A" rows AND you want it to scream...

WHERE LEFT(somecol,1) = 'A'

Substring takes a comparitively long time compared...

Try this...

SELECT d.Csv

FROM (

SELECT 'client_num,client_name,matter_num,matter_name' AS Csv,1 AS SortOrder

...

alorenzini (3/13/2008)

---

Well it came down that I need to have up to the minute:

02/29/2008 11:59:59 PM

So when I run this:

SET @MonthStartDt = DATEADD(month, DATEDIFF(month, 0, @StartDate), 0)

Set @MonthEndDt = DATEADD(month,...

Heh... it's 'cause I copied directly from your post 😉

Oh boy! Someone said "Pork chop"! Let me get my magic sling... 😀

Heh... it's what separates all these "Hi, I'm new to DBA" people from the real DBA's.