hi
От | Penchalaiah P. |
---|---|
Тема | hi |
Дата | |
Msg-id | A70AE049E81A6A40879D5DC0AC8C38C9098382EE@venus.infics.com обсуждение исходный текст |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I want to fix the pay based on joining date and antedate…antedate is the last date…</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Joining date is 01-07-2007</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Antedate is 04-07-2005..</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">On joining date I will fix the pay but before fixing the pay I will check whether antedate is there ornot, if its there then I will see difference between 2 dates..if difference is 2 years then I will fix the pay with increments…ifdifference is less than 2 years then I will fix the pay with out increments…</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Take an example of above 2 dates..there is no 2 years difference between two dates…</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">01-07-2007 I will fix the pay…after 3 days current date = antedate…so again I have to fix the pay without my intervention…</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Is there any jobs or schedules or triggers to call that function when current date and antedate is equal…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><strong><b><font face="Monotype Corsiva" size="3"><span style="font-size:12.0pt;font-family:"MonotypeCorsiva"">Thanks & Regards</span></font></b></strong><p class="MsoNormal"><strong><b><fontface="Monotype Corsiva" size="3"><span style="font-size:12.0pt;font-family:"Monotype Corsiva"">PenchalReddy</span></font></b></strong><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div><table><tr><td bgcolor="#ffffff"><font color="#000000">Information transmitted by this e-mailis proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individualor the entity to which it is addressed, and may contain information that is privileged, confidential or exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwardedto you without proper authority, you are notified that any use or dissemination of this information in any manneris strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email fromyour records.<br /></font></td></tr></table>