I am not sure if this is the best way to do it.

if exists( Select 1 from @TempBalBU where ELcol1 like @EL4 And col2 like @EL5 And balCode like 'BU123456')

Select...

I have checked this out the

cmd.Parameters.Add (1, Int).value = 15

is not possible

Any other suggestions ?

Well it was a Software Upgrade only.

I had a 32 bit SQL Server Standard edition which I upgradeed to

a 32 bit SQL Server Enterprise Edition.

Does an upgrade cause all...

Thanks for the converting option even I had that in mind but the files are comming in from a FTP location from a client.

So I just wanted to work with...

According to my knowledge SQl Compare can only synchronize the databses schema not the values in the tables?

Please correct me if I a wrong

Sorry Sugesh I skipped your reply!

I cannot bring the database down for indexing. Because If I want to index a standard edition then I have to bring down the database.

Any suggestions...

Taking the database down is out of the question the size of the database is huge and the downtime would not be acceptable.

What could go wrong with the above proposed...

Here is what I am thinking about!

My Solution 1:

I create 2 databases db1 and db2.

Both the db's are replica of each other.

What I can do is take db1 down and...

Thanks you all for the input, I really appreciate it.

Thanks for the help,

I really wanted to have a re-discussion on this topic and find any factors that could optimize this situation.

And if we had something new in SQL -...

Yes the number of columns are static,its not a dynamic transformation

I have reached to this point now i need some help

While reading the values from the file into the source table I am using the following script:

'**********************************************************************

'  Visual Basic...

Is there a way in which I can read through the header columns of the Excel File using the ActiveX script and based on this I can manage to map...