[Guide] Find missing DDJ file using SQL query

USE [master]
GO
/* Find missing DDJ -- Witchy Moo */
DECLARE @ClientPath VARCHAR(250)
SET @ClientPath = 'E:\vSRO\EasternOnlineSource\Media\icon\' -- WITH TRAILING SLASH
SET NOCOUNT ON
/* Create temporary table */
CREATE TABLE #DDJStatus (FilePath VARCHAR(300),FileStatus VARCHAR(30))
DECLARE DDJCursor CURSOR LOCAL FAST_FORWARD FOR 
	(SELECT DISTINCT AssocFileIcon128 FROM [SRO_VT_SHARD].[dbo].[_RefObjCommon] WHERE AssocFileIcon128 NOT LIKE 'xxx')
OPEN DDJCursor;
DECLARE @FullPath VARCHAR(250)
DECLARE @isExists INT
FETCH FROM DDJCursor INTO @FullPath
WHILE @@FETCH_STATUS = 0
BEGIN
	SET @FullPath = @ClientPath + @FullPath
	EXEC xp_fileexist @FullPath, @isExists out
	IF (@isExists = 1)
	BEGIN
		INSERT INTO #DDJStatus values(@FullPath,'OK')
	END
	ELSE BEGIN
		INSERT INTO #DDJStatus values(@FullPath,'MISSING')
	END
	FETCH FROM DDJCursor INTO @FullPath
END
CLOSE DDJCursor
DEALLOCATE DDJCursor
/* Dump info from temporary table */
SELECT * FROM #DDJStatus
/* Drop temporary table */
DROP TABLE #DDJStatus
GO