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(16) "UNITE U2011-380V"
}




array(1) {
  ["Item_Id"]=>
  string(9) "BGS 74283"
}




array(1) {
  ["Item_Id"]=>
  string(9) "BGS 70210"
}




array(1) {
  ["Item_Id"]=>
  string(9) "BGS 90102"
}




array(1) {
  ["Item_Id"]=>
  string(11) "UNITE U500S"
}