select d.docTitle as title, c.fileName as docFileName from tbl_DOC_Documents d with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = d.contentId and c.contentId != 755 where d.ownerId = and d.fsl_tablecode = and d.docId = and d.contentId = select d.docTitle as title, c.fileName as thnFileName from tbl_DOC_Documents d with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = d.thumbnailId and c.contentId != 755 where d.ownerId = and d.fsl_tablecode = and d.docId = and d.thumbnailId = update tbl_DOC_Documents set lastUpdatedDate = , internalOnly = , privateYesNo = ,lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and docId = and contentId = select i.imgTitle as title, c.fileName as docFileName from tbl_IMG_Images i with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = i.contentId and c.contentId != 755 where i.ownerId = and i.fsl_tablecode = and i.imgId = update tbl_IMG_Images set lastUpdatedDate = , internalOnly = , lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and imgId = select r.docTitle as title, c.fileName as docFileName from tbl_#_contentDomain#_Repository r with (nolock) inner join tbl_FSC_Content c with (nolock) on c.contentId = r.contentId and c.contentId != 755 where r.ownerId = and r.ownerType = and r.fileId = and r.contentId = and r.containerId = and r.containerType = update tbl_#_contentDomain#_Repository set updateDate = , updateUserId = , #_f# = , #_f# = , #_f# = where ownerId = and ownerType = and fileId = and contentId = and containerId = and containerType = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID in (7, 23, 34) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 7 INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 31 INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) insert into tbl_DOC_Documents ( ownerId, fsl_tablecode, uploadDate, lastUpdatedDate, lastUpdatedBy, docTitle, docDescription, publishDate, unpublishDate, repCategoryId, sortRank, fileExt, fileSize, contentId, unpublishToDo, internalNotes,keyWords, AuthorUserId, recordSource, internalOnly ) values ( , , , , , , , , , , , '', 0, 0, , , , , , ) insert into tbl_IMG_Images ( ownerId, fsl_tablecode, uploadDate, lastUpdatedDate, lastUpdatedBy, ImgTitle, ImgDescription, publishDate, unpublishDate, categoryId, sortRank, fileExt, fileSize, contentId,HighResCntID, recordSource, internalOnly ) values ( , , , , , , , , , , , 0, '', 0, 0, , ) insert into tbl_#_contentDomain#_Repository ( ownerId, ownerType, containerId, containerType, uploadDate, updateDate, updateUserId, docTitle, docDescription, publishDate, unpublishDate, category, sortRank, fileExt, fileSize, contentId, restricted, internalOnly, recordSource ) values ( , , , , , , , , , , , , , 0, '', 0, , , ) ---> insert into tbl_FSC_Content( mainFolder, subFolder, fileName, createDate ) values ( , , , ) update tbl_DOC_Documents set uploadDate = , fileSize = , fileExt = , #_contentIdDBField# = where ownerId = and fsl_tablecode = and docId = update tbl_IMG_Images set uploadDate = , fileSize = , fileExt = , #_contentIdDBField# = where ownerId = and fsl_tablecode = and imgId = insert into tbl_FSC_Content( mainFolder, subFolder, fileName, createDate ) values ( , , , ) update tbl_DOC_Documents set #_contentIdDBField# = where ownerId = and fsl_tablecode = and docId = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , )