Groups > comp.databases.ms-sqlserver > #1833

Re: adding a column to select

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: adding a column to select
Date	2014-11-01 15:06 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA3D899B29DCC0Yazorman@127.0.0.1> (permalink)
References	<74f6aa18-3f13-4af6-9664-9560eab46eff@googlegroups.com>

Show all headers | View raw

Raul Rego (rrego@pmchnnj.org) writes:
> Can I go throiught all notes in toxnotes for casenumber = tp.casenumber
> and bundled them into one display 

You mean concatenate them to a single value? That can be achieved by 
using FOR XML PATH(''), but it is difficult to give you a query, because
I don't know what output more exactly you are looking for.

> full join UHCF hos on hos.UHCFNumber = tp.CallerSiteCode
> full join Codevalue cv_pa on cv_pa.CodeID = tp.patageunit
> full join CodeValue cv_ct  on cv_ct.CodeID = tp.calltype
> full join CodeValue cv_mo on cv_mo.CodeID = te.MedicalOutcome
> full join CodeValue cv_cs on cv_cs.CodeID = tp.CallerSite
> full join CodeValue cv_pt on cv_pt.CodeID = tp.PatGender
> full join CodeValue cv_cr on cv_cr.CodeID = tp.CallerRelToPat
> full join CodeValue cv_er on cv_er.CodeID = tp.ExpReason
> full join  CodeValue cv_es on cv_es.CodeID = tp.ExpSite
> full join CodeValue cv_ms on cv_ms.CodeID = te.ManagementSite

I don't think this is right. FULL JOIN is something you don't use very 
often. Probably you mean a LEFT JOIN for the columns in ToxPat which are
nullable.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

adding a column to select Raul Rego <rrego@pmchnnj.org> - 2014-10-31 10:47 -0700
  Re: adding a column to select Erland Sommarskog <esquel@sommarskog.se> - 2014-11-01 15:06 +0100
    Re: adding a column to select Raul Rego <rrego@pmchnnj.org> - 2014-11-03 05:13 -0800
      Re: adding a column to select Erland Sommarskog <esquel@sommarskog.se> - 2014-11-03 18:14 +0100
        Re: adding a column to select Ross Presser <rpresser@gmail.com> - 2014-11-03 09:56 -0800

csiph-web