Database

SELECT 
	@result1 = COUNT(CASE WHEN (isNull(TDR_D20,0)= 0 And isNull(TDR_D40,0)=0 ...)	
		THEN 1 ELSE NULL END),
	@result2 = COUNT(CASE WHEN (isNull(TDR_D20,0)>0 Or isNull(TDR_H20,0)>0 ...)
		THEN 1 ELSE NULL END),
	@result3 = COUNT(CASE WHEN (isNull(TDR_D20,0)=0 AND isNull(TDR_H20,0)=0 ...))
		THEN 1 ELSE NULL END)
FROM table
WHERE Vessel_Code=@Vsl AND Voyage_No=@Voy AND POL=@POL 

IF @result1 = 20    SET @Color='Red Color'
Else IF @result2=20 SET @Color='Blue Color'
Else IF @result3>0  SET @Color='Blue Color'
Else IF @result4>0  SET @Color='Blue Color'
Else IF @result5=20 SET @Color='Green Color'
Else IF @result6>0  SET @Color='Yellow Color'
Else                    @Color='Orange Color'

Select * from Table1 Where (ISNULL(A1,'')=ISNULL(B1,'') and ISNULL(B1,'')=ISNULL(C1,'')) And (ISNULL(A2,'')=ISNULL(B2,'') and ISNULL(B2,'')=ISNULL(C2,'')) And (ISNULL(A3,'')=ISNULL(B3,'') and ISNULL(B3,'')=ISNULL(C3,''))

DECLARE @TableVar1 table(
    Col1 int NOT NULL,
    Col2 varchar(100),
    Col3 datetime
)

INSERT INTO @TableVar1 (Col1, Col2, Col3) VALUES (10, 'Hello', GETDATE())

Select something From tableThis Where ID In (Select somethingelse From tableThat Where condition );

select t1.* 
From tbladussentry t1
join tbladusentry t2
    on t1.SID = t2.Id
join tbladuset t3
    on t2.SID = t3.ID
    and t3.CID in(108,367)

Select Data = CAST(ltrim(rtrim(CAST(@RowData AS nvarchar(max))) AS ntext)