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

Re: adding a column to select

Newsgroups	comp.databases.ms-sqlserver
Date	2014-11-03 09:56 -0800
References	<74f6aa18-3f13-4af6-9664-9560eab46eff@googlegroups.com> <XnsA3D899B29DCC0Yazorman@127.0.0.1> <d63803c9-adab-4188-9437-26a1832acaa4@googlegroups.com> <XnsA3DAB981F3B15Yazorman@127.0.0.1>
Message-ID	<f002837b-e70e-4856-af17-aba4177c06d5@googlegroups.com> (permalink)
Subject	Re: adding a column to select
From	Ross Presser <rpresser@gmail.com>

Show all headers | View raw

On Monday, November 3, 2014 12:14:16 PM UTC-5, Erland Sommarskog
wrote:
> Raul Rego (rrego@...) writes:
> > Erland. yes I gues I will like all NOTE column values for case
> > casenumber concatenated. 
> > 
> > example, for casenumber=1079155 we have many notes entered by
> > date/time and I will like it to display in one single place as
> > such --- Tue Apr 16, 2013 @ 15:00 By  679:asheu --- Dr. Duroche
> > Calling from Community ER
> > 
> 
> I sincerely hope that you did not post actual patient data in a
> public forum!

For one thing, it looked (to me) as if only healthcare provider
names were given, not patient names.

For another, it looked like the patient expired. (If this was all
one patient.)

These two things would probably save Raul from a lawsuit, but it's
still a very bad idea to post any such live data to a public forum.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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