SQL multi facts

declare
@A int = 1 ,@B int = 3 , @C int =20 , @D int =16

INSERTINTO @temp(A,B,C,D)
SELECT *
FROM
(
SELECT 1 As A, 2 AS B, 3 AS C, 4 AS D
UNION SELECT 1 As A, 2 AS B, null AS C, null AS D
UNION SELECT 1 As A, 2 AS B, 4 AS C, 5 AS D
UNION SELECT 1 As A, 3 AS B, 2 AS C, null AS D
UNION SELECT 1 As A, 3 AS B, 2 AS C, 7 AS D
UNION select 1 As A, 3 AS B, null AS C, null AS D
) A

SELECT
TOP 1 * FROM

@temp
WHERE
(A = @A AND B=@B AND C=@C AND D=@D) OR
(A = @A AND B=@B AND C=@C AND D IS NULL) OR
(A = @A AND B=@B AND C IS NULL AND D IS NULL) OR
(A = @A AND B IS NULL AND C IS NULL AND D IS NULL)
orderby D DESC,C DESC,B DESC,A DESC

Read More

FeedbackMessage

.ASPX AFTER

<%= this.message %>

.CSS --------------------------------------------------------------------------------- .errorBox { border:solid 2px Red; padding: 3px 3px 3px 3px; color:Red; text-align:left; } .errorImage { vertical-align:bottom; margin-bottom:-5px; } .InfoBox { border:solid 1px Blue; padding: 3px 3px 3px 3px; font-size:11px; } .InfoImage { vertical-align:bottom; margin-top:-6px; } .msbox { position: fixed; width: 400px; float:left; z-index: 8000; top: -50px; left:40%; } .msboximg { position: absolute; float: right; right: -10px; top: -10px; } .messagebox { background-color: Blue; height: 40px; text-align: center; width: 100%; } .MessageText { vertical-align: middle; margin-top: 5px; font-family: Trebuchet MS; color: White; } .userbox { background-color: #90D0f0; } .contentbox { background-color: #F5F9FF; } --------------------------------------------------------------------------------- .CS public enum MessageType{SUCCESS,WARNING,INFO,FAIL}; public void ShowMessage(string message,MessageType Type = MessageType.INFO,string MoreInfo="") { this.message = message; this.msmtext.Attributes["Title"] = MoreInfo; switch(Type) { case MessageType.FAIL: this.Messagebox.Style["background-color"] = "Red"; break; case MessageType.INFO: this.Messagebox.Style["background-color"] = "Blue"; break; case MessageType.SUCCESS: this.Messagebox.Style["background-color"] = "Green"; break; case MessageType.WARNING: this.Messagebox.Style["background-color"] = "Orange"; break; } }
Read More

SQL generate Years <=100

WITH ListYear AS
     ( SELECT 1913 AS YEAR
             UNION ALL
        SELECT lyear.YEAR + 1 AS YEAR
        FROM ListYear lyear
        WHERE lyear.YEAR + 1 <= YEAR(GetDate())
     )
SELECT YEAR FROM ListYear ORDER BY YEAR DESC;

Read More