How to make Upper first CHAR Word

UPDATE [TableName]
SET = UPPER(LEFT(LOWER(), 1)) + SUBSTRING(LOWER(), 2, LEN())
Read More

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

SQL add 0 with Integer

DECLARE @DONSEQ INTEGER SET @DONSEQ =1 SELECT RIGHT('00'+ CONVERT(VARCHAR,@DONSEQ),3) AS NUM
Read More

Cam Akumal Beach

http://www.locogringo.com/Upload/akumal-beach-cam.html
http://www.bahia-principe.com/pt/hoteis/riviera-maia/resort-tulum/excursoes
Read More

INSERT INTO

INSERT INTO TableName
(TableName.CLIENT,
TableName.ENTITY,
TableName.CREATEDBY,
TableName.CREATEDATE,
TableName.UPDATEDBY,
TableName.UPDATEDBY,
TableName.INTERVINIENTTYPEID,
TableName.INTERVINIENTSRELATIONSHIPID,
TableName.[ClientNumber],
TableName.[EntityNumber])

SELECT TableName.[Id], TableName5.[Id],
'7',GETDATE(),'7',GETDATE(),
TableName2.[Id], TableName3.[Id],
TableName4.LTNCLI,TableName4.LTNTIT
FROM
[DataBaseName].[dbo].[TableName4]
LEFT JOIN DataBaseName.dbo.TableName ON LTRIM(RTRIM(TableName4.[LTNCLI])) = LTRIM(RTRIM(TableName.[ClientNumber]))
LEFT JOIN DataBaseName.dbo.TableName5 ON LTRIM(RTRIM(TableName4.[LTNTIT])) = LTRIM(RTRIM(TableName5.[EntityNumber]))
LEFT JOIN DataBaseName.dbo.TableName2 ON TableName4.[LTRCLI] = TableName2.[ExternalCode]
LEFT JOIN DataBaseName.dbo.TableName3 ON TableName4.[LTRCPE] = TableName3.[Description]
AND TableName3.[isActive] = 1
Read More

Duplicated records

SELECT "Key and/or Foreign Key" ,COUNT(1)
FROM "TableName"
GROUP BY "Key and/or Foreign Key"
HAVING COUNT(1) > 1
Read More