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 |
satya068
Posting Yak Master
233 Posts |
Posted - 2011-11-22 : 08:19:42
|
Hi,can someone tell me about the below error messageMsg 402, Level 16, State 1, Line 1The data types varchar and varchar are incompatible in the boolean AND operator. for the below script.SELECT 'Community Contact' AS ScheduleType, PATIENTS.PASID, SEXXX.MAIN_CODE AS Sex, PATIENTS.DTTM_OF_BIRTH AS DOB, REFERRALS.REFRL_REFNO AS ReferralID, REFERRALS.RECVD_DTTM AS ReferralDate, SCP.SCHDL_REFNO AS ContactID,SCP.START_DTTM AS ContactDate, CONTY.MAIN_CODE AS ContactTypeCode, ATTND.DESCRIPTION AS AttendanceStatus,ATTND.MAIN_CODE AS AttendanceStatusCode, HEALTH_ORGANISATIONS.DESCRIPTION AS Location, HEALTH_ORGANISATIONS.MAIN_IDENT AS LocationCode,LOTYP.DESCRIPTION AS LocationType, [HCPs].[SURNAME] & ',' & [HCPs].[FORENAME] AS HCP, SPECIALTIES.DESCRIPTION AS ContactSpecialty, HCPs.PROCA_REFNO, SCP.START_DTTM, SCP.END_DTTM, PATIENTS.SURNAME, PATIENTS.FORENAME, PATIENTS.NHS_IDENTIFIER FROM SCHEDULES AS SCP-------------- |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-11-22 : 08:24:59
|
Use + instead of & for concatenating strings as in:[HCPs].[SURNAME] + ',' + [HCPs].[FORENAME] AS HCP, |
 |
|
satya068
Posting Yak Master
233 Posts |
Posted - 2011-11-22 : 08:27:34
|
Thanx Sunita. |
 |
|
|
|
|
|
|