i am not using format file, just using the bulk insert.

this is what i am doing:

CREATE TABLE dbo.table

(

col1 bigint NOT NULL,

col2 smallint NOT NULL,

col3...

the datatypes for the columns are bigint and smallint. If if specify the size for these datatypes while creating the table then i am not able to do so. it...

i tried doing rtim(ltrim(column name)) but that didnt work. it gave an error: "Argument data type ntext is invalid for argument 1 of ltrim function." since the text data was...

my question is how would i need to insert the data obtained from the following result set of the below code into an already created table. i used the insert...

thanks. actually i am trying to insert the result set obtained from the edge table ( for the first example) into a table already created in the database. but not...

Thank you for the information jack. i have one more problem dealing with xml data and i have posted it in the forums but there has been no response. i...

it did work out well. I have another doubt. what if the "ID' number is of varying length for different states. is there any way it could be done or...

thanks.... i shall work on it and let u know how it goes

Hi Jack

could you provide with an example as to how to use information_schema.column for this. i tried looking online but could not find enough information about it

Thanks

thanks... i shall try doin that

it would extract the data like the state name and decscription but not the id's (34,35,36). I want to extract that also