For each file

Extract the patient Id from the file name

Check whether the extracted patient Id matches a row in the SQL Server lookup table

If a match is found

move the file...

I want to move those matched PDF files with Patient ID from Folder A to Folder B and Folder C.

• This reply was modified 5 years, 4 months ago by  kran.

Declared variables only once, it worked. Thanks

declare @begindate datetime,

@enddate datetime

SET @begindate =Dateadd(month,datediff(month,0,getdate())-3,0)

SET @enddate=EOMONTH(Dateadd(month,datediff(month,0,getdate())-3,0))

Exec rpt_MonthlyApprovalsProductivity @begindate, @enddate

SET @begindate =Dateadd(month,datediff(month,0,getdate())-2,0)

SET @enddate=EOMONTH(Dateadd(month,datediff(month,0,getdate())-2,0))

Exec rpt_MonthlyApprovalsProductivity @begindate, @enddate

SET @begindate =Dateadd(month,datediff(month,0,getdate())-1,0)

SET @enddate=EOMONTH(Dateadd(month,datediff(month,0,getdate())-1,0))

Exec rpt_MonthlyApprovalsProductivity @begindate, @enddate

I have to declare the variable only once then it will work.

 declare @begindate datetime,
        @enddate datetime 

SET @begindate =Dateadd(month,datediff(month,0,getdate())-3,0)
      SET @enddate=EOMONTH(Dateadd(month,datediff(month,0,getdate())-3,0))

Exec rpt_MonthlyApprovalsProductivity @begindate, @enddate

 ...

It gives me this error now If I declare and set values like above

Msg 134, Level 15, State 1, Line 582

The variable name '@begindate' has already been declared. Variable names...

@BeginDate DATETIME

,@EndDate DATETIME