I need to run this for a single season. I have searched for the syntax but cannot find it. In SQL Manager, woudl the proper syntax be:
UP_UPDATE_ZONE_NO where season_no=69
???
Randy
exec up_update_zone_no @season=69
is what you need.
-steve
Information Technology Manager
The Granada
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell Sent: Tuesday, September 28, 2010 5:18 PM To: Steve Carlock Subject: [Tessitura Technical Forum] UP_UPDATE_ZONE_NO question
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
EXEC UP_UPDATE_ZONE_NO 69
Ken