Thanks Steve... Thanks for Help

Thanks David... Thanks for helping me...

Its done now.

Thanx steve for response,

The out of the query is below

SELECT INSERT INTO A976( AS stmt UNION ALL

    SELECT

      CHAR(9) + COL_NAME(OBJECT_ID(A976), ORDINAL_POSITION) +

    CASE WHEN ORDINAL_POSITION < (select...

Thanx David,

The is now ready with no error and doing what i want.... But I don't know how to execute it.

the script is ...

alter PROC Sp_EnterTextFile @filename sysname   

as    ...

Hi,

Finally My query is Ready... But i can't able to excute the Same from My SP.... The Query is almost same as answered by David...

Thanks all for Help

Raju

Hi David,

The Idea was pretty Good... But still have problem...when i executed the statement made by with some changes... The output i got is like this....

INSERT INTO TableA(

 Field1,

 Field2,

 Field3,    ---- , after Every...

Hi David,

The Idea was pretty Good... But still have problem...when i executed the statement made by with some changes... The output i got is like this....

INSERT INTO TableA(

 Field1,

 Field2,

 Field3,    ---- Dot after...

Thanks David

This is amazing.... Let me try this tommorow on SQL DB. This is really Great idea. I will reply again ... if not done...This will help me a lot.

Thanks...

David,

Thanks i got your point. But I want to show you my query beacuse nowhere i am taking column, as indivisual. I am taking whole string.

See my Query : You...

Hi steve,

You can see the link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=159272&p=2

This will give you the exact scenario...

In breif i m trying to upload data from a string variable to table like

@var = 'field1'...

Thanks david, Thanks a ton for help...

But i Have already done with this but by other way.. I am still in problem... while putting the data into table in DB......

Sorry Phill,

Its like

Table : A222

Field 1        field 2      field 2   field 2         and so on

ZS01          |0002      |02      |VG602-11311         |31.12.9999|01.01.2002|0000054528     |

ZS01          |0002      |03      |01783-03760         |31.12.9999|20.09.2001|0000029494     |

This is the value we...

yes u r true A222 is table name and zs08|0005|H350..... are fields vale (That Data not filed name)...

A222 is destination table in db thats rite.. and i have to upload...

Yes this post is related to the Other one..

Thanks

Hi

Pls. find the file layout. Where A222, a223, A940,.... is the name of the File followed by field name....

A222|ZS08          |0005      |H350        |GENERAL_REPAIR      |A              |28.02.2004|01.02.2004|0000352836     |000

A223|ZS16          |0005      |02            |03      |03        ...