Solnake
Дата: 14.09.2006 15:50:17
Схема сервера - Cyrillic_General_CI_AS
Схема базы - Ukrainian_CI_AS
Есть запрос
declare @Table1 table(DocID int, OnDate datetime, Num varchar(16) COLLATE Cyrillic_General_CI_AS, PrivateID int, clientname varchar(256) COLLATE Cyrillic_General_CI_AS
, DocType int, InAmount numeric(18,4), OutAmount numeric(18,4), TypeEx varchar(128) COLLATE Cyrillic_General_CI_AS, ueID int)
declare @Table2 table(DocID int, OnDate datetime, Num varchar(16) COLLATE Cyrillic_General_CI_AS , PrivateID int, clientname varchar(256) COLLATE Cyrillic_General_CI_AS
, DocType int, TypeEx varchar(128) COLLATE Cyrillic_General_CI_AS, ueID int)
declare @Table3 table(OnDate datetime, Num varchar(16) COLLATE Cyrillic_General_CI_AS, PrivateID int, Amount numeric(18,4))
declare @TblOut table(DocID int, OnDate datetime, Num varchar(16) COLLATE Cyrillic_General_CI_AS, ClientName varchar(256) COLLATE Cyrillic_General_CI_AS
, DocType int, InAmount numeric(18,4), OutAmount numeric(18,4)
, TypeEx varchar(128) COLLATE Cyrillic_General_CI_AS, SID int, ID int, unvID int)
insert into @Table1(DocID, OnDate, Num, PrivateID, clientname, DocType, InAmount, OutAmount, TypeEx, ueID)
select ud.udid, ud.OnDate, ud.Num as Num
, case
when ue.ueID!=8 then p.PrivateID
else c.ClientID
end PrivateID
, case
when ue.ueID!=8 then p.SecondName +' '+ p.FirstName +' '+ p.Patronimic
else c.ClientName
end clientname
, ue.ueid as DocType , 0 as InAmount, 1 as OutAmount, ue.name as TypeEx, ue.ueID
from unvDoc ud
join unvPersonDir upd on upd.udID=ud.udID
left outer join Private p on upd.ToID=p.PrivateID
left outer join Clients c on c.ClientID=upd.ClientID
join unvStatus us on us.SID=upd.SID
join unvEvent ue on ue.ueID=us.ueID
where
upd.FromID=@PrivateID
and ue.ueID in (0,3,4,8)
and us.unvID in (select u.unvID
from unv u
where u.MatCID=-@ID)
and us.SID=(select min(st.sid)
from unvStatus st
join unvPersonDir updt on updt.SID=st.SID
where
st.ueID in (0,3,4,8)
and st.unvID=us.unvID
and updt.FromID=@PrivateID
)
and not exists(select st.SID
from unvStatus st
join unvPersonDir updt on updt.sid=st.SID
where
st.ueid in (6,7)
and updt.toid=@PrivateID
and st.unvid=us.unvID
and st.SID<us.SID
)
and ud.OnDate<=@OnDate
insert into @Table2(DocID, OnDate, Num, PrivateID, clientname, DocType, TypeEx, ueID)
select distinct DocID, OnDate, Num, PrivateID, clientname, DocType, TypeEx, ueID
from @Table1
insert into @Table3(OnDate, Num, PrivateID, Amount)
select OnDate, Num, PrivateID, count(OutAmount)
from @Table1
group by OnDate,Num,PrivateID
insert into @TblOut (DocID, OnDate, Num, ClientName, DocType, InAmount, OutAmount, TypeEx, SID, ID)
union all
select t2.DocID, t2.OnDate, t2.Num, t2.ClientName, t2.DocType, -t3.Amount as InAmount
, t3.Amount as OutAmount, t2.TypeEx, 0 SID, abs(@ID) as ID
from @Table2 t2
join @Table3 t3 on t2.OnDate=t3.OnDate and t2.Num=t3.Num and t2.PrivateID=t3.PrivateID
where t2.ueID != 4
union all
select t2.DocID, t2.OnDate, t2.Num, ' ', t2.DocType, -t3.Amount as InAmount
, t3.Amount as OutAmount, t2.TypeEx, 0 SID, abs(@ID) as ID
from @Table2 t2
join @Table3 t3 on t2.OnDate=t3.OnDate and t2.Num=t3.Num
where t2.ueID = 4
На всех серверах работает, а вот на этом не хочет...
Выдает ошибку
Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.