Link to home
Start Free TrialLog in
Avatar of CalmSoul
CalmSoulFlag for United States of America

asked on

SQL Server query help

I have following data in the column

I just want to grab the file and put in separate column of the same table .. Can anybody help me on that?


Thu 07/09/2015 11:35:45.83 - Missing file: "x:\TAD Image\Alldocs\utility\H155559ZK.TXT" 

Open in new window

SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@I just want to grab the file and put in separate column of the same table

Do you want to copy the content of the file in column? Or just want to copy the value of the field showing above in another column.
Avatar of CalmSoul

ASKER

Following output I want in the column H155559ZK.TXT
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial