Hi All,
I want to write a stored procedure or sql query for the following functionality:
Select the branch name from a existing table (table name is reports)
loop through each branch name and get the latest date
Check if the test date exists for that branch, if not insert into table (new table created. table name: TestResultAvailibiltyMaster)
Please let me know how can I achieve this in Sql.
Kindly waiting for your response.
Thanks,
Santosh