Thank you guys for all your comments, it's really appreciated. I have learnt great deal.

JRJ

That's possible. How can I change a views definition in a proc? Also I am deeling with duplicate indexes, is that ok?

thanks

Thanks Jeff, I don't how to implement this in DTS, I need to switch each time destination table, so I need to track what table is being used in the...

Sorrry Jeff, I went to bed after my last reply.....

Yes every import is a complete replacement of old and new data.

Thanks for your reply, sorry about the wrong naming.

Regarding my second query, I am deeling with constantly changing existing data as well as new data; if I don't delete, then...

I think if you check the box 'force restore over existing database' (on the option tab; next to general tab on the EM restore utility), it will work.

Thanks guys for your response, it's really useful. I am just wondering which one will be faster when I deel with some 50,000 records: the one with temp table as...

Thanks very much, that works.

JRJ

Thanks very much for your time, I really appreciate it. How about if I create a variable in an object (activeX and register it on the webserver) and get the...

Thanks for your response. I think I am doing more or less similar way as you. I need to figure out whether I can encrypt the connection details in my...

Thanks Chirac for your time. I gave only read permission for the external login.

thanks for your reply. I think your understood the situation properly, however I will explain the situation once more in detail.

The internal users create some reports related to the...

External and normal users connect through the web page, however normal users have user accounts in our domain and external users don't.

I need to differentiate the external users, for...

sorry, you should have a single quote as follows:

select isNull(c1, '') + isNull(c2, '') + isNull(c3, '') as Combined from table .....

I think you could use isNull function to give you an empty string when any column is null as follows:

select isNull(c1, "") + isNull(c2, "") + isNull(c3, "") as...