#! /bin/sh

sBillPeriod="2024/02"
sProgramID=2303             #AnyTime QuoteSys Installations

# in vi searched tdatacollection.unl for all batchid and found none
#\(|62615|\||62662|\||62665|\||62666|\||62669|\||62674|\||62675|\||62676|\)

sBatchID=62615          #62615,62662,62665,62666,62669,62674,62675,62676
sBatchTypeID=200        #VicTrack Installation
sSystemID=200           #QSM Jobs


tbssql <<SQLCMD0
SELECT tDataCollection.Var01, tServiceID.ServiceTypeID
FROM tDataCollection
LEFT JOIN tServiceID ON tDataCollection.ServiceID LIKE tServiceID.ServiceID
LEFT JOIN tBatch on tDataCollection.BatchID = tBatch.ID
LEFT JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.ID
WHERE tDataCollection.BatchID = $sBatchID
AND tBatchType.ProgramID = $sProgramID
AND tDataCollection.Var01 IS NOT NULL
SQLCMD0

exit 0