Decimal points and thousand separators

SELECT
CAST(CONVERT(VARCHAR, CAST(A.HOURLY_RT AS MONEY), 1) AS VARCHAR)

Multiple EMail Addresses

SELECT A. EMPLID, A .NAME, B.E_ADDR_TYPE , B. EMAIL_ADDR, B .PREF_EMAIL_FLAG

  FROM PS_PX_ACTV_WRKR_VW A , PS_EMAIL_ADDRESSES B

  WHERE ( A. EFFDT =

        (SELECT MAX(A_ED .EFFDT) FROM PS_PX_ACTV_WRKR_VW A_ED

        WHERE A. EMPLID = A_ED .EMPLID

          AND A. EMPL_RCD = A_ED .EMPL_RCD

          AND A_ED. EFFDT <= SUBSTRING(CONVERT (CHAR, GETDATE(),121 ), 1, 10))

    AND A .EFFSEQ =

        (SELECT MAX(A_ES .EFFSEQ) FROM PS_PX_ACTV_WRKR_VW A_ES

        WHERE A. EMPLID = A_ES .EMPLID

          AND A. EMPL_RCD = A_ES .EMPL_RCD

          AND A. EFFDT = A_ES .EFFDT)

     AND A. EMPLID = B .EMPLID

     AND A. EMPLID IN (SELECT C .EMPLID

                                           FROM PS_EMAIL_ADDRESSES C

                                            GROUP BY C.EMPLID

                                           HAVING COUNT (*) > 1) )

ORDER BY 2, 3 , 4

Schedule JobSet Definitions

Need to Update/Delete the data from the following 7 tables:

1. PS_SCHDLDEFN
2. PS_SCHDLITEM
3. PS_SCHDLNODEPARM
4. PS_SCHDLNOTIFY
5. PS_SCHDLMESSAGE
6. PS_SCHDLDEFNINFO
7. PS_SCHDLTEXT

select 'PS_SCHDLDEFN' , * from PS_SCHDLDEFN where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLITEM' , * from PS_SCHDLITEM where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLNODEPARM' , * from PS_SCHDLNODEPARM   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLNOTIFY' , * from PS_SCHDLNOTIFY   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLMESSAGE' , * from PS_SCHDLMESSAGE   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLDEFNINFO' , * from PS_SCHDLDEFNINFO   where SCHEDULENAME like 'PRI009%'

select 'PS_SCHDLTEXT' , * from PS_SCHDLTEXT   where SCHEDULENAME like 'PRI009%'

Peoplesoft: Error while opening Schedule Jobset: peopletools, audit check

This issue is documented in Oracle note 656527.1.

The reason for the "no matching buffer found for level (15,26)" is because of orphaned rows.  When reading data from the DB into the component buffers, the panel processor checks for the existence of a parent row. If the parent row does not exist, then the error message is thrown.  Check for orphaned rows in the component tables.

For the Schedule JobSet definitions case, use below statements to Delete SCHEDULENAME causing ISSUE:

SQL> DELETE FROM PS_SCHDLITEM WHERE SCHEDULENAME='SCHEDULE causing issues';
SQL> DELETE FROM PS_SCHDLDEFNINFO WHERE SCHEDULENAME='SCHEDULE causing issues';
SQL> DELETE FROM PS_SCHDLDEFN WHERE SCHEDULENAME='SCHEDULE causing issues'; 

SELECT *

  FROM [PNRP1PH] . [dbo] . [PS_SCHDLITEM]

WHERE [SCHEDULENAME] like 'HRI00%'

 

select *

from PS_SCHDLDEFNINFO

WHERE [SCHEDULENAME] like 'HRI00%'

 

select *

from PS_SCHDLDEFN

WHERE [SCHEDULENAME] like 'HRI00%'

SharePoint Invalid Characters for Sites, Folders, and Files

SharePoint has reserved characters invalid for site names, subsite names, group names, folder names, and document names.These are the invalid characters (see also KB article 905231) :

• Site Names
• Following characters are not allowed: | # { } % & " ~ + \ / : * ? " < >
• A site name, subsite name, or a site group name should NOT begin with an underscore (_) or period character.
• Do not use an underscore or a period. Cons: 
• Cannot use the period character consecutively in the middle of a site name
• Cannot use the period character at the end of a site name
  
  
• Folder Names and File Names
• Do not use: " # % & * : < > ? \ / { | } ~
• File names cannot be longer than 128 characters
• Do not use the period character consecutively in the middle of a file name.  For example, "file..name.docx" is invalid.
• Do not use the period character at the end of a file name
• Do not start a file name with the period character

Google Maps Navigator

Wow, has anyone seen the new Google Maps Navigation in action. I would definitely like to try one of those new Motorola Droid phones. It seems that Google Maps Navigator is going to replace my old Garmin after all!

Take a look at this video:





Or read more about it on Garett Rogers' blog entry: http://blogs.zdnet.com/Google/?p=1595

How to redirect a SharePoint website

If you want to redirect a SharePoint website page to another new URL add a Content Editor Web Part to the old site and edit the web part using the Source Editor. Add the following code:

<head>
<meta equiv="refresh" content=".1; URL=http://www.exampleurl.com/">
</head>

Remember that as soon as you click the OK-button to save the web part the page will immediately redirect to the new address