RBarryYoung (11/25/2009)

---

Alvin Ramard (11/2/2009)

---

Lynn Pettis (11/2/2009)

---

Thought this one was interesting. Basically, I found this neat code and I would like someone else to port it to SQL Server for...

5 day weekend!

Too be honest, I never saw myself being in the top 5 or breaking 10,000! :Wow:

To think, a year or so ago that would have put you in the...

Okay, here is one way to delete five million rows of data from a table with thirty seven million rows of data.

declare @Batch int;

set @Batch = 10000; -- Batch size...

Remember always, the water cooler this is. Here may you veg (or my case run to the desert), rant a bit, and even ask for help on other threads...

If you're going to "bump" your post, how about posting something usefull, like DDL for your tables, sample data, and expected results. That may actually get you more help...

Dave Ballantyne (11/24/2009)

---

Its not just SqlServer central this happens with...

Just had to check my daughters homework (she 8) , she had to plan an 8 hour evening tv schedule adding...

Not sure, but I think I'd try something like this:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

begin transaction

if exists(select 1 from dbo.tRunNo where Pref = '_T' and RYear = '2009' and RMonth =...

Ron-279530 (11/24/2009)

---

The query below return many records where the description field is identical, where that occurs I want only the most recent of those records.

select historyid, h.startdate,a.account,h.description,longnotes, address1, city, state,...

May I suggest that you try checking out BOL? It may cover this particular topic, I haven't checked myself as I have never been asked this question myself in...

Actually, if I were doing this and running a query through the end of the previous day, month, quarter, etc I'd do it slightly different.

Using the end of the previous...

First, this question could require an extremely verbous answer. It would help if we could understand better what you are actually looking for from this question.

So, yyyy-12-31, yyyy-03-31, yyyy-06-30, yyyy-09-30?

Then you can check this out:

select dateadd(qq, datediff(qq, 0, getdate()), -1)

This will return the last day of the previous quarter.

Okay, now it looks like you want the end...