/* 33312 */

SELECT CustomerAcctNumber,

      Cast(Cast(DatePart(month, CallStartTime) AS varchar(2)) + Cast('/' as varchar) + Cast(DatePart(dd, CallStartTime) AS varchar) + Cast('/' as varchar) + Cast(DatePart(yyyy, CallStartTime) as varchar) + ' ' + Cast(DatePart(hh, CallStartTime) AS varchar) + Cast(':' as varchar) + Cast(DatePart(mi, CallStartTime) AS varchar(2)) + Cast(':' as varchar) + Cast(DatePart(ss, CallStartTime) AS varchar) as varchar) AS CallDate,

      U.ServiceNumber,

      OrigNumber,

      OrigPlace + Left('          ', 10 - Len(OrigPlace)) + OrigState,

      UsgSvc.Name,

      '',

      CASE WHEN UsageTypeID IN (6,7,22,142,143) THEN 4 WHEN DistanceID = 21 THEN 5 WHEN DistanceID = 22 THEN 3 WHEN DistanceID = 23 THEN 2 WHEN DistanceID = 24 THEN 1 ELSE 99 END,

      RatePeriod - 1,

      0,

      0,

      Convert(varchar, GetDate(), 101),

      Convert(numeric(9,1), Duration) / 60.0,

      0,

      0,

      Convert(numeric(9,1), Duration) / 60.0,

      Charge,

      0,

      0,

      0,

      CASE WHEN UsageTypeID IN (19,20,21,22) THEN .35 ELSE 0 END,

      Charge,

      'I',

      ''

      FROM Customer

      INNER JOIN Prod_Usage_20031105.dbo.Usage AS U ON U.CustID = Customer.CustID

      INNER JOIN UsgSvc ON U.UsgSvcID = UsgSvc.UsgSvcID

      WHERE

      CustomerAcctNumber = '33312'

 

/* 11333 */

SELECT CustomerAcctNumber,

      Cast(Cast(DatePart(month, CallStartTime) AS varchar(2)) + Cast('/' as varchar) + Cast(DatePart(dd, CallStartTime) AS varchar) + Cast('/' as varchar) + Cast(DatePart(yyyy, CallStartTime) as varchar) + ' ' + Cast(DatePart(hh, CallStartTime) AS varchar) + Cast(':' as varchar) + Cast(DatePart(mi, CallStartTime) AS varchar(2)) + Cast(':' as varchar) + Cast(DatePart(ss, CallStartTime) AS varchar) as varchar) AS CallDate,

      U.ServiceNumber,

      CASE WHEN Convert(varchar, AcctCode) = '0' THEN Convert(varchar, U.ServiceNumber) ELSE Left('0000000000', 10 - Len(Convert(varchar, AcctCode))) + Convert(varchar, AcctCode) END,

      TermNumber,

  TermPlace + Left('                                ', 10 - Len(TermPlace)) + TermState,

      UsgSvc.Name,

      '',

      CASE WHEN UsageTypeID IN (6,7,22,142,143) THEN 4 WHEN DistanceID = 21 THEN 5 WHEN DistanceID = 22 THEN 3 WHEN DistanceID = 23 THEN 2 WHEN DistanceID = 24 THEN 1 ELSE 99 END,

      RatePeriod - 1,

      0,

      0,

      Convert(varchar, GetDate(), 101),

      Convert(numeric(9,1), Duration) / 60.0,

      0,

      0,

      Convert(numeric(9,1), Duration) / 60.0,

      Charge,

      CASE WHEN UsageTypeID = 2 THEN .89 ELSE 0 END,

      0,

      0,

      Left(OrigNumber, 6),

      Charge,

      'O',

      ''

      FROM Customer

      INNER JOIN Prod_Usage_20040105.dbo.Usage AS U ON U.CustID = Customer.CustID

      INNER JOIN UsgSvc ON U.UsgSvcID = UsgSvc.UsgSvcID

      WHERE

      CustomerAcctNumber = '11333'

 

/* LD For CENTRAL SCHOOLS */

SELECT CustomerAcctNumber,

      Cast(Cast(DatePart(month, CallStartTime) AS varchar(2)) + Cast('/' as varchar) + Cast(DatePart(dd, CallStartTime) AS varchar) + Cast('/' as varchar) + Cast(DatePart(yyyy, CallStartTime) as varchar) + ' ' + Cast(DatePart(hh, CallStartTime) AS varchar) + Cast(':' as varchar) + Cast(DatePart(mi, CallStartTime) AS varchar(2)) + Cast(':' as varchar) + Cast(DatePart(ss, CallStartTime) AS varchar) as varchar) AS CallDate,

      U.ServiceNumber,

      CASE WHEN Convert(varchar, AcctCode) = '0' THEN Convert(varchar, U.ServiceNumber) ELSE Left('0000000000', 10 - Len(Convert(varchar, AcctCode))) + Convert(varchar, AcctCode) END,

      TermNumber,

  TermPlace + Left('                                ', 10 - Len(TermPlace)) + TermState,

      UsgSvc.Name,

      '',

      CASE WHEN UsageTypeID IN (6,7,22,142,143) THEN 4 WHEN DistanceID = 21 THEN 5 WHEN DistanceID = 22 THEN 3 WHEN DistanceID = 23 THEN 2 WHEN DistanceID = 24 THEN 1 ELSE 99 END,

      RatePeriod - 1,

      0,

      0,

      Convert(varchar, GetDate(), 101),

      Convert(numeric(9,1), Duration) / 60.0,

      0,

      0,

      Convert(numeric(9,1), Duration) / 60.0,

      Charge,

      CASE WHEN UsageTypeID = 2 THEN .89 ELSE 0 END,

      0,

      0,

      Left(OrigNumber, 6),

      Charge,

      'O',

      ''

      FROM Customer

      INNER JOIN Prod_Usage_20040115E.dbo.Usage AS U ON U.CustID = Customer.CustID

      INNER JOIN UsgSvc ON U.UsgSvcID = UsgSvc.UsgSvcID

      WHERE

      UsageTypeID NOT IN (11,47,250,151,148,157,32,68,16) AND

      CustomerAcctNumber = '21040948' AND

      UsgSvc.ServiceNumber IN (

      '5187652382',

      '5187652383',

      '5187652384',

      '5187652418',

      '5187655150',

      '5187652426',

      '5187655544',

      '5187655545',

      '5187653289',

      '5187653313',

      '5187653314',

      '5187653315',

      '5187653316',

      '5187653317',

      '5187652381',

      '5187655546',

      '5187655529')