select r.ownerId, r.ownerType, r.containerId, r.fileId, r.contentId, c.mainFolder, c.fileName, c.subFolder, r.docTitle, r.fileSize, r.fileExt, r.uploadDate from tbl_PRD_Repository r with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = r.contentId where r.containerType = 'SKU' and r.docTitle in ( 'BARCODE ITF14', 'BARCODE UPCA', 'BARCODE CODE128_UCC' ) and exists ( select * from tbl_PRD_Skus s with (nolock) where s.ownerId = r.ownerId and s.fsl_tablecode = r.ownerType and s.skuId = r.containerId ) order by r.ownerType, r.ownerId, r.containerId

Obsolete #ownerType# #ownerId# Sku #containerId# #fileName# #docTitle#

delete from tbl_FSC_Content where contentId = delete from tbl_PRD_Repository where contentId = and fileId = and ownerId = and ownerType = select imageCode from tbl_PRD_Images with (nolock) where ownerId = and ownerType = and linkId = and linkType = 'SKU' and imageCode =

Converting #ownerType# #ownerId# Sku #containerId# #fileName# #docTitle# #uploadDate#

insert into tbl_PRD_Images( ownerId, ownerType, linkId, linkType, imageCode, fileSize, fileExt, uploadDate, contentId, recordSource ) values ( , , , 'SKU', , , , , , ) update tbl_FSC_Content set SubFolder = 'PRD' where subFolder = 'SKU' and contentId = delete from tbl_PRD_Repository where ownerId = and ownerType = and containerId = and containerType = 'SKU' and fileId =

Renaming #htmleditformat( _sourceFile )# to #htmleditformat( _destFile )#

Collision #ownerType# #ownerId# Sku #containerId# #fileName# #docTitle# #uploadDate#

delete from tbl_FSC_Content where contentId = and subFolder = 'SKU' and fileName = delete from tbl_PRD_Repository where ownerId = and ownerType = and containerId = and containerType = 'SKU' and fileId =

File not found, removing #ownerType# #ownerId# Sku #containerId# #fileName# #docTitle# #uploadDate#

delete from tbl_FSC_Content where contentId = and subFolder = 'SKU' and fileName = delete from tbl_PRD_Repository where ownerId = and ownerType = and fileId = and contentId =

Conversion Count: #lsnumberformat( _conversionCount )#

Collision Count: #lsnumberformat( _collisionCount )#

Not Found: #lsnumberformat( _notFound )#