I modified Jeff's procedure to allow for subfolders. I put a maxDepth parameter into it for some control as needed. Thanks Jeff for the code.

ALTER PROCEDURE dbo.GetDirDetails

/**************************************************************************************************

Purpose:

Replacement...