Today's question (by Steve Jones - SSC Editor):

The 12 days of Christmas

CREATE TABLE TwelveDays (gift VARCHAR(100))
GO
INSERT dbo.TwelveDays (gift) VALUES 
( 'A partridge in a pear tree'),
( 'Two turtle doves'),
( 'Three French hens'),
( 'Four calling birds'),
( 'Five gold rings'),
( 'Six geese a-laying'),
( 'Seven swans a-swimming'),
( 'Eight maids a-milking'),
( 'Nine ladies dancing'),
(  'Ten lords a-leaping'),
(  'Eleven pipers piping'),
(  'Twelve drummers drumming   ')
GO
CREATE TABLE Numbers (n INT, word VARCHAR(20))
GO
INSERT dbo.Numbers (n, word) VALUES 
 (1, 'A '),
 (2, 'Two'),
 (3, 'Three'),
 (4, 'Four'),
 (5, 'Five'),
 (6, 'Six'),
 (7, 'Seven'),
 (8, 'Eight'),
 (9, 'Nine'),
 (10, 'Ten'),
 (11, 'Eleven'),
 (12, 'Twelve')
GO

SELECT gift 
 FROM dbo.TwelveDays AS td
 INNER JOIN dbo.Numbers AS n

 ORDER BY n

Think you know the answer? Click here, and find out if you are right.

The SQL Server Upgrade Targets

Using the SQL Server Migration Assistant, when coming from Access, DB2, Oracle, MySQL, or SAP ASE, which versions of SQL Server can I target? I am ignoring Azure Synapse as a separate offering.

Answer: SQL Server 2012 through SQL Server 2019, as well as Azure SQL Database and MI

Explanation: The SSMA actually lets you target 2012 through 2019 with the Azure offerings. Ref: SQL Server Migration Assistant - https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver16

Discuss this question and answer on the forums

Here's a few of the new posts today on the forums. To see more, visit the forums.