che_9299
12-12-2013, 03:41 PM
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
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