making an item repeat

Sorry.
Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
AMB
"hero281" wrote:

> i have created a sql database with a vb.net front end. i have records that
> databse that have dates attached. i want each record to repeat in a given
> time frame according to a field in the datarow. is it possible.
> someone please help my ship is sinking.
> hero281i have created a sql database with a vb.net front end. i have records that
databse that have dates attached. i want each record to repeat in a given
time frame according to a field in the datarow. is it possible.
someone please help my ship is sinking.
hero281|||Sorry.
Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
AMB
"hero281" wrote:

> i have created a sql database with a vb.net front end. i have records that
> databse that have dates attached. i want each record to repeat in a given
> time frame according to a field in the datarow. is it possible.
> someone please help my ship is sinking.
> hero281|||"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Sorry.
> Please provide DDL and sample data.
> http://www.aspfaq.com/etiquette.asp?id=5006
>
> AMB
> "hero281" wrote:
>
here is a sample layout of the database.
column format:
id taskname duedate freq
autonumber clean floors 06/01/06 30
" " " "
i would like to duplicate this task based on the freq.|||"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Sorry.
> Please provide DDL and sample data.
> http://www.aspfaq.com/etiquette.asp?id=5006
>
> AMB
> "hero281" wrote:
>
here is a sample layout of the database.
column format:
id taskname duedate freq
autonumber clean floors 06/01/06 30
" " " "
i would like to duplicate this task based on the freq.|||"hero281" <hero281@.discussions.microsoft.com> wrote in message
news:4A89D9EA-A1C0-4389-A53C-818FDB384648@.microsoft.com...
>
> "Alejandro Mesa" wrote:
>
that[vbcol=seagreen]
given[vbcol=seagreen]
>
> here is a sample layout of the database.
> column format:
> id taskname duedate freq
> autonumber clean floors 06/01/06 30
> " " " "
> i would like to duplicate this task based on the freq.
>
It's still not clear what you want.
Do you want something like
1 Clean Floor 06/01/06 30
1 Clean Floor 06/02/06 30
.
.
.
1 Clean Floor 06/30/06 30
?
Not really sure what you're doing then with the freq?
What if it's not the same as the number of days in the month?

>
>|||"hero281" <hero281@.discussions.microsoft.com> wrote in message
news:4A89D9EA-A1C0-4389-A53C-818FDB384648@.microsoft.com...
>
> "Alejandro Mesa" wrote:
>
that[vbcol=seagreen]
given[vbcol=seagreen]
>
> here is a sample layout of the database.
> column format:
> id taskname duedate freq
> autonumber clean floors 06/01/06 30
> " " " "
> i would like to duplicate this task based on the freq.
>
It's still not clear what you want.
Do you want something like
1 Clean Floor 06/01/06 30
1 Clean Floor 06/02/06 30
.
.
.
1 Clean Floor 06/30/06 30
?
Not really sure what you're doing then with the freq?
What if it's not the same as the number of days in the month?

>
>|||hero281,
A table of numbers will be very handy here.
Why should I consider using an auxiliary numbers table?
http://www.aspfaq.com/show.asp?id=2516
select
[id],
taskname,
duedate,
freq
from
dbo.t1
inner join
dbo.number as n
on n.number <= t1.freq
go
AMB
"hero281" wrote:

>
> "Alejandro Mesa" wrote:
>
>
> here is a sample layout of the database.
> column format:
> id taskname duedate freq
> autonumber clean floors 06/01/06 30
> " " " "
> i would like to duplicate this task based on the freq.
>
>
>|||hero281,
A table of numbers will be very handy here.
Why should I consider using an auxiliary numbers table?
http://www.aspfaq.com/show.asp?id=2516
select
[id],
taskname,
duedate,
freq
from
dbo.t1
inner join
dbo.number as n
on n.number <= t1.freq
go
AMB
"hero281" wrote:

>
> "Alejandro Mesa" wrote:
>
>
> here is a sample layout of the database.
> column format:
> id taskname duedate freq
> autonumber clean floors 06/01/06 30
> " " " "
> i would like to duplicate this task based on the freq.
>
>
>sql

Make Changes to Published Database

with the replicate_ddl setting of sp_addmergepublication set to true (1)
almost all DDL (table changes) should be replicated. Can you verify that
this is the case?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Vincent Cotton" <nospam@.eldersuite.com> wrote in message
news:D03C0DA9-40D8-467C-B262-541F6CE7AE6E@.microsoft.com...
>I currently have a VB6 app that I am rewriting. I am now using Visual
> Studio 2005 and the new app will be a windows forms smart client. I am
> using SQL Server 2005 Compact Edition as the local database. I have SQL
> Server 2005 Enterprise Edition setup as a merge replication publisher. I
> will have a little over 500 subscribers. The system is not yet
> implemented;
> I am still testing at this point. The main problem I am having is when I
> want to make changes to the main database (publisher). SSMS always tells
> me
> I can't make changes because it is setup for replication. At this point
> it's not a big deal. I just remove the publication, remove the
> subscriptions, make changes to my tables and then re-establish the
> publication. However, pretty soon when my app goes into production I
> don't
> think this will work to well. I thought from all my research that I would
> be able to make changes to my tables such as adding new fields, changing
> field names, deleting fields, adding tables and so on, and that those
> changes would just propagate down to the subscribers. I'm sure I'm just
> missing something. So, my question is how can I make changes to the
> publisher without having to remove the publication/subscriptions and start
> all over?
> Thanks,
> Vince
Just to let you know I am very new to SQL Server. I am a "Micro" ISV
programmer not a dba. So, thanks in advance for your patience.
I found the replicate_ddl column in the dbo.sysmergepublications table, but
I can't open to see it's value. It is an (int,not null) and I can see its
default value is ((0)); so, I assume it's value is 0. I am using the SSMS
gui so I don't know how to proceed from here.
Thanks,
Vince
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23i8bLTQKHHA.960@.TK2MSFTNGP04.phx.gbl...
> with the replicate_ddl setting of sp_addmergepublication set to true (1)
> almost all DDL (table changes) should be replicated. Can you verify that
> this is the case?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Vincent Cotton" <nospam@.eldersuite.com> wrote in message
> news:D03C0DA9-40D8-467C-B262-541F6CE7AE6E@.microsoft.com...
>