Find missing DDJ file using SQL query

[che_9299]

USE [SRO_VT_SHARD] GO DECLARE @ClientPath VARCHAR(250) = 'E:\vSRO\Client\Media\icon\' -- WITH TRAILING SLASH SET NOCOUNT ON 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 [Service] = 1 AND 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 SELECT * FROM #DDJStatus DROP TABLE #DDJStatus GO

[che_9299]

'E:\vSRO\Client\Media\icon\' للتوضيح هنا بتحط icon بتاع الميديا يتاعتك وبتشوف المسار
وتظبطو

[Silver4NET]

مش فاهم استخداموا ايه يعنى ؟

[che_9299]

ده علشان لو فى حاجه فى السيرفر No image ايتم

[Muhab]

الكود استخدمو فين ارجو المساعدة
انا عندى الــElixirs بتبئا NO IMAGE
ومش عارف احلها ازاى

[MyRȝturn]

الله ينور عليك
تسلم

[Last_Fiddler]

الله ينور تسلم ايدك

[Xeitran]

TY Bro

[ِArabrod]

جامد تسلم ايدك

[™Dev Microsoft™]

عااش

[Xan]

الله ينور