batch Snapshot Exporting

[mmohon]

I have a report, when you run it, the query it's built on prompts for
a department code.

I want to build a Script that: basically

Define Department: 123
Output to snapshot
Define Department: 123 & 456
Output to snapshot

what would be the best code to accomplish that?