That's all I hear when Mr. Celko speaks. Sort of like the teacher in the Peanuts cartoon specials.

Hooray!! We have Internet again!! Been down for nearly 24 hours. Can't wait to get back to 1st World Internet capabilities!

Jack Corbett (9/9/2014)

---

Okay, I may have gotten out of line in this thread, http://www.sqlservercentral.com/Forums/Topic1611473-150-1.aspx, but I'm not sure. Been trying to help the OP all day and the...

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at it as...

Silver Spoon is at it again, looking for a free hand out.

Yes, very well done. Would have been closer had...

Killroy (9/8/2014)

---

reate table #Check

( Date Date ,

Amount money

)

Insert into #Check values ( '04/21/2012','2000')

Insert into #Check values ( '04/21/2012','3000')

Insert into #Check values ( '04/21/2012','1000')

Insert into #Check values( '04/21/2012','4000')

Insert into...

Sean Lange (9/8/2014)

---

jcrawf02 (9/8/2014)

---

Jack Corbett (9/8/2014)

---

Sean Lange (9/8/2014)

---

Sometimes being a parent is really difficult. I have been coaching both of my boys soccer teams for a long time....

Eirikur Eiriksson (9/7/2014)

---

For completeness, here is a complete solution to the problem using the method I posted earlier and the sample data set posted.

😎

;WITH QUERY_BASE AS

(

SELECT

...

Luis Cazares (9/7/2014)

---

I don't. I just validate that there are at least 3 dates within the range. This works if the dates aren't important and you just want to know...

Luis Cazares (9/7/2014)

---

Here's a different approach.

WITH MinDates AS(

SELECT CompanyId,

DATEADD( dd, -15, MAX(ActivityDate)) MinDate

FROM...

Try this:

CREATE TABLE [dbo].[ActivityTable](

[CompanyId] [int] NULL,

[CompanyName] [varchar](20) NULL,

[ActivityDate] [date] NULL

) ON [PRIMARY]

GO

insert into ActivityTable values(1,'ABC','2014-08-01')

insert into ActivityTable values(1,'ABC','2014-08-03')

insert into ActivityTable values(1,'ABC','2014-08-10')

insert into ActivityTable values(1,'ABC','2014-07-20')

insert into ActivityTable values(2,'AJAX','2014-08-01')

insert into ActivityTable values(2,'AJAX','2014-08-10')

insert...

caoneill (9/7/2014)

---

Thanks for responding Lynn! Below is a small test case.

CREATE TABLE [dbo].[ActivityTable](

[CompanyId] [int] NULL,

[CompanyName] [varchar](20) NULL,

[ActivityDate] [date] NULL

) ON [PRIMARY]

GO

insert into ActivityTable values(1,'ABC','2014-08-01')

insert into ActivityTable values(1,'ABC','2014-08-03')

insert into ActivityTable values(1,'ABC','2014-08-10')

insert...

Not enough to really provide you with code as nothing to work with. I would use a CTE and the row_number() over (partition by ... order by ... desc)...

If I read it this right, you want to switch log shipping from A to B to B to A. You won't be able to do that without...