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 |
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-07-26 : 04:54:50
|
[code]SELECT "Result Date", "Result", "Test","Group",RESULT_ID FROM ( SELECT TOP 10 * FROM ( SELECT TOP 10 RESULTS_DATE_TIME AS "Result Date" ,RESULT as "Result",TEST_NAME as "Test", RESULTS_DATE_TIME as ENC_DATE,RESULT_ID,LAB_GROUP_NAME as "Group" FROM ( SELECT RESULTS_DATE_TIME,TEST_NAME,cast(RESULTS as varchar(4000)) as RESULT,LAB_GROUP_NAME,RESULT_ID from EMRVWNUMLABRESULTS NLR INNER JOIN EMRENCOUNTERDETAILS ED ON ED.PARENT_ENCOUNTER_ID = NLR.PARENT_ENCOUNTER_ID where ED.IS_SAVE_FOR_LATER IN (0,4) AND NLR.PATIENT_ID='210330' UNION SELECT RESULTS_DATE_TIME,TEST_NAME,cast(RESULTS as varchar(4000)) as RESULT,LAB_GROUP_NAME,RESULT_ID from EMRVWTextualLabResults NLR INNER JOIN EMRENCOUNTERDETAILS ED ON ED.PARENT_ENCOUNTER_ID = NLR.PARENT_ENCOUNTER_ID where ED.IS_SAVE_FOR_LATER IN (0,4) AND NLR.PATIENT_ID='210330' UNION SELECT RESULTS_DATE_TIME,TEST_NAME,RESULTS ,LAB_GROUP_NAME,RESULT_ID from EMRVWTextualLabResults where PATIENT_ID='210330' AND PARENT_ENCOUNTER_ID IS NULL UNION SELECT RESULTS_DATE_TIME,TEST_NAME,RESULTS ,LAB_GROUP_NAME,RESULT_ID from EMRVWNUMLABRESULTS where PATIENT_ID='210330' AND PARENT_ENCOUNTER_ID IS NULL )TEMP1 ORDER BY RESULT_ID ASC )tbl1 ORDER BY RESULT_ID DESC )tbl2 ORDER BY RESULT_ID ASC[/code]hi now i want in above query where testname should come for all result date colmnfor example liketestname 22-01-2010 23-01-2010 24-01-2010 result group result_idthis is just like Split Column Data Into Multiple Lines depending on result date column values |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-07-26 : 05:48:07
|
hi how to achieve the above one byrow value to column name in SQL using dynamic sql in sql server 2005 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-07-26 : 06:14:12
|
hi how to achieve it using pivot query can u please help me out in this.. |
|
|
|
|
|
|
|