Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison

Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison

Replication one record to many ..... Can you do This?

I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You could customize the replication stored procedures on the subscriber
(sp_msins*) to do this.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"David Hills" <dhills@.pcfe.ac.uk> wrote in message
news:%23l%23fX2SLEHA.3472@.TK2MSFTNGP09.phx.gbl...
I am replicating a table between 2 sql servers.The table has a nasty
field in it, which is a concatinated string of numbers seperated by
spaces eg ("#(14104 14944 15784)"
What I would like to do is create a new record for each number in the
string. Ideally I would like to do this on the fly in the replication
process. Is such a thing possible and if so any idears about how to get
started
Many Thanks
David Hills
"
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||David,
you could use a straightforward trigger.
Regards,
Paul Ibison