I have a SQL query
SELECT
BLAH_ID,
BLAH_CODE,
DATEFORMAT(CALENDAR_DATE, 'MM-DD-YYYY') AS CALENDAR_DATE_STR,
HOURS,
'N',
FROM blah_tmp_tbl order by CALENDAR_DATE_STR,BLAH_ID,BLAH_CODE;
OUTPUT TO 'MyExport.CSV' quote '' FORMAT ASCII;
That gets me the below output;
111111,104,07-24-2011,3.15,N,
222222,020 140,07-24-2011,10.00,N,
I would like to split the lines with multiple BLAH_CODE entries like this when performing the SQL query
111111,104,07-24-2011,3.15,N,
222222,020,07-24-2011,10.00,N,
222222,140,07-24-2011,10.00,N,