title: How to find the file path of a flat file using a stored procedure (T-SQL)?
body: <p>I have a query. The problem is that I want to create a log file using T-SQL Stored Procedure. I need to get the Source File Path into the log file but I need to it dynamically. I don't want to hard code the path there.</p>
  <p>How can I achieve this?</p>