Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiman
Starting Member
18 Posts |
 Posted - 2007-06-14 : 06:59:23
|
SQL Server 2000, Query which result will delimate by '!'. It is very urgent and i need your highly support. PLS PLS help me.Aiman atik33@yhaoo.com |
|
|
pbguy
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-06-14 : 07:01:54
|
| not clear...post sample data and required outpu--------------------------------------------------S.Ahamed |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-14 : 07:03:13
|
quote:
It is very urgent and i need your highly support.
And I highly need clear specifications, sample data and expected output.  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
aiman
Starting Member
18 Posts |
Posted - 2007-06-14 : 07:05:46
|
| My Required OutPut like :QUERY: Select * from AuthorOutput will be:Name!FatherName!MotherName ----- Coloumn NameAiman!XYZ!Mss Rahim Karim!KHA!MSS Hena |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-14 : 07:08:41
|
| I will tell you a simple way to do it from query analyzer:1. Goto Tools, Options, Results tab2. Select "Results to Text" as Default Results Target combo3. Select "Custom Delimiter" as Results output format combo4. Specify ! as delimiter.5. Tick "Print Column Headers" checkbox.6. Click on OKNow run the query and that's it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
aiman
Starting Member
18 Posts |
Posted - 2007-06-14 : 07:18:22
|
| Harsh Athalye..Thanks I am trying to do this . Offcourse i will update u ASAP |
|
|
|
aiman
Starting Member
18 Posts |
Posted - 2007-06-14 : 07:29:29
|
| I made a *.bat file which will be scheduled to call. within this batch file I wana to Run this Queryr,Format is like <@ECHO OFFset dir_work=%e:\ftptest\Data_Extract\%osql -L tabstst@TABSUATDB1/writepasswordhere @%dir_work%ISN_GET_WORKCODE_EXTRACT_DHA.sql>Here "ISN_GET_WORKCODE_EXTRACT_DHA.sql" is my Procedure. which will call remotely.Is there any way to write direct Query to get this type of Output |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-14 : 08:09:08
|
| You need to use BCP tool then.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-14 : 11:40:52
|
bcp "select * from MyDatabase.dbo.MyTable" queryout myfile.txt -t! -c -T -SMYSERVER
elsasoft.org |
|
|
|
|
|
|
aiman