tesla764
asked on
SQL code to perform the functions described in the body of this question
Could somebody help with coding in SQL to perform the following...
check folder - \\cluster\data\Direxxis\Er ie\incomin g\
if there is a matrix file – eg. Erie_Creative_Matrix_20140 403.xlsx
remove the date portion eg. _20140403
copy matrix file without the date portion to \\cluster\data\Direxxis\Er ie\incomin g\
- but before changing the file name copy the original eg. Erie_Creative_Matrix_20140 403.xlsx to
\\cluster\data\Direxxis\Er ie\Archive d_Incoming \CreativeM atrix
check folder - \\cluster\data\Direxxis\Er
if there is a matrix file – eg. Erie_Creative_Matrix_20140
remove the date portion eg. _20140403
copy matrix file without the date portion to \\cluster\data\Direxxis\Er
- but before changing the file name copy the original eg. Erie_Creative_Matrix_20140
\\cluster\data\Direxxis\Er
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER