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