ScottPletcher (6/1/2012)

---

I strongly suspect you will want to see more details on the last appointment than just the date:

SELECT

CustomerId, AppointmentDate, ...

FROM (

SELECT...

steviemoxford (5/31/2012)

---

I'm trying to write a formula so it basically brings back all the primary diagnosis fields (hospital data) except the following shown below - The problem I'm having is...

SQLUserC (6/1/2012)

---

Hey all,

I realize this may seem like a basic question but it involves correlated sub-queries which I don't have a rigorous understanding of yet.

Let's say there's an Appointments table...

Your GROUP BY looks okay, but I don't see ANY aggregates in the SELECT list.

Steve Jones - SSC Editor (6/1/2012)

---

Doctor Who 2 (5/31/2012)

---

No, GSQuared, I haven't tried LinkedIn. I am on it, but tend to spend my time there either interacting with others...

Is this a native SQL backup from SQL Server 2000 you are trying to restore to SQL Server 2005?

Wouldn't this work?

SELECT

CmpCompanyCode,

cmpCompanyName,

E.eecCoID,

E.EecEEID, --unique number stays with person, if listed more then once

E.EecOrgLvl2,

E.eecDateOfLastHire,

E.eecDateOfTermination,

E.eecEmplStatus,

E.eecEmpNo,

E.eecLocation,

E.eecFullTimeorPartTime,

E.eecJobCode,

eepNameLast,

eepNameSuffix,

eepNameFirst,

EepNameMiddle

FROM EmpPers JOIN EmpComp E...

Cadavre (6/1/2012)

---

I really need to get one of those crystal balls that you guys all seem to have :w00t:

I guess...

That was me at...

barryocteau (6/1/2012)

---

Want to perform a simple SELECT * query and ORDER BY [ColumnX] ASC.

A simple single column query of, say, names.

Would like to organize the data returned as such:

A

Apples

Appricots

B

Banana

Blue Berries

C

Clementime

....

.....

Not...

Here is the problem, we can't see from here what you see. You are basically asking us to shoot in the dark and hope we hit the mark. ...

I have to agree with what was said above, you need to normalize this data.

BigInt – 150 (PositionCol1, PositionCol2…………PositionCol150)

Int - 5

SmallInt – 5

Date – 150 (SourceDateCol1, SourceDate2,………….SourceDate150)

DateTime – 2

Varchar(2000) –...

Per Gail's request above, please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/quote]

Please understand that we can't see from here what you see there, unless you...

That I can't help with. I'm not a SSRS specialist. Read your post and it just sounds like caching. Ran into with SQL Server Agent when programmatically...

Shot in the dark, cached information?