Try this

Eg if the @path var contains 'c:\' from your table it will output the contents of the directory.

declare @cmd varchar(150)

declare @path varchar(100)

select @path = path from tblTest

set @cmd =...