Thanks jeff

Hi

since you are trying SSMS on the same server is the Sharedmemory protocol enabled.

Hi

One doubt - restoring from staging to production will restore the restore staging data to production. Is that ok ?

Hi

is the sql instance (either of the two) that u want to connect to up and running.

Thanks Jeff.

Named value pair was what i had suggested but due to reasons it was not acceptable. Querying the data then showing rows as columns being the main reason....

hi

thanks for info Grant.

my clustered index is CustomerId and i believe most if not all queries would be based on customerID.

This is a case of customisable fields which can...

Hi

i think you will have to use the inserted table in the join.

Hi

As experts here said depending on your environment and requirements you need to decide on the method to move your data. I would prefer Logshipping or even mirroring to replication...

that was excellent Gail.

Ian

"Great article. I agree that there will always be idiots in the world that can only help to make me look good "

what do u mean by this

Hi

Mostly it would be the inner join since it needs to fetch lesser number of rows when compared to a outer join.

Thanks Jeff.

So u mean to say that there is a triangular join in my example. Since there are other conditons in the where clause (i did not put them in...

Hi guys

Just a doubt..

Does a inner join (for that matter any join) with a inequality condition in the where clause make a triangular join.

EX:- Select orderid,orderdate,productid

from orders O INNER JOIN...

Thanks Andras

will look into what you have said. data is not dynamic.

I have restored the production db and in this db data is not modified.

Hi

option b sould be my choice. u can have a index on the datetime column. Also if time part is important then its better to use datetime. Having said...