0

I have a sales report that is sent to every store on a schedule it has parameter store id and store key and is sent to store managers for their store. The problem is there are emails in the list for district managers and such that will have many store id and store keys assigned to them. will the subscription send the district manager one email per store combo or just pick one and send for the one store?

   select * from salestbl
   where storeid = @ storeid
   and storekey = @storekey
NewGuy
  • 1,020
  • 1
  • 9
  • 24

1 Answers1

1

Each district manager should receive one email per store, assuming there are no problems with the DDS.

Randall
  • 1,441
  • 13
  • 19