select count(*), event_status from text_events group by event_status; event_status ----------- ------------ 26 0 2352103 2 81921 3 #### declare @status int select @status = 0 select * from text_events where status = @status #### my $sth = $dbh->prepare("select * from payment_db..text_events where event_status = ?"); $sth->execute(1); fetch_all($sth); $sth->execute(0); fetch_all($sth);