SELECT TOP 5
        Item_Id
    FROM
        N_SalesPrice
    WHERE
        Comp_id = '001' AND
        _promotype = 1 AND
        (StartingDate <= GETDATE() OR StartingDate IS NULL) AND
        (EndingDate >= GETDATE() OR EndingDate IS NULL)
    ORDER BY NEWID()


array(1) {
  ["Item_Id"]=>
  string(13) "ECS 14716-7.4"
}




array(1) {
  ["Item_Id"]=>
  string(12) "ECS 22404-22"
}




array(1) {
  ["Item_Id"]=>
  string(14) "TEKTINO RCC-6S"
}




array(1) {
  ["Item_Id"]=>
  string(17) "TEKTINO RCC-6S-ID"
}




array(1) {
  ["Item_Id"]=>
  string(19) "BOSCH S P00 000 149"
}