建一存表。下列做法有但不知怎正
declare @tempid table ( MfgOrderItemIssuedId char(16))
insert into @tempid(MfgOrderItemIssuedId)
select MfgOrderItemIssuedId from MfgOrderItemIssued where MfgOrderItemIssuedId=@temp


delete from MfgOrderItemIssued where MfgOrderItemIssuedId in (select MfgOrderItemIssuedId from @temp)
果
cannot resolve collation conflict for equal to operation
把delete一句注掉就得
thanks

[解决办法]
--try
declare @sql varchar(8000)
selet @sql= 'delete from MfgOrderItemIssued where MfgOrderItemIssuedId in (select MfgOrderItemIssuedId from '+ @tempid+ ') '
exec(@sql)