GilaMonster (10/29/2014)

---

M Joomun (10/29/2014)

---

Ed Wagner (10/29/2014)

---

I hope you don't have any critical data being stored on a user's local drive. I know you said it's a political situation, but...

Ed Wagner (10/29/2014)

---

I hope you don't have any critical data being stored on a user's local drive. I know you said it's a political situation, but storing critical data...

Thank you both for your replies. I need to get back to the users as you've raised some interesting questions about data recovery.

Luis Cazares (8/21/2014)

---

I'd use a cross tabs approach which seems more flexible, but that's up to you.

SELECT YEAR(DateFormCompleted) AS YearRecruited,

Hospital,

COUNT(CASE WHEN month(DateFormCompleted)...

Hello both,

Thanks for your replies.

As to the table schema, tblPerson - tblManagementOfBleeding is a 1 ~ 1. I've attached screenshots which give more detail. Do you need anything else?

Yes, that's it. I shouldn't have included Subject Number in my original SQL - apologies.

Thanks both of you for your help.

I've attached an excel spreadsheet of what I' like. I want a 'Total' column at the end which would add all the medication use for that particular hospital.

Thank you Luis,

I've tried your approach, but this is not quite what I'm looking for.

Mark Eckeard (11/26/2013)

---

Hard to say w/o your schema and sample data but would this work?

select (T1.HB-T2.HB) as CalcValue

from SampleResults T1

inner join SampleResults T2

on T1.SubjectNumber = T2.SubjectNumber

where T1.SampleType = 1

and T2.SampleType...

Sean Lange (8/5/2013)

---

M Joomun (8/5/2013)

---

Because it's looking...

Because it's looking for a fixed length...

Yes, thanks Sean. Changing the dataype has worked.

Sean Lange (8/5/2013)

---

Hard to know for sure but I suspect the problem is that you have a fixed length datatype char(9). That means your query is very likely to not...

That's just the problem. The stored procedure only returns a result if I enter a complete SubjectNumber, i.e. 'UK010001'. If I enter 'UK01', it should return all records that start...

To answer my own question, I needed to configure the Windows Firewall to allow access via port 1433. The solution can be found here:

http://msdn.microsoft.com/en-us/library/ms175043.aspx