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

Untitled

By: a guest on Apr 29th, 2012  |  syntax: None  |  size: 0.69 KB  |  hits: 20  |  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. Sql Select Issue
  2. SELECT Message, SentDate FROM Messages
  3. WHERE SenderUserId=@CurrentUser AND ReceiverUserId=@OtherUser
  4. OR SenderUserId=@CurrentUser AND ReceiverUserId=@OtherUser
  5.        
  6. SELECT Message, SentDate ,
  7. CASE
  8.   WHEN SenderUserId=@CurrentUser THEN 'True'
  9.   ELSE 'False'
  10. END as is_sent_by_current_user
  11. FROM Messages  
  12. WHERE (SenderUserId=@CurrentUser AND ReceiverUserId=@OtherUser )
  13. OR (ReceiverUserId=@CurrentUser AND SenderUserId=@OtherUser)
  14.        
  15. SELECT Message, SentDate,case when SenderUserId = @CurrentUser then 'true' else 'false' end as sentByYou FROM Messages
  16. WHERE (SenderUserId=@CurrentUser AND ReceiverUserId=@OtherUser)
  17. OR (SenderUserId=@OtherUser AND ReceiverUserId=@CurrentUser)
create a new version of this paste RAW Paste Data