I totally agree...

The column is listed within the SUM function, outside of the subquery:

SUM([SLAMet])/COUNT([y.WO_NUM])*100 AS '%TotalMetSLA',

Thank you Sean.

I added the 'FROM' keyword to the query, and now I'm receiving another error.

Msg 207, Level 16, State 1, Line 33

Invalid column name 'WO_NUM'.

The WO_NUM is...

Thank you Lowell,

When I execute the revised query, I'm now receiving a syntax error.

Msg 102, Level 15, State 1, Line 28

Incorrect syntax near 'x'.

Just wondering if I need to add...

After some tweaking with the subquery and limiting one of the criterias within the WHERE clause, I was able to get it to work!

Thank you John!

John Michael Robertson (11/17/2011)

---

Your LEFT JOIN table has columns specified in the WHERE clause checking for specific values, thereby eliminating the not matched rows.

and cd.documentname like '%patient profile'

and cd.isincomplete...

Hello Craig!

The OPTION (FORCE ORDER) worked great! Thank you so much! I'm going to run this in a test environment and execute an optimization plan against it.

Pete

Thank you Craig,

Here are the results from the first query:

SELECT top 20 tud.Value

FROM cv3taskuserdata tud

WHERE ISDATE(tud.value) = 1

2010-10-07

2010-10-07 08:58

2010-10-29

2010-10-29 10:11

2010-10-07

2010-10-07 09:01

2010-10-07

2010-10-07 09:00

2010-10-12

2010-10-12 13:23

2010-10-12

2010-10-12 13:24

2010-10-12

2010-10-12...

No result set came back from the second query.

Thank you 🙂

Thanks Craig,

Below is the result set from the queries that you sent me:

SELECT top 20

oto.performedfromdtm

FROM

CV3OrderTaskOccurrence oto (nolock)

WHERE...

The compatibility mode is set to 100 on the SQL Server 2008 R2 server, and 90 on the SQL Server 2005 server.

Thanks guys.

Yes the tud.value column is a varchar column, but further down in the query within the WHERE clause, the tud.userdatacode = 'PRX IVPB EndDTM' criteria is limiting...

Hello Mike,

Thank you for the reply. The code still fails with the same error.

PMF

Nice job Timothy! Your article certainly covers all the bases, troubleshooting, monitoring, & performance tuning.

Taking snapshots of a server throughout the day (under normal conditions) is a great idea...

Todd McDermid (5/4/2010)

---

Contrary to your experience, I haven't had any "backwards compatibility" problems using Excel with SSIS in an x64 environment - be it 2003 server, 2008 server, Vista, or...