Useful Functions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Useful Functions
| Line 76: | Line 76: | ||
upper(EMPLID) like upper(@in_value) | upper(EMPLID) like upper(@in_value) | ||
or upper(OPRID) like upper(@in_value) | or upper(OPRID) like upper(@in_value) | ||
| + | order by 1,2,3,4 | ||
select left('PS_PERSONAL_DATA' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,NAME | select left('PS_PERSONAL_DATA' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,NAME | ||
| Line 81: | Line 82: | ||
where upper(EMPLID) like upper(@in_value) | where upper(EMPLID) like upper(@in_value) | ||
or upper(NAME) like upper(@pct + @in_value + @pct) | or upper(NAME) like upper(@pct + @in_value + @pct) | ||
| + | order by 1,2,3 | ||
select left('PS_PERS_DATA_EFFDT' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,EFFDT | select left('PS_PERS_DATA_EFFDT' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,EFFDT | ||
| Line 90: | Line 92: | ||
where upper(EMPLID) like upper(@in_value) | where upper(EMPLID) like upper(@in_value) | ||
or upper(NAME) like upper(@pct + @in_value + @pct) | or upper(NAME) like upper(@pct + @in_value + @pct) | ||
| + | order by 1,2,3,4 | ||
select left('PS_PERS_NID' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,COUNTRY,NATIONAL_ID_TYPE,NATIONAL_ID | select left('PS_PERS_NID' COLLATE DATABASE_DEFAULT + @pad,30) as Record,EMPLID,COUNTRY,NATIONAL_ID_TYPE,NATIONAL_ID | ||
| Line 95: | Line 98: | ||
where upper(EMPLID) like upper(@in_value) | where upper(EMPLID) like upper(@in_value) | ||
or upper(NATIONAL_ID) like upper(@pct + @in_value + @pct) | or upper(NATIONAL_ID) like upper(@pct + @in_value + @pct) | ||
| + | order by 1,2,3,4 | ||
select left('PS_HR_TBH_DATA' COLLATE DATABASE_DEFAULT + @pad,30) as Record,TBH_SEQ,RECNAME,FIELDNAME,TBH_CHAR | select left('PS_HR_TBH_DATA' COLLATE DATABASE_DEFAULT + @pad,30) as Record,TBH_SEQ,RECNAME,FIELDNAME,TBH_CHAR | ||
from PS_HR_TBH_DATA | from PS_HR_TBH_DATA | ||
where upper(TBH_CHAR) like upper(@pct + @in_value + @pct) | where upper(TBH_CHAR) like upper(@pct + @in_value + @pct) | ||
| + | order by 1,2,3,4 | ||
select left('PSOPRDEFN' COLLATE DATABASE_DEFAULT + @pad,30) as Record,OPRID,EMPLID,OPRDEFNDESC | select left('PSOPRDEFN' COLLATE DATABASE_DEFAULT + @pad,30) as Record,OPRID,EMPLID,OPRDEFNDESC | ||
| Line 106: | Line 111: | ||
or upper(OPRDEFNDESC) like upper(@pct + @in_value + @pct) | or upper(OPRDEFNDESC) like upper(@pct + @in_value + @pct) | ||
or upper(EMPLID) like upper(@pct + @in_value + @pct) | or upper(EMPLID) like upper(@pct + @in_value + @pct) | ||
| + | order by 1,2,3,4 | ||
go | go | ||
| Line 159: | Line 165: | ||
where | where | ||
upper(HR_SSTEXT_TEXT) like upper('%' COLLATE DATABASE_DEFAULT +@in_text+'%' COLLATE DATABASE_DEFAULT) | upper(HR_SSTEXT_TEXT) like upper('%' COLLATE DATABASE_DEFAULT +@in_text+'%' COLLATE DATABASE_DEFAULT) | ||
| + | order by 1,2,3,4 | ||
go | go | ||
