Using select inside case statement

Poor Peccary answered on March 11, 2023 Popularity 5/10 Helpfulness 2/10

answer Using select inside case statement

Using select inside case statement

Comment

SELECT (CASE WHEN ISNULL(s.rate, 0) = 0 
             THEN (SELECT TOP 1 pr.rate
                   FROM ProjectRates pr
                   WHERE (pr.projectID = p.ID) AND (pr.effectiveDate < GETDATE())
                   ORDER BY pr.effectiveDate DESC
                  )
             ELSE (SELECT TOP 1 sr.rate
                   FROM ShiftRates sr
                   WHERE (sr.shiftID = s.ID) AND (sr.effectiveDate < GETDATE()) 
                   ORDER BY pr.effectiveDate DESC                
                  ) --s.rate 
        END) AS rate
FROM Projects p INNER JOIN
     Shifts s 
     ON p.ID = s.projectID
WHERE p.ID = @projectID;

Popularity 5/10 Helpfulness 2/10 Language whatever

Source: stackoverflow.com

Tags: case-statement select using whatever

Link to this answer
Share Copy Link

Contributed on Mar 11 2023

Poor Peccary

0 Answers Avg Quality 2/10

Using select inside case statement

Contents

More Related Answers

Using select inside case statement

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.