Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kishorevkk2003
Starting Member
1 Post |
 Posted - 2009-04-29 : 02:52:58
|
| IF PS_C_VCHR_CNTL_STG.ACCOUNTING_DT = $NULL_DT EVALUATE PS_ORIGIN_AP_OPT.ACCOUNTING_DT_IND WHEN = 'D' EVALUATE PS_BUS_UNIT_OPT_AP.ACCOUNTING_DT_IND WHEN = 'S' MOVE PS_BUS_UNIT_OPT_AP.ACCOUNTING_DT TO $ACCOUNTING_DT WHEN = 'C' MOVE PS_C_CYCLE_TBL.C_CYCLE_DT TO $ACCOUNTING_DT END-EVALUATE WHEN = 'S' MOVE PS_ORIGIN_AP_OPT.ACCOUNTING_DT TO $ACCOUNTING_DT WHEN = 'C' MOVE PS_C_CYCLE_TBL.C_CYCLE_DT TO $ACCOUNTING_DT END-EVALUATEELSE MOVE PS_C_VCHR_CNTL_STG.ACCOUNTING_DT TO $ACCOUNTING_DT IF PS_C_VCHR_HDR_STG.ACCOUNTING_DT > $ACCOUNTING_DT MOVE PS_C_VCHR_HDR_STG.ACCOUNTING_DT TO $ACCOUNTING_DT END-IF IF $ACCOUNTING_DT <= PS_C_CYCLE_TBL.C_CYCLE_DT SELECT B.OPEN_PERIOD_FROM FROM PS_C_MONTH_TBL A, PS_BU_LED_GRP_TBL B WHERE B.BUSINESS_UNIT = $BUSINESS_UNIT AND B.LEDGER_GROUP = 'ACTUALS' AND B.OPEN_YEAR_FROM = A.YEAROFDATE AND B.OPEN_PERIOD_FROM <= A.MONTHOFDATE AND $ACCOUNTING_DT BETWEEN A.FROM_DATE AND A.THRU_DATE IF $PERIOD_OPEN_FOUND = ‘N’ SELECT MON.FROM_DATE FROM PS_C_MONTH_TBL MON WHERE MON.YEAROFDATE = #YEAR of C_CYCLE_DT AND C_CYCLE_DT BETWEEN MON.FROM_DATE AND MON.THRU_DATE END-IF END-IFEND-IF |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-04-29 : 08:28:57
|
| Pretty sure this is not T-SQL. Try an appropriate forum. (ORACLE or MYSql).[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
SQR CODE TO SQL IF CASE...PLS HELP...