Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 25th, 2012  |  syntax: None  |  size: 0.34 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Generic SQL parameters not working in an SqlDataSource for a MySQL connector in ASP.NET
  2. select case when r.id is null then 'Not Scanned' else 'Scanned' end as status,
  3.     count(*) as count
  4. from scanned_items as s
  5. left join required_items as r
  6.     on s.barcode = r.barcode and s.fk_load_id = r.fk_load_id
  7. where s.fk_load_id = @LoadId
  8. group by 1
create a new version of this paste RAW Paste Data