List of Contributions

Hi Daron, I just took a look at my query and found the issue was because of A.DESCRLONG and C.DESCRLONG. I've removed them and now the listagg works as expected. Thanks for your help. ------------------------------ Pheng Xiong Ph.D. Senior Associate Registrar Rochester Institute of Technology ...

Hi Daron, Here is my full SQL: SELECT B.ACAD_GROUP, B.SUBJECT, B.CATALOG_NBR, A.CRSE_ID, A.COURSE_TITLE_LONG, A.DESCRLONG, A.COMPONENT_PRIMARY, E.DESCR, C.DESCRLONG, B.SSR_CRSE_TYPOFF_CD, B.CAMPUS, CASE WHEN A.UNITS_MINIMUM = A.UNITS_MAXIMUM THEN TO_CHAR( A.UNITS_MINIMUM | | '.00') WHEN A.UNITS_MINIMUM ...

I'm working on a query to identify a list of courses in the course catalog with a GE course attribute (CRSE_ATTR). I created a LISTAGG expression to list the Course Attribute Value (CRSE_ATTR_VALUE) all on one row instead of multiple rows, but I am getting a CLOB error message. Here is my expression: ...

Thank you, Daniel. That seems to have worked. I didn't think about a subquery. ------------------------------ Pheng Xiong Senior Associate Registrar Rochester Institute of Technology ------------------------------ Message from the HEUG Marketplace: ------------------------------ Find, Review, ...

Thanks Vic. I initially had it set as an expression as you noted, but the issue is that the term table will display the description for every term the class was offered, ignoring the expression. Here i a screen capture of what I saw when I used the expression of max(STRM) with and without the TERM_V ...