sqldeployhelmet

/* A list of contacts */
SELECT a.acctNo, c.name, c.email
FROM contacts c JOIN accounts a ON a.acctNo = c.acctNo
ORDER BY a.acctNo, c.contactNo

sqldeployhelmet

/* A pivoted list of contacts */
WITH contactsCTE AS (SELECT a.acctNo
                     , c.name
                     , c.email
                     , ROW_NUMBER() OVER (PARTITION BY a.acctNo ORDER BY c.ContactID) AS ConNumber
                      FROM contacts c JOIN accounts a ON a.acctNo = c.acctNo)
SELECT acctNo
      , MIN(name1) AS Name1 
      , MIN(email1) AS Email1
      , MIN(name2) AS Name2

sqldeployhelmet

UPDATE DW_DBNAME.dbo.DW_TABLE
SET ETL_JOB_SEQ_NUM = 1027140 ,
ETL_IUD_CD = 'D' ,
ETL_UPD_DTM = CONVERT(DATETIME, '03/16/2016 01:01:17')
WHERE ETL_VERS_START_DTM = CONVERT(DATETIME, '12/27/2014 00:26:24.137')
AND ACCT_NO = '5001194157'
AND ACCT_TYPE = 'ILN';

sqldeployhelmet

EXEC master.dbo.xp_backup_database @database = '<database name>',
@filename = 'Y:\SQL_BACKUPS\<name of backup file>', @filegroup = '<filegroup to backup>'
            , @compressionlevel = 4, @cryptlevel = 8, @encryptionkey = N'IMMAENCRYPTCHYU'
            , @verify = 1, @returndetails = 1, @init = 1, @with = 'CHECKSUM';

sqldeployhelmet

EXEC master.dbo.xp_backup_database @database = '<database name>', @filename = 'Y:\SQL_BACKUPS\<name of backup file>'
    , @compressionlevel = 4, @cryptlevel = 8, @encryptionkey = N'IMMAENCRYPTCHYU'
    , @read_write_filegroups = 1, @verify = 1, @returndetails = 1, @init = 1, @with = 'CHECKSUM';

sqldeployhelmet

EXEC master.dbo.xp_backup_database @database = '', @filename = 'Y:\SQL_BACKUPS\'
        , @compressionlevel = 4, @cryptlevel = 8, @encryptionkey = N'IMMAENCRYPTCHYU'
        , @read_write_filegroups = 1, @verify = 1, @returndetails = 1
        , @init = 1, @with = 'CHECKSUM', @with = 'DIFFERENTIAL';

sqldeployhelmet

EXEC master.dbo.xp_restore_database @database = '', @filename = ''
        , @encryptionkey = N'IMMAENCRYPTCHYU', @read_write_filegroups = 1
        , @with = 'NORECOVERY', @returndetails = 1;

sqldeployhelmet

EXEC master.dbo.xp_restore_database @database = '', @filename = ''
        , @encryptionkey = N'IMMAENCRYPTCHYU', @read_write_filegroups = 1
        , @with = 'RECOVERY', @returndetails = 1;

sqldeployhelmet

EXEC master.dbo.xp_restore_database @database = '', @filename = ''
    , @filegroup = '', @encryptionkey = N'IMMAENCRYPTCHYU', @with = 'RECOVERY'
    , @with = 'MOVE '''' TO ''''', @returndetails = 1

sqldeployhelmet

/* returns all partitioned tables: */
SELECT OBJECT_NAME(p.[object_id]) AS 'TableName'
    , i.[name] AS 'IndexName'
    , i.index_id
    , p.[object_id]
    , au.data_space_id
    , p.partition_number
    , p.hobt_id
    , partitionds.name AS partition_filegroup
INTO #partDist