How can I get this result by SQL script? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How can I get this result by SQL script?

Hi Friends, Plesae go through the below data & provide the solution I also like to inform you that the below information is available on Notepad File. 1.1PRAHLADA/DR
SWIICRM 22MAY RAQG
FONE-HD7-H MBL940658999
02.DL7-H MBL9810667601 1.1ROY/PSDR
MUCICRM 30MAY RAYQ
FONE-HYD-H MBL9490117286 I have to import on SQL Table the information only (OneName, MobileNo, RefNo) example below for your review: ONENAME———-MOBILENO——————–REFNO
PRAHLADA———940658999——————RAQG
ROY————–940117286——————RAYQ Amit Kumar
Mob.: 9873812005
I don’t think you can use import/export utility from sql server to import the information to the table unless the information is like: PRAHLADA /DRSWIICRM 22MAY RAQG 940658999 9810667601
ROY/PSDR MUCICRM 30MAY RAYQ 9490117286 in your notepad.
You may try to write a program to read from notepad and insert to the table instead.
What is the column or word seperator in this case, I think using SSIS & XML you could get a solution for this, but before that lot of information required with regard to the source data . Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>