Skip to Content
0
Former Member
Jun 11, 2009 at 09:26 AM

Error in SQL Procedure

4209 Views

Hi Experts

I have created following procedure which is showing Run Time error

alter proc Stock_item

as

begin

create table #temp

(

main_Group varchar (40),

intermediate_group varchar(40),

final_Group varchar,

item_code varchar(20),

item_name varchar (50),

Qty numeric(10,3)

)

insert into #temp (item_code, item_name, Qty)

select itemcode , itemname, onhand from OITM

update tmp set tmp.main_Group = 'Raw material'

from OITM T1 , #temp tmp

where T1.QryGroup1 = 'Y' and T1.Itemcode = tmp.item_code

select * from #temp

end

Error Message is : Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_CI_AS" in the equal to operation.

Msg 468, Level 16, State 9, Procedure Stock_item, Line 26

Plz check and tell me what can be reason

Regards

Gorge