An example is the stored proc could generate some sort of data feed such as daily sales summary which the powershell script will export to a csv file. The csv file can then be picked up by an external system/process for further processing or importing.