Begin Tran

select hotelcd, hotelnm from hem037 where hotelcd='HT09004464' 
select * from hem399 where hotelcd='HT09004464' and seType='SJ'
delete from hem399 where hotelcd='HT09004464' and seType='SJ'

insert HEM399 (hotelCd, seType, seConvCode, updater, lastupdate)
values ('HT09004464', 'SJ', '<!-- Sojern Tag v6_js, Pixel Version: 1 -->
<script>
  (function () {
    /* Please fill the following values. */
    var params = {
       hd1: "{11:yyyy-MM-dd}", /* Check In Date. Format yyyy-mm-dd. Ex: 2015-02-14 */
       hd2: "{12:yyyy-MM-dd}", /* Check Out Date. Format yyyy-mm-dd. Ex: 2015-02-14 */
       hc1: "Phuket", /* Destination City */
       hs1: "", /* Destination State or Region */
       hpr: "The Shore at Katathani", /* Hotel Property */
       hr: "{26}", /* Number of Rooms */
       hpid: "HT09004464", /* Property ID */
       t: "{24}", /* Number of Travelers */
       hp: "{3}", /* Purchase Price */
       hcu: "{2}", /* Purchase Currency */
       hconfno: "{1}", /* Confirmation Number */
       hdc: "{33}" /* Discount Code */ 
    };

    /* Please do not modify the below code. */
    var cid = [];
    var paramsArr = [];
    var cidParams = [];
    var pl = document.createElement(''script'');
    var defaultParams = {"vid":"hot","et":"hc"};
    for(key in defaultParams) { params[key] = defaultParams[key]; };
    for(key in cidParams) { cid.push(params[cidParams[key]]); };
    params.cid = cid.join(''|'');
    for(key in params) { paramsArr.push(key + ''='' + encodeURIComponent(params[key])) };
    pl.type = ''text/javascript'';
    pl.async = true;
    pl.src = ''https://beacon.sojern.com/pixel/p/207111?f_v=v6_js&p_v=1&'' + paramsArr.join(''&'');
    (document.getElementsByTagName(''head'')[0] || document.getElementsByTagName(''body'')[0]).appendChild(pl);
  })();
</script>
<!-- End Sojern Tag -->', 'AU00000001', getdate())

select * from hem399 where hotelcd='HT09004464' and seType='SJ'

Rollback