The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Using partial class, when working with LINQ to SQL Stored Procedures
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Sebastien ComeaueditedPosted Jul 30, 2009, 9:52 AMEdited Jul 30, 2009, 9:53 AM
Use this : where (@Site = -999 OR SiteNum = @Site) instead of this: where SiteNum = case when @Site = -999 then SiteNum else (@Site) end