That I must say is pure genious! I will deffinetly give that a try.

The only potential hang up I can think of is the sorce is SQL but it is...

Assuming any for of logic applied to the destination DB I would tend to agree with you but no infact the starting bucket number is the month of the first...

The problem is that the starting bucket is a moving target. for example since today is the first of april the starting bucket for anyone read to today will...

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 in...

this is what the source data could look like. Notice there are two readings in february and June and no reading in september.

010012080 00068276 2010-02-26 00:00:00.000...

Adding the following line to my select query worked great.

row_number() OVER (PARTITION by C_account order by c_account)

I would have never thought to do it this way.

Thanks for the advice!

The seq number does not have to be the same everytime for each meter as long as there is a seq number present for each multi meter account.

This is a...

Well That is a very good question and I asked it myself. Basically it comes down to like most good questions to circumstances I can not control. The...

I had not tried that but I will play around with that idea for a while and see what I can come up with.

It might look something like this

if @one =0

set @status1 = 'Unsuccessful,' + @one1

set @color1 = 'RED'

else

set @status1 = 'Successfully ,' + @one1

set @color1 = 'GREEN'

if...

Based on your scipt I would declare a seperate variable that would be included in your if statements. If the status is Success set the variable value to 'Green'...

As an added note I would create the SSIS on the 2008 server I am not sure if there would be any compatibility issues but by creating the SSIS on...

I do not beleive you can script out all jobs at once. you can of course right click on each job and click script individualy but in your case...

do you want to return a result with a row number as part of the output or do you want to grab a specific row, as in you want row...

Basically if I am reading it correctly the permission would be from the aspect of the foriegn key only. So the foreign key is given the permission to do...