Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trigger to split one column and insert into another table Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 2:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:36 AM
Points: 229, Visits: 730
Hi,

I need a trigger on below condition,


am having a table called "Tracker", msg_text is a column in the tracker table.


msg_text contains data like : "NAme <R> city <R> pin <R> phone <R> email <R> country <R>"

<R> Specified the seperator.

my requirement is when a user enters records into tracker table - msg_text column
in above format, data should be enter into another table
"Address" it contains column names "NAme | city | pin | phone | email | country |


Please help me....
Post #1352050
Posted Thursday, August 30, 2012 6:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 2:30 PM
Points: 628, Visits: 870
This article might help...

http://www.codeproject.com/Articles/7938/SQL-User-Defined-Function-to-Parse-a-Delimited-Str


_____________________________________________________________________
- Nate

@nate_hughes
Post #1352149
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse