The above query is working fine

use sp_executesql

Dear Dhruvesh Shah ,

Try this

CREATE TABLE #Account

(

Ac_no int

,Code_list varchar(100)

)

insert into...

I think the query which posted by ColdCoffee is not working

Suppose i want to insert Account Table with

insert into @account( Ac_no, Code_list)

...

Dear mister.magoo

As per my understanding

The hostname returns the name of the machine that the connection was established .

The hostprocess is the PID (process id) on the machine that the...

This is not working

Your query does not gives the result on the following inputs

Country My

My India

Country India

Any way other than replication ?

Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!

IF the SSMS configuration is same for both users then it is not an issue with sqlserver. Something else going around their.

I think this is ur expecting result

UPDATE #temptable2

SET columnvalue =CAse When columnname ='Address' THEN (SELECT VAl2 from #temptable WHERE val1 ='Address')

When columnname ='idnumber' THEN (SELECT...

I think this is may be your hardware configuration is different in both machine.

Pls do the following things

1. Disable Parallel query execution .

2. Check statistics are up to...

Pls explain more clearly.

Use this query

-- Month wise

Select P.ProductName , P.ProductType ,

DATENAME(month, S.saledate ) +' '+CONVERT (VARCHAR,Year(s.saledate )) as 'Month Name' ,

SUM((S.sales_price -cost_price)*S.quantity ) As...

SQL 2008 You can use MERGE keyword.

SQL 2005 Either use conditional split OR INSERT +UPDATE

EG:-

Method 1

IF --Insert chk

INSERT quiery

ELSE IF --Update Chk

--Update Query

Method 2

INSERT QUERY --IF ID does not exists

Update...

I have a little confusion about your question. I think you are expecting the result of below query

Select E.empno,E.emp_name, E1.Emp_name as ManagerName from Employee E join Employee E1 on

E.mgr=...

One way you can disable the trigger by using following sql script

ALTER TABLE Table_Name DISABLE TRIGGER Trigger_Name

Other way programaticlly handle it by checking a condition inside the trigger statement.