May 16, 2006 15:21
SO along with my extreme boredom and going back and forth in emails today with nick at work. Since we work on diffeent mesas...
This whole Mesa business...with me working in the Kearny Mesa and him in the La...which actually in spanish means the so he actually works in the the mesa. I am a mess today. Seriously people have their heads firmly planted in their behinds today. Ive been just chomping on starburst and playign games on POGO so I actually seem to be working. Well I am in a sense its just being locked away in this small little room I have no real members to assist. Its a little lame back here.
Now when I decide to write in here the dipshits emerge from the sess pool of society and come to bother me...grr..Ill be right back.
SO anyways i snuck off to a break cause I needed a cig.
ANick and I are so excited for our trip to Oregon and he is super excited to see his sister. We are leaving on our drive in two days its crazy how quickly its coming.
I cant wait!!
Anyways I made this little bugger to pass the time.
SELECT A.PersNbr,
LastName || ', ' || FirstName || decode(MDLINIT,'','', ' ' || MDLINIT || '.') || decode(suffix,'','',' ' || suffix),
substr(pack_osi_util.func_FormatTaxid(A.TaxId,'PERS', :gvsMaskTINYN),1,20),
LastName,
FirstName,
FirstName || ' '|| decode(MDLINIT,'','', MDLINIT || '. ') || LastName || decode(suffix,'','',' ' || suffix),
B.MemberAgreeNbr
INTO :coln0000Nbr,
:cols0000SearchResult,
:cols0000TaxId,
:cols0000LastName,
:cols0000FirstName,
:cols0000ReturnName,
:coln0000MemberAgreeNbr FROM MEMBERAGREEMENT B, PERS A WHERE LastNameUpper = :dlg_000201_PersSearch.dfs0000LastName AND B.PrimaryPersNbr(+) = A.PersNbr ORDER BY LastNameUpper, FirstNameUpper, MdlInit
OK I am so done. I need some tequila.
People need to go back into the holes they came from.