Useful SQL queries

SQLQueries.md

SQL queries

Some of the sql queries I used at some point :)

Files in this gist

• SQLHeaderCommentFormat: Format for the header of the queries
• SelectRowWhenOtherRowDontExist.sql: Select the row that fulfill the condition, if that row does not exist or there is no row fulfilling that condition, chose another one

SelectRowWhenOtherRowDontExist.sql

SELECT  TOP 1 EmailType.EmailAddress
FROM (
    SELECT TOP	 1 * 
    FROM ContactEmail ce 
    WHERE ce.EmailTypeId = 5 AND ce.ContactBaseId = @contactId 	 
    UNION	  
    SELECT TOP 1 *
    FROM ContactEmail agce  
    WHERE agce.EmailTypeId = 1 AND agce.ContactBaseId = @contactId
) AS EmailType

SQLHeaderCommentFormat

/***************************************************************************************
** Auth:
** Date:
** Desc:
** File:
** Name:
**************************
** Unit Tests
**************************

**************************
** Change History
**************************
** PR   Date	    	Author  					Description
** --   --------   		---------------------   	------------------------------------
** 1    01/10/2008      Dan      					added  inner join
*****************************************************************************************/