Loading

sql pending willl display for remaining organization

sql pending willl display for remaining organization

lejo

1y693SQL Server

my query result will be given below.i want to get result like Marked one.

in 2025 no data for Query,ABC company .so i want to display it as Pening in next row

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul1y ago
You can join the Table with the Messages table to check that all rows from the Table are included, and for the missing rows (where no match is found in the Messages table), display "Pending". This avoids hardcoding specific conditions. If you’re missing data in the Messages table (for a specific OrgID and Year), you can handle it with COALESCE or IFNULL to substitute a "Pending" value for the missing data.
```
SELECT 
  t.Year, 
  t.Name_E, 
  t.OrgID,
  CASE
    WHEN m.OrgID IS NULL THEN 'Pending'
    ELSE 'Data Available'
  END AS Status
FROM Table t
LEFT JOIN Messages m
  ON t.OrgID = m.OrgID AND t.Name_E = m.Name_E
```
0
Tuhin Paul1y ago
```
SELECT 
  Year, 
  Name_E, 
  OrgID,
  CASE
    WHEN Year = 2025 AND Name_E = 'ABC' THEN 'Pending'
    ELSE 'Data Available'
  END AS Status
FROM Table
```
check with something like this query.

Compare your query result with a reference table that contains the expected entries for each year and name (e.g., the Messages table). If data is missing for a given year and organization (like ABC company in 2025), you can show "Pending" in that row.
0