rEFInd Boot Manager

$ ./install.sh
Not running as root; attempting to elevate privileges via sudo....
Password:
Installing rEFInd on OS X....
Installing rEFInd to the partition mounted at /Volumes/ESP
Found suspected Linux partition(s); installing ext4fs driver.
Installing driver for ext4 (ext4_ia32.efi)
Copied rEFInd binary files

Copying sample configuration file as refind.conf; edit this file to configure
rEFInd.


WARNING: If you have an Advanced Format disk, *DO NOT* attempt to check the
bless status with 'bless --info', since this is known to cause disk corruption
on some systems!!


Installation has completed successfully.

Unmounting install dir

Combine Multiple rows into single column using FOR XML

TABLE DATA

ORDERNUM	SEQNUM	note
00000001	1	PLEASE ADVISE MARY ANN WHEN READY FOR
00000001	2	CUSTOMER PICK UP
00112216	1	Use 52' Reefer
00112217	1	Call for delivery appointment
00112218	1	Deliver to stock room
00112219	1	Must ship by:  10/20/04
00112220	1	Call for delivery appointment
00112221	1	Ship via reefer
00112223	1	Smile at the driver
00112224	1	Smile at the buyer

SQL

WITH orderNotes(ORDERNUM,notes) AS
(
SELECT DISTINCT
	rtrim(ltrim(a.ORDERNUM)),
	stuff((SELECT
			', ' + 
				CASE WHEN b.SEQNUM = 100 THEN
				'<b>' + CONVERT(VARCHAR,b.SEQNUM) + ' - ' + rtrim(ltrim(b.note)) + '</b>'
				ELSE
				CONVERT(VARCHAR,b.SEQNUM) + ' - ' + rtrim(ltrim(b.note))
				END
			FROM
			NOTES b
			WHERE b.ORDERNUM = a.ORDERNUM ORDER BY SEQNUM
        FOR xml path('li')),1,1,'< ') AS notes
FROM
	NOTES a 
)
SELECT * FROM orderNotes ORDER BY ORDERNUM

OUTPUT

ORDERNUM	notes
00000001	<li>, 1 - PLEASE ADVISE MARY ANN WHEN READY FOR</li><li>, 2 - CUSTOMER PICK UP</li>
00112216	<li>, 1 - Use 52' Reefer</li>
00112217	<li>, 1 - Call for delivery appointment</li>
00112218	<li>, 1 - Deliver to stock room</li>
00112219	<li>, 1 - Must ship by:  10/20/04</li>
00112220	<li>, 1 - Call for delivery appointment</li>
00112221	<li>, 1 - Ship via reefer</li>
00112223	<li>, 1 - Smile at the driver</li>
00112224	<li>, 1 - Smile at the buyer</li>

via: http://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with