Michael Valentine Jones (10/28/2010)

---

Something like this should do what you want:

select

a.*

from

OPENQUERY ( RHSQL ,

'

Select

Brook2.dbo.GetCurrentAdmissionDate(1) as AdminDate,

Brook2.dbo.GetDOTFromDOA(1),

Brook2.dbo.GetCurrentAdmissionDate(1) as DischargeDate

from

Brook2.dbo.Admission

' ) a

Note that you will have to build the whole query dynamically...

GilaMonster (2/3/2009)

---

ex__inferis (2/3/2009)

---

So in a way I am not critisizing him. I'm actually critisizing all of you for replying, however correctly and kindly, in a way that someone doing his...

I don't mean to sound derogatory towards the OP at all. Not everyone's first language is English (mine isn't). And out of those people a large percentage are less than...

I guess after this usefull info the question becomes:

Has the OP learnt anything or was the English over his head?