T_CUST_SUBSCRIPTION_SUMMARY

These rows are manually created when a package lineitem for a particular season is created in an order.  This happens en masse during the rollover process.

This is completely acceptable, but mind that a row might already exist.  You can do it in a few ways, either update existing and insert new rows, or look at the new MERGE command in SQL 2008.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Monday, May 16, 2011 3:41 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] T_CUST_SUBSCRIPTION_SUMMARY

Are there any implications to manually adding rows to T_CUST_SUBSCRIPTION_SUMMARY in order for our Customer Care reps to use the Suggested Contribution and Suggested Additional Contribution fields when calling customers?  I just want to make sure I don't miss some sort of behind the scenes machinations that might need to take place when rows get inserted in that table.

Thanks, Tessiturians.

Matt Gonzales

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!

You need to make sure that a row doesn’t exist for the season already.  In those cases you’re going to update the row’s data.

So, two phases in pseudo-code:

Insert T_CUST_SUBSCRIPTION_SUMMARY(customer_no, contribution1_amt, season)

Select column, column, column

From table a

Where Not Exists (Select * From t_cust_subscription_summary where customer_no = a.customer_no and season = ###)

--Then an update for those that have a row

Update a

Set contribution1_amt = ####

From T_CUST_SUBSCRIPTION_SUMMARY a

JOIN  MG_T_CUST_SUBSCRIPTION_SUMMARY_TEMP  b on a.customer_no = b.customer_no and season = ###

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Monday, May 16, 2011 4:31 PM
To: Ryan Creps
Subject: RE: [Tessitura Technical Forum] T_CUST_SUBSCRIPTION_SUMMARY

So am I to understand that I can insert a row into that table with no more information than the customer_no, box2_sug_contribution1 and season from my Development contact's spreadsheet that I imported?

Like so:

INSERT INTO T_CUST_SUBSCRIPTION_SUMMARY (customer_no, box2_sug_contribution1, season)

SELECT customer_no, box2_sug_contribution1, season FROM MG_T_CUST_SUBSCRIPTION_SUMMARY_TEMP

Should that work?

Thanks, Ryan.

Matt Gonzales