Ticket, Print, missing, data

Q: When I print a ticket, the cusip and cusip rating data are missing.

A: The corresponding prodrat record for the cusip is missing.   Add a prodrat record.

The following script inserts prodrat records for all product records which do not already have an associated prodrat record.

insert prodrat (product_id)
   select product_id from product
      where product_id not in (select product_id from prodrat)
go

The following script sets all Moody and S&P Ratings (long & short) to N/A (default value), only if the current values are null.

update prodrat
set moody_long = 'N/A'
    where moody_long = null
go

update prodrat
set sandp_long = 'N/A'
    where sandp_long = null
go

update prodrat
set moody_short = 'N/A'
    where moody_short = null
go

update prodrat
set sandp_short = 'N/A'
    where sandp_short = null
go

Last updated: 04/28/05