Thanks Dennis,

I checked the same in MSDN and it is mentioned the width option also as -w<n>

and it worked well.

Here is the statements I executed

set @query= 'select * from tablename '

set...

Hi Dennis,

I checked the MSDN and there is an option for the above as -h-1 to not to print the column headings.

But query result saved in the file is breaking...

Hi Dennis,

Thanks for the reply.

I tried the command

ISQL -SAK -E -Q"SELECT * FROM BUT.dbo.Pat" >> c:\temp\myfile.txt

(AK is my server name and BUT is my DB and Pat is my...

Hi Mike,

No the SQL tables are of different structure

Hi Mike,

Thanks for your reply

Yes I tried the option already as you mentioned. But my requirement is not only two tables. It is n number of tables

That is currently I...

Yes Boss it is working fine

Thanks a Lot

Yes David I am using the Element Code in the Group by clause

Because first up all the Element Code and the value are of Char type and I am not...

Thanks David,

It is working but I have a problem, instead of inserting a record it is inserting more than one record

That is if the above has three columns, it...

Simple and easily understandable

Thanks. Expecting more articles like this

Thanks Steve

It is working fine

Hi sameer,

It works fine. Thanks

Hi Deni,

Since we are having a Stored Procedure which will do all the Import process.

That is basically we are copying all the content to the Staging table using a DTS.

After...