it would be but since we are inserting from local to remote it has to be either openquery or execute command. i tried both but always returns an error.

Hi Ed, yes! oh yes! its working exactly what i was looking for. Thank you guys for your time and effort and ed, i a m reading the article you...

You got it right, i want to break down each row for everyone day, its a client request. The query and table is much bigger than this, i have...

My bad guys , I have now rectified the mistake and edited the post. T´thanks chris for pointing and ed, i will follow your lead. thanks guys, will get...

The table below is the result of the modifed script. This works fine for one a row with one or more subid.

subID prodgdate salesdate prodendDate RowNum Subrowlog Subrowdate

2000 2006-02-09 2006-02-09...

The table below is the result of the modifed script. This works fine for one a row with one or more subid.

subID prodgdate ...

they are both date type

I got it working!

DATEADD(mm, RowNum, convert(VARCHAR(10),salesdate,112))

sorry my mistake, not looping. i have explained in a new post what i am trying to achieve.

I get this error.Operand type clash: int is incompatible with date.

My subscription table has around more that 20,000 subscriptionids. I have rownum so that i can concatenate this rownumber to...

This is what i am looking for, to come out of the loop once the datediff days are zero. RowNum is a counter that i am using to concatenate to...

stage_viasatsubscription is a base table.

I also think that rownum is high. No, salesdate is not devideby datetime. I should doing something like this

rownumber <= datediff (day,salesdate,baseenddate) but i dont know how to...

I have solved the issue. My gratitude to Lowell for his time and patience.

Thanks mate, it worked!!

The next thing i want to do is an insert these select into a table

This is what i tried to do

INSERT INTO subs (

...