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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 query problem

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 colmn

for example like

testname 22-01-2010 23-01-2010 24-01-2010 result group result_id


this 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 by

row value to column name in SQL using dynamic sql in sql server 2005
Go to Top of Page

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..
Go to Top of Page
   

- Advertisement -