So, I've gone through the BOL walkthrough and all looks great however, I am confused about how to extend my application to send an order confirmation that contains an order header and order detail. I also have Shyam Pather's book but haven't seen this discussed yet. Does it make sense to do two inserts in my subscription? Something like "insert into orderedAlertHeader" and "insert into orderAlertDetail"? Can I create more than one table for the same subscription?
I think I've been looking at this for too long.
TIA
Ian
For those who are curious I think I've figured out a way to accomplish what I needed. I ended up creating an XML column on my alert table that I can load my detail into. My formatter then can do whatever I need it to.
I'll give an example if someone is interested.
No comments:
Post a Comment