I have MS-SQL procedure for reporting purpose. It accepts various parameters and gives the table variable after applying the different logic.

Now, I need to write the test script to verify the procedure.

Can anybody advice me what would be the approach that I can follow here.

Note:
I am thinking to write the script that may gives the drilled down list of records, but doesn't seems effective, the...