Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. claim[] claimLst = (from clms in dbContext.claims where
  2. clms.@switch == 8
  3. && (clms.Status == "Received Ok" || clms.Auto_Resubmit == 1)
  4. && ((short)clms.tiMarkedForSubmission_M == 0
  5. || (short)clms.tiMarkedForSubmission_T == 0)
  6. select clms).ToArray();
  7.  
  8. exec sp_executesql N'SELECT [t0].[id], [t0].[datetime_received],
  9. [t0].[Uniqueid], [t0].[Practice_number], [t0].[regnum], [t0].[claim_number],
  10. [t0].[Status],
  11. [t0].[Date_time], [t0].[Action], [t0].[Med_resp], [t0].[Tar_resp], [t0].[switch],
  12. [t0].[Auto_Resubmit], [t0].[Auto_Resubmit_Count],
  13. [t0].[tiMarkedForSubmission_M], [t0].[tiMarkedForSubmission_T]
  14. FROM [dbo].[claims] AS [t0]
  15. WHERE ([t0].[switch] = @p0) AND (([t0].[Status] = @p1) OR ([t0].[Auto_Resubmit] = @p2))
  16. AND ((([t0].[tiMarkedForSubmission_M]) = @p3)
  17. OR (([t0].[tiMarkedForSubmission_T]) = @p4))'
  18. ,N'@p0 int,@p1 varchar(8000),@p2 int,@p3 int,@p4 int',
  19. @p0=8,@p1='Received Ok',@p2=1,@p3=0,@p4=0
  20.  
  21. Select * from dbo.claims clms where
  22. clms.switch = 8 AND
  23. (clms.Status = 'Received Ok'
  24. OR clms.Auto_Resubmit = 1)
  25. AND (clms.tiMarkedForSubmission_M = 0
  26. OR clms.tiMarkedForSubmission_T = 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement