Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. IEnumerable<TabTransaktion> allTransactions
  2. = TabTransaktions1.Union(TabTransaktions2)
  3. .Where(trans => trans.TabVorgang != null).
  4. .OrderBy(tran => tran.TabVorgang.Wirkdatum)
  5. .OrderByDescending(trans2 => trans2.TabVorgang.ID);
  6.  
  7. SELECT BusinessEntityID, SalariedFlag
  8. FROM HumanResources.Employee
  9. ORDER BY CASE SalariedFlag WHEN 1 THEN BusinessEntityID END DESC
  10. ,CASE WHEN SalariedFlag = 0 THEN BusinessEntityID END;
  11. GO
  12.  
  13. IEnumerable<TabTransaktion> mainQuery
  14. = TabTransaktions1.Union(TabTransaktions2)
  15. .Where(trans => trans.TabVorgang != null);
  16.  
  17. var queryOne = mainQuery.Where(p=>p.SalariedFlag ==1)
  18. .OrderByDescending(tran => tran.BusinessEntityID );
  19.  
  20. var queryTwo = mainQuery.Where(p=>p.SalariedFlag ==0)
  21. .OrderBy(tran => tran.BusinessEntityID);
  22.  
  23. var finalResult = queryOne.Union(queryTwo);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement