Charles Kincaid (12/1/2008)

---

jcrawf02 (12/1/2008)

---

So to sum up, Jeff says the glass could be half full, Charles says the glass could be half empty, but neither one of them really believes...

G Bryant McClellan (12/1/2008)

---

Jeff Moden (12/1/2008)

---

Good article... but, because of the title, I was actually expecting to see something about a problem or technique with CTE's that couldn't be done...

Ninja's_RGR'us (12/1/2008)

---

Still rolling on the floor on that one... can't be more true than...

Absolutely no problem... like I said, good article and it does stress the...

That was identified and resolved about 6 posts ago.

arkhan (12/1/2008)

---

One line statement:-

SELECT ID,TransactionDate,Balance,CASE WHEN id<5 THEN 0 ELSE(select SUM(balance) FROM Accounts where ID between acc.id-4 and acc.id) end as RunningTotal from Accounts acc

The Network rtraffic would be lesser,...

Thanks, Chris... we posted at just about the same time and I didn't see your post when I posted. Thanks for bailing me out.

Good article... but, because of the title, I was actually expecting to see something about a problem or technique with CTE's that couldn't be done using other forms of code....

Sorry... "Security Violation"... forgot to do a final replace on "SV" before I posted.

Ummmm... you may want to double check the methods above if these are, in fact, virtual machines... even the installation folders may contain nothing but an image of what...

My most sincere apologies... I was just cranking through some posts and didn't notice this was for MS Access... since I don't...

Cool... thanks for the feedback...

Agreed, RegEx Replace is one of the places where a CLR can beat T-SQL. So far as imports with BCP, go... not needed if you...

Put this at the beginning of your trigger...

IF @@ROWCOUNT = 0 RETURN

Unless the output is directed at a format-defined file, date formatting should be done in the GUI.

Just curious... why do you need to do this?