Skip to content

Instantly share code, notes, and snippets.

@ksummerlin

ksummerlin/blog_post_20120628_1100.sql

Created June 28, 2012 15:01
Show Gist options
  • Save ksummerlin/3011852 to your computer and use it in GitHub Desktop.
Save ksummerlin/3011852 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
blog_post_20120628_1100.sql
select top 3
OH.SalesOrderID,
OH.CustomerId,
OH.SalesOrderNumber,
OH.Status
from Sales.SalesOrderHeader OH
where
OH.CustomerID = @customer_id
and OH.SalesOrderID <> @current_sales_id
order by OH.OrderDate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment