(select cast(1 as int) as OrderID, cast('3/1/2012' as date) as OrderDate, cast(10.00 as money) as OrderAmt, 'Joe' as CustomerName union select 2, '3/1/2012', 11.00, 'Sam' union select 3, '3/2/2012', 10.00, 'Beth' union select 4, '3/2/2012', 15.00, 'Joe' union s...
(select cast(1 as int) as OrderID, cast('3/1/2012' as date) as OrderDate, cast(10.00 as money) as OrderAmt, 'Joe' as CustomerName union select 2, '3/1/2012', 11.00, 'Sam' union select 3, '3/2/2012', 10.00, 'Beth' union select 4, '3/2/2012', 15.00, 'Joe' union s...