select pkg.#i#, s.skuid, s.mfrid from ( select DISTINCT #i# from tbl_PRD_Packaging p with (nolock) inner join tbl_PRD_Skus s with (nolock) on s.skuid = p.linkId and p.LinkType = 'SKU' where p.ownerid = 2661 and p.fsl_tableCode = 'BRO' and isNumeric(#i#) = 1 group by #i# having Count(*) > 1 ) as x inner join tbl_prd_packaging pkg with (nolock) on x.#i# = pkg.#i# inner join tbl_PRD_Skus s with (nolock) on pkg.linkid = s.skuid and pkg.LinkType = 'SKU' where pkg.ownerid = 2661 and pkg.fsl_tableCode = 'BRO' and isNumeric(pkg.#i#) = 1 and s.ownerid = 2661 and s.fsl_tableCode = 'BRO' order by pkg.#i# select mfr_name from tblManufacturers with (nolock) where mfr_id = select mfr_name from tblManufacturers with (nolock) where mfr_id =

Type	Code	MFR Name	SkuId	MFR Name (conflict)	Skuid (conflict)
#_label#	#_valtoCheck#	#qry_getMFRName.mfr_name#	#qry_getDuplicated_GTINs.skuid#	#qry_getMFRNameConflict.mfr_name#	#qry_getDuplicated_GTINs.skuid[currentrow+1]#

Number of issues found: #numberformat(_dupsFound)#

#_GtinChkResults#