Useful Functions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Useful Functions
| Line 1: | Line 1: | ||
| + | [[Microsoft SQL Server]] script useful for [[PeopleSoft]]: | ||
<pre> | <pre> | ||
/************************************************************************************** | /************************************************************************************** | ||
| Line 39: | Line 40: | ||
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 | ||
