when I try your hardcoded logic   I get  0 for X and 100 for y

 select 25/40 *100 
 select 100 - ((25/40)*100)

Based on your logic same...

• This reply was modified 2 years, 6 months ago by  Madhu g.
• This reply was modified 2 years, 6 months ago by  Madhu g.

select * 
from    (
         Select SubmissionGuid,QuoteStatus
         ,RowNum =...

select t.DC, substring(t.DC,1,charindex(' ',t.DC)) FROM t

this will remove anything after the space

t.DC     modifiedt.DC

CASE WHEN DueDate = CAST (GETDATE() AS DATE) THEN DATEADD(dd,-1, DueDate ) else DueDate end

so here we are saying if Due date  = today(Max date) then you subtract a day...