To clarify, if @startmonth = 2007-07-15, you want all records where mb_membership.mbr_renew_date >= 2007-07-1 and mb_membership.mbr_renew_date < 2007-08-01?

Like I said earlier, looks like you will need to use dynamic sql.  Build your query into a string, @SQLCmd = ...

then execute that, exec (@SQLCmd)

I was just hoping...

Steve, Combine to two threads on Bankers Round and you get close (depending on how you round :rolleyes

Cause I am tired of the personal attacks for the most part.  It's gotten to the point it isn't worth debating with some people.

url: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=383658#bm385709

Give this a try:

create table dbo.MyTable (

    JobNo decimal(6,0),

    Status char(2),

    TransDate datetime,

    RecordId bigint identity(1,1)

)

go

insert into dbo.MyTable values (1234,'AB','01/07/07')

insert into dbo.MyTable values (1234,'AB','02/07/07')

insert into dbo.MyTable values (1234,'AB','03/07/07')

insert into dbo.MyTable...

What is the recover mode for the database?

You probably need to use dynamic sql in this case.  I was looking at BOL, and was curious, what if you try this:

in ((select @isps))

It would help if you could provide the DDL for your table, some sample data, and what the returned result set should look like.

We use the ExecuteProcess Task to FPT files to an MSP using sslftp.  I wrote a cmd file that is called in the Execute Process Task that uses a script...