RE: [Emerald] Emerald & Mailsite Lists

Dale E. Reed Jr. ( (no email) )
Wed, 12 Jul 2000 11:19:22 -0700

> How could I modify this same script so that it pulled the
> inactive accounts in the past 30 or 60 days?

How did I know that question was coming. :) There are a couple
of ways, but this should work.

DECLARE @fd datetime, @esid int
SET NOCOUNT ON

Select @fd=DateAdd(Month, 0-10, GetDate())
Select @esid=min(ExternalSystemID)