Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. Set @cc = 'GL568';
  2.  
  3. Select id, costcenter
  4. From trxacc
  5. Where costcenter = Case When @cc = '' Then costcenter Else @cc End
  6.  
  7. Select id, costcenter
  8. From trxacc
  9. Where costcenter = Case When $P{CostCenter} = '' Then costcenter Else $P{CostCenter} End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement