| Author | Message | ||
     Eureka Junior Artist Username: Eureka Post Number: 119 Registered: 06-2013 Posted From: 208.81.12.34 Rating: N/A |
OUTLAW: Nice question; edi work ayyindo cheppandi | ||
| Outlaw Side Hero Username: Outlaw Post Number: 5191 Registered: 02-2012 Posted From: 66.193.93.3 Rating: N/A |
thnaks guys | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 20619 Registered: 01-2012 Posted From: 199.67.140.45 Rating: N/A |
banam query ni follow aipo kakapote listagg ki 4000 char limit untadi.. if length of your icd codes for a patient exceeds 4000 chars xmlagg ani clob ki convert chese function vaadumu | ||
| Contra Junior Artist Username: Contra Post Number: 149 Registered: 03-2012 Posted From: 24.171.168.250 Rating: N/A |
idi try cheyyandi..... select deptno, rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames from emp group by deptno | ||
| Banam Side Hero Username: Banam Post Number: 5762 Registered: 12-2011 Posted From: 162.118.16.5 Rating: N/A |
select patientID, listagg (ICDCODE, ',') WITHIN GROUP(ORDER BY ICDCODE) ICDCODES FROM TABLENAME GROUP BY patientID Sir Sachin Ramesh Tendulkar || Green Bay Packers || San Antonio Spurs | ||
| Phoenix Side Hero Username: Phoenix Post Number: 4048 Registered: 10-2012 Posted From: 155.35.46.62 Rating: N/A |
as it is ga question google thalliki este edhi ochindi...answer edhi kakapothe kukkamkandi..manam sql bebebe... http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f9f7 b1be-963a-48a6-9bcc-9badc047a708/why-you-would-sometimes-use -where-in-clause-in-sub-query-instead-of-inner-or-outer-join ?forum=transactsql | ||
| Outlaw Side Hero Username: Outlaw Post Number: 5190 Registered: 02-2012 Posted From: 66.193.93.3 Rating: N/A |
Can you solve this? 22. Table that contains Patient IDs and ICD codes, but I donât know how many ICD codes each patient has. As a result, I want to flatten this table, how would you do it? EXAMPLE: Table âPatientsâ has: Patient1 Code1 Patient1 Code2 Patient2 Code7 Patient3 Code1 Patient3 Code2 Patient3 Code3 Result should look like: Patient1 Code1,Code2 Patient2 Code7 Patient3 Code1,Code2,Code3 |
