|
View previous topic :: View next topic
|
| Author |
Message |
chrakesh
New User
.jpg)
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
1.Select SAN column from EPQP table.
2. If the value exists in SAN, verify if current date is greater than or equal to Start of Frame date (which is Gate 10) + 90 days (i.e. GATE date + 90 days). If the condition satisfies set RESPLTY to ‘C’ else ‘A’
3.Check ART (part) and PCHSNG (country) in EPQP if the values are not present go to PBLN and get the SAN code SAN where EVENT IN (‘023000’,‘007000’), and in that order
4.If exists, perform step (ii), above.
please can anyone write the required statements.... i need it so badly.... |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| chrakesh wrote: |
| please can anyone write the required statements.... i need it so badly.... |
Any urgency involved with your request is totally yours, and yours alone.
Also, it would be a very good idea to keep in mind that
This is a HELP forum, not a Do it for ME forum |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| i need it so badly.... |
forums are not the best place for solving crucial issues
also when asking for help avoid using <local> acronyms,
for a few fields/columns it is always possible to define them in neutral terms
we all have enough to try to understand the questions posed,
we would be happy not to have to decode Your local terminology
and...
use meaningful titles |
|
| Back to top |
|
|
chrakesh
New User
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
| I am just reqesting not Ordering, reqesting for help. |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
Just asking... 
Do you need to do all this in one sql statement or are you asking for 3 separate statements or are you asking for a whole program ? |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Marso wrote: |
| are you asking for a whole program ? |
Then what he will do?  |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| Then what he will do? |
bookmark this site in anticipation of his next assignment.
keep in mind, he may have to not only debug it,
but go thru a turnover process - paperwork!!!! |
|
| Back to top |
|
|
chrakesh
New User
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
Either of it in 1 sql or 3 sql's..
Thank u.... |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
Your request have been filed under serial number #RB0027.
It will be processed within the next 8 months.
If you cannot wait that much, I advise you to try writing some code by yourself.
And if you have questions about (or problems with) your code, you are welcome to come back here for help. |
|
| Back to top |
|
|
|
|
