SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE DAILY_SALES_RECORDS(store_id INT, dt date, product_code VARCHAR(10), sales DECIMAL(10,1));
INSERT INTO DAILY_SALES_RECORDS VALUES
(1, '2019-01-01', '001', 0.0),
(1, '2019-01-01', '002', 0.0),
(1, '2019-01-01', '003', 0.0),
(1, '2019-01-01', '004', 0.0),
(2, '2019-01-01', '001', 0.0),
(2, '2019-01-01', '002', 25.5),
(2, '2019-01-01', '003', 12.0),
(2, '2019-01-01', '004', 0.0),
(3, '2019-01-01', '001', 0.0),
(3, '2019-01-01', '002', 0.0),
(3, '2019-01-01', '003', 0.0),
(3, '2019-01-01', '004', 1.0),
(1, '2019-01-02', '001', 0.0),
(1, '2019-01-02', '002', 0.0),
(1, '2019-01-02', '003', 1.0),
(1, '2019-01-02', '004', 3.0),
(1, '2019-01-03', '001', 0.0),
(1, '2019-01-03', '002', 0.0),
(1, '2019-01-03', '003', 0.0),
(1, '2019-01-03', '004', 7.0);
20 rows affected

WITH ct AS
(
  SELECT
    store_id,
    dt,
    product_code
  FROM
    DAILY_SALES_RECORDS
  WHERE
    product_code IN ('001', '002', '003')
  GROUP BY
    store_id,
    dt,
    product_code
  HAVING
    SUM(sales) = 0
)
SELECT 
  store_id,
  dt
FROM
  ct
GROUP BY
  store_id,
  dt
HAVING
  COUNT(*) = 3;


store_id
dt


1
01/01/2019 00:00:00

3
01/01/2019 00:00:00

1
03/01/2019 00:00:00


WITH ct AS
(
  SELECT
    store_id,
    dt,
    product_code,
    sales,
    COUNT(CASE WHEN sales > 0 THEN 1 END) OVER (PARTITION BY store_id, dt) AS cnt
  FROM
    DAILY_SALES_RECORDS
  WHERE
    product_code IN ('001', '002', '003')
)
SELECT 
  store_id,
  dt,
  product_code,
  sales
FROM
  ct
WHERE
  cnt = 0 ;  


store_id
dt
product_code
sales


1
01/01/2019 00:00:00
001
0.0

1
01/01/2019 00:00:00
002
0.0

1
01/01/2019 00:00:00
003
0.0

1
03/01/2019 00:00:00
001
0.0

1
03/01/2019 00:00:00
002
0.0

1
03/01/2019 00:00:00
003
0.0

3
01/01/2019 00:00:00
001
0.0

3
01/01/2019 00:00:00
002
0.0

3
01/01/2019 00:00:00
003
0.0


Warning: Null value is eliminated by an aggregate or other SET operation.


  SELECT
    store_id,
    dt 
  FROM
    DAILY_SALES_RECORDS
  WHERE
    product_code IN ('001', '002', '003')
  GROUP BY
    store_id,
    dt
  HAVING
    SUM(sales) = 0 ;


store_id
dt


1
01/01/2019 00:00:00

3
01/01/2019 00:00:00

1
03/01/2019 00:00:00
store_id	dt
1	01/01/2019 00:00:00
3	01/01/2019 00:00:00
1	03/01/2019 00:00:00