我正在检查唯一编号,并将数据放在临时表中。下表显示了VarientSKU和,它是否唯一。现在我想把这个表和另一个表连接起来。为此,我需要唯一的列,在我的表中,ItemId是唯一的表。所以我想在临时表中添加ItemId

alter Proc spIsUnique
@columnname nvarchar(max),
@tablename nvarchar(max)
As
Begin
declare @result nvarchar(max)
set @result = 'select ItemId,IIf (count(VariantSKU)>1 or
count(VariantSKU)=0,''False'',''True'') as [IsUnique-check]
INTO ##dq_IsUnique from '+@tablename+'
group by '+@columnname+';'
print @result
exec sp_executesql @result
End我收到了这个错误
Msg 8120, Level 16, State 1, Line 185
Column 'Product.ItemId' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause.当我在groupby...it中同时使用@Columnname和ItemID时,会显示所有唯一的值,但很少有不是唯一的值,请解决这个问题。
发布于 2018-02-03 02:18:20
我不知道你的数据,但也许MAX或MIN函数对你有用。
declare @result nvarchar(max)
set @result = 'select MAX(ItemId) ItemId ,IIf (count(VariantSKU)>1 or
count(VariantSKU)=0,''False'',''True'') as [IsUnique-check]
INTO ##dq_IsUnique from '+@tablename+'
group by '+@columnname+';'https://stackoverflow.com/questions/48539324
复制相似问题