Hi,
Whether it is possible to check the if condition in with statement .
below is the with statement that i am using but an error is thrown as incorrect syntax near 'if'
WITH GET_MYPROFILE_BSCHOOL_DATA_BY_DECISION
(
MEMBER_SCHOOL_APPLICATION_ID,BUSINESS_SCHOOL_NME,BUSINESS_SCHOOL_NME_ID,ROUND_APPLIED_VALUE,ROUND_APPLIED_DESC,
GRADUATION_YEAR_DESC,REAPPLICANT_IND,ALUMNI_RECOMMENDATION_COUNT,ADMISSION_CONSULTANT_IND,INTERVIEW_DTE,
WAITLISTED_IND,FINAL_DECISION_IND,FINAL_DECISION_RECEIVED_DTE,MATRICULATE_IND,DECISION_IND,DECISION_RECEIVED_DTE
) AS
(
IF ( SELECT COUNT(*) FROM MEMBER_SCHOOL_APPLICATION_TABLE WHERE WAITLISTED_IND='N' AND FINAL_DECISION_IND='U' AND DECISION_IND != 'L' ) >0
BEGIN
SELECT a.MEMBER_SCHOOL_APPLICATION_ID, b.BUSINESS_SCHOOL_NME, a.BUSINESS_SCHOOL_NME_ID,
c.ROUND_APPLIED_VALUE,c.ROUND_APPLIED_DESC, d.GRADUATION_YEAR_DESC,
(CASE a.REAPPLICANT_IND WHEN 'Y' THEN 'Yes' WHEN 'N' THEN 'No' ELSE A.REAPPLICANT_IND END)
AS REAPPLICANT_IND, a.ALUMNI_RECOMMENDATION_COUNT, (CASE a.ADMISSION_CONSULTANT_IND
WHEN 'Y' THEN 'Yes' WHEN 'N' THEN 'No' ELSE a.ADMISSION_CONSULTANT_IND END) AS ADMISSION_CONSULTANT_IND,
a.INTERVIEW_DTE, a.WAITLISTED_IND, a.FINAL_DECISION_IND, a.FINAL_DECISION_RECEIVED_DTE,
(CASE a.MATRICULATE_IND WHEN 'Y' THEN 'Yes' WHEN 'N' THEN 'No' ELSE a.MATRICULATE_IND END) AS MATRICULATE_IND,
(CASE A.DECISION_IND WHEN 'A' THEN 'Admitted' WHEN 'R' THEN 'Dinged' WHEN 'W' THEN 'Withdrew'
WHEN 'U' THEN 'Unknown' WHEN 'L' THEN 'Waitlist' ELSE A.DECISION_IND END) AS DECISION_IND,
a.DECISION_RECEIVED_DTE FROM MEMBER_SCHOOL_APPLICATION_TABLE AS a INNER JOIN
MASTER_BUSINESS_SCHOOL_TABLE AS b ON a.BUSINESS_SCHOOL_NME_ID = b.BUSINESS_SCHOOL_ID
INNER JOIN MASTER_ROUND_APPLIED_TABLE AS c ON a.ROUND_APPLIED_ID = c.ROUND_APPLIED_ID
INNER JOIN MASTER_GRADUATION_YEAR_TABLE AS d ON a.GRADUATION_YEAR_ID = d.GRADUATION_YEAR_ID
WHERE
(a.DELETE_IND='F') AND (A.WAITLISTED_IND='N') AND (A.FINAL_DECISION_IND='U') AND (A.DECISION_IND != 'L')
END
)
SELECT
A.MEMBER_SCHOOL_APPLICATION_ID,A.BUSINESS_SCHOOL_NME,A.BUSINESS_SCHOOL_NME_ID,A.ROUND_APPLIED_VALUE,
A.ROUND_APPLIED_DESC,A.GRADUATION_YEAR_DESC,A.REAPPLICANT_IND,A.ALUMNI_RECOMMENDATION_COUNT,
A.ADMISSION_CONSULTANT_IND,A.INTERVIEW_DTE,A.WAITLISTED_IND,A.FINAL_DECISION_IND,A.FINAL_DECISION_RECEIVED_DTE,
A.MATRICULATE_IND,A.DECISION_IND,A.DECISION_RECEIVED_DTE
FROM GET_MYPROFILE_BSCHOOL_DATA_BY_DECISION A
Please send me the solution. where i went wrong.
thanku bye
|
No responses found. Be the first to respond and make money from revenue sharing program.
|