Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Set @cc = 'GL568';
- Select id, costcenter
- From trxacc
- Where costcenter = Case When @cc = '' Then costcenter Else @cc End
- Select id, costcenter
- From trxacc
- Where costcenter = Case When $P{CostCenter} = '' Then costcenter Else $P{CostCenter} End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement