Hi All ! Looking for a little help!
I am trying to create a custom output set for my box office team, so they can pull our 5 show subscribers performance dates in one string to be used in a mail merge letter for subscribers. They are getting a letter/email saying: "here are your 5 upcoming show dates"
I found a Next Performance Output set in the Output set cookbook (see attached) , but am not sure what Data_From i should be using and am getting errors.
Long and short - can anyone give me some time on a go to meeting to help? or can anyone comment here to help!
OR is there another way to get that info that we don't know about?
Thank you!
Hi! The cookbook recipe requires a new custom view in SQL Server. If you don't have access to SSMS for your instance, someone on your database/IT team should. The view details are included in the cookbook, so it should be easy to set up.Once that view is set up, you would make it the reference in Data_From.
Thank you Maery Simmons (Past Member)!!