I didn't explicitly added * Order by * in the query.

But how can i get ordered data of every run in 2 databases?

Can you please explain collation ?

I...

My Problem is not solved...

SET @string = @Declare_column +

" DECLARE @Row_Count integer DECLARE @count...

Thanks for your reply.

I am dynamicaly constructing insert script.

I don't know whether the column value is null or not.

select @col1 = col1,@co2 = col2 from table

If any one value is...

Thanks.

This is my ini file.

[Source Filepath]

SRCvalue=C:\source_query_dts.txt

[Source Server]

SSvalue=MIDTDB024301\SQL024301

[Source Database]

SDvalue=DAQCDMF1

I am having one or more queries in source_query_dts text file.

I can able to access file path, sorce path and destination using activeX.

My...

Hi GSquared,

We are doing manually get the insert and select statement for

input select statement.

this process will take long time for our functional...

Thank you Very Much Andras Belokosztolszki.

I want a SP that will take a Select statement as input and give out Select and insert statements for each records from the first input select statement.

My Table...