Dear All,
I want to Partition based on 2 columns such as Branchid and Year like
if Branchid =1 and date = 2021-09-01 save rows in file2021.ndf
if Branchid =1 and date = 2022-10-01 save rows in file2022.ndf
if Branchid =2 and date = 2021-09-01 save rows in file2021.ndf
if Branchid =2 and date = 2022-10-01 save rows in file2022.ndf
Thank You.