SELECT
    @DailyCnt = COUNT(tranid)
FROM
    COREACQUIRE.dbo.AcqLogARTxnsAdd l WITH (NOLOCK)
LEFT OUTER JOIN COREACQUIRE.dbo.trans_in_acct t WITH (NOLOCK, INDEX (idx_tran_id_index))
    ON l.tranid = t.tran_id_index
WHERE
    t.atid = 39
    AND l.artxntype IN ('91', '95')
    AND l.ARTxnBusinessDate <= '1/1/2011'--@DateFrom  
    AND InstitutionId IN 
		(SELECT childaid FROM #InstitutionChild)
    AND l.TransactionAmount <> 0
    AND ISNULL(l.ExcludeFlag, '0') = '0'

table cats (cat_id int...)  
table books (book_id, cat_id ...)

select books.* from books b inner join cats c 
on b.cat_id = c.cat_id where c.cat_id in (1,33,51,79,91)

    AND l.ARTxnBusinessDate <= '1/1/2011'--@DateFrom  

    AND InstitutionId IN 
		(SELECT childaid FROM #InstitutionChild)