Useful Functions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Useful Functions
| Line 39: | Line 39: | ||
select 'PS_JOB_JR',* from PS_JOB_JR where EMPLID=@in_emplid | select 'PS_JOB_JR',* from PS_JOB_JR where EMPLID=@in_emplid | ||
| - | order by 1,2,3,4 | + | order by 1,2,3,4,5 |
select 'PS_JOB',* from PS_JOB where EMPLID=@in_emplid | select 'PS_JOB',* from PS_JOB where EMPLID=@in_emplid | ||
| - | order by 1,2,3,4 | + | order by 1,2,3,4,5 |
select 'PS_COMPENSATION',* from PS_COMPENSATION where EMPLID=@in_emplid | select 'PS_COMPENSATION',* from PS_COMPENSATION where EMPLID=@in_emplid | ||
| - | order by 1,2,3,4 | + | order by 1,2,3,4,5,6 |
go | go | ||
