Most excellent. I learned something new today.

Thank you.

Excellent, thanks!

Hey Jeff,

Dont mean to be a bother. Were you able to find a couple minutes to think about how I might approach my challenge? I tried looping by character...

Thanks for replying Jeff. I am not sure how to go about this. The order of data will be constant. The tags will be constant as will...

Thanks for showing the remainder of my post. Here is the table. The field I am struggling with is the last one in table. PersonalizeLine1. I...

CREATE TABLE [dbo].[tblCmPeriod](

[RecNumId] [int] IDENTITY(1,1) NOT NULL,

[PeriodId] [varchar](50) NOT NULL,

[PeriodStart] [datetime] NULL,

[PeriodEnd] [datetime] NULL

INSERT INTO dbo.tblCmPeriod (

PeriodId,

PeriodStart,

PeriodEnd

) VALUES (

'1',

'2009-3-5 16:45:38.905',

'2009-3-5 16:45:38.905' ,

INSERT INTO dbo.tblCmPeriod

...

What I am looking for is a single row:

Period1 Period2 Period3

3/1/2009 ...

tblRange

RecNumId int

FromDate datetime

ThruDate datetime

tblInvoice

RecNumId int

DueDate

DELETE FROM tblInvoice

WHERE tblInvoice.DueDate BETWEEN tblRange.FromDate AND tblRange.ThruDate

I am not sure how to get the delete to remove records from one table...

Thanks for the help

Great! Thanks a bundle.

vmon

Sorry, I might not be explaining what I am trying to do very well.  This might help show what I am trying to do.  I have 12 years for each...

  This is awsome.  I still don't follow it totally.  I have a ways to go to catch up with SQL stuff.  Thank you...

Chuck this works great, I would not have thought of this approach.  I did consider the -10 but I cannot be certain the steps will be uniform by 10's. 

Only...

Thanks for the help, I will give this a try.  I did not think about testing each character.  That is a great idea to seed an identity column however the...

I am doing this from within DTS.  I am not sure how or where I would use the code you posted.  I added a task that has the 2nd package...