Click here to Skip to main content
15,886,873 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
sWITH temp as (
SELECT dbo.fn_parsehtml(MCS_CASE_SUMMARY)
,ROW_NUMBER() OVER (
ORDER BY RRH_MR_NUM
) AS RowNum
,RRH_LOCATION_CD
,RRH_MR_NUM
,RRH_FIRST_NAME
,RRH_PAT_SEX
,RRH_REGN_DT
,RRH_PAT_DOB
,MCS_CRT_DTE
FROM MR_CASE_SUMMARY_HISTORY_2015
LEFT OUTER JOIN RE_REGISTRATION_HEADER ON MCS_MRD_NUMBER = rrh_mr_num
LEFT OUTER JOIN CO_PATIENT_ADDRESS_DETAIL ON RRH_COMM_ID = CPA_COMM_ID
AND CPA_MAILING_ADDR = '1'
) SELECT * FROM temp
WHERE RowNum BETWEEN 1 AND 10

i tried this above query shows error as follows

No column name was specified for column 1 of 'temp'

what is the mistake in my above query.


What I have tried:

WITH temp as (
SELECT dbo.fn_parsehtml(MCS_CASE_SUMMARY)
,ROW_NUMBER() OVER (
ORDER BY RRH_MR_NUM
) AS RowNum
,RRH_LOCATION_CD
,RRH_MR_NUM
,RRH_FIRST_NAME
,RRH_PAT_SEX
,RRH_REGN_DT
,RRH_PAT_DOB
,MCS_CRT_DTE
FROM MR_CASE_SUMMARY_HISTORY_2015
LEFT OUTER JOIN RE_REGISTRATION_HEADER ON MCS_MRD_NUMBER = rrh_mr_num
LEFT OUTER JOIN CO_PATIENT_ADDRESS_DETAIL ON RRH_COMM_ID = CPA_COMM_ID
AND CPA_MAILING_ADDR = '1'
) SELECT * FROM temp
WHERE RowNum BETWEEN 1 AND 10

i tried this above query shows error as follows

No column name was specified for column 1 of 'temp'

what is the mistake in my above query.
Posted
Updated 12-Dec-17 20:29pm

1 solution

you need to give name to column 1

SQL
WITH temp as (
SELECT dbo.fn_parsehtml(MCS_CASE_SUMMARY) AS HTMLCode
,ROW_NUMBER() OVER (
ORDER BY RRH_MR_NUM
) AS RowNum
,RRH_LOCATION_CD
,RRH_MR_NUM
,RRH_FIRST_NAME
,RRH_PAT_SEX
,RRH_REGN_DT
,RRH_PAT_DOB
,MCS_CRT_DTE
FROM MR_CASE_SUMMARY_HISTORY_2015
LEFT OUTER JOIN RE_REGISTRATION_HEADER ON MCS_MRD_NUMBER = rrh_mr_num
LEFT OUTER JOIN CO_PATIENT_ADDRESS_DETAIL ON RRH_COMM_ID = CPA_COMM_ID
AND CPA_MAILING_ADDR = '1'
) SELECT * FROM temp
WHERE RowNum BETWEEN 1 AND 10
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900