Delete Files in Shared Location/SAN

if object_id('DeleteOldFiles','P') is not null
drop procedure DeleteOldFiles;
go

create procedure DeleteOldFiles
(
@pathvarchar(2000),
@daysint
)
as
begin

set nocount on

declare @dircommandvarchar(2000),
@FileNamevarchar(1000),
@countint

if object_id('tempdb..#FullFileList','U') is not null
drop table #FullFileList;

create table #FullFileList
( 
FileNamesvarchar(1000),
CreatedDate varchar(20)
)

if object_id('tempdb..#FilesToDelete','U') is not null
drop table #FilesToDelete;
create table #FilesToDelete
(
Idintidentity(1,1),
FileNamesvarchar(1000)
)


select @dircommand = 'dir '
+ @path 
+ ' /b '
insert into #FullFileList (fileNames)
exec xp_cmdshell @dircommand


update#FullFileList
setcreatedDate = left(substring(filenames , (charindex('.',filenames)-14) ,charindex('.',filenames)),8)


insert into #FilesToDelete
(
FileNames
)
selectFileNames
from#FullFileList
wheredatediff(dd,getdate(),convert(datetime,createdDate,102))< @days
andFileNames is not null

select@count = count(1) 
from#FilesToDelete

while(@count >= 1)
begin

select @FileName = FileNames
from#FilesToDelete
whereId = @count

select@dircommand = 'del '
+ @path 
+ @FileName

exec master..xp_cmdshell @dircommand

select @count = @count -1 
end
end;