Well, this works to catch the moving target. You may stick with what you have, but this would still work inside of an OLE DB Source provided the source...

Dan.Humphries (4/1/2010)

---

John,

Thanks for the script. Unfortunatley it will not work for what I need since the bucket starting position is determined by the month of the last reading. So...

Can you just swap the ordering around, this seems much simpler?

DECLARE @Table TABLE (Account varchar(25) , Meter varchar(25), ReadDate datetime, Usage int)

INSERT INTO @Table

SELECT '010012080', '00068276', '2010-02-26 00:00:00.000', 440.00000...

First off, I appologize for letting this one get away from me.

Secondly, adjust the column properties as da-zero suggests. Your column needs to match the destination...

Man Man (my 3 year old's way of saying batman)

Well, I won't get into a normalization bashing here, but In my opinion, you should store the data in some sort of 'Readings' table and create a view to pivot...

Your example data shows 1 entry per month. Can you give me an example of what your data would look like when there are multiple entries in a given...

What you are seeing with the table variables is expected. Table variables are scoped to the SQL batch.

Why not eliminate the temp tables completely and insert into your destination...

It is because of your WHERE condition with the OR statement. Group the OR condition together like this:

WHERE(CardORKey='Key' or CardORKey='Both')

AND (LastName = @LastName OR @LastName IS NULL)

AND (Date >=...

Bearded Dragon

You belong here in Nebraska with me Jason. One of the small towns outside of Omaha has a Testical Festival every year. It's a big attraction.

Personally,...

DECLARE @Date datetime

SET @Date = '2008-01-10 00:00:00.000'

SELECT DATEDIFF(dd, @Date, GETDATE())

Can you give an example of the result set you are looking for? Also, how are these 2 tables related?

DECLARE @Table TABLE (RowID int IDENTITY(1,1), Col1 varchar(10))

INSERT INTO @Table(Col1)

SELECT 'test' UNION ALL

SELECT 'T_est'

SELECT *

FROM@Table

WHERECHARINDEX('_',Col1) > 0

sushi