Unanswered: Split a single column data in to 2 columns
This is probably a very basic question for most people in this group.
How do i split the data in a column in to 2 columns? This can be done in access with an update query but in MS SQL server I am not sure.
Here is an example of what i want to acheive
My first guess would be that something is wrong with the code
If you post a copy of your trigger, I'd be able to offer a better informed comment on it.
Here is the code for the trigger
CREATE TRIGGER Part_Trigger ON dbo.tblParticipant
FOR INSERT, UPDATE
DECLARE @transaction_type varchar(6)
If Exists(Select * from deleted) -- updated record write before and after images to the transaction table
INSERT INTO LogX_tblparticipant (Planid, SSN, title, fname, mname, lname, transaction_type, process_status)
SELECT i.planid, i.SSN, i.title, i.fname, i.mname, i.lname, i.cumulativehours, 'After', 'P'
thanks a lot Pat
The problem was with the trigger and some of the fileds it was updating in another table. Now I know to how to look for the trigger and other table dependencies.
Your Code worked perfect. Now I labor with another problem.
I wanted a single character before the '.'
Will send a post if i can't get this working by the end of the day.
thanks a lot