I looked at your query from a slightly different perspective. Not sure if this is going to be any better, but I'm joining to your transactions table...

myjobsinus (5/27/2015)

---

Sorry i guess the statement 'Archive DB is a copy of the Main DB' is not correct.

Data in the Source Database and Archive Database is different. so we want...

I'm not sure why you would want to do that. Those views would just end up with the same kind of resultset as the following:

SELECT *

FROM TABLE1

UNION ALL

SELECT...

DBA2015 (5/27/2015)

---

sgmunson (5/26/2015)

---

I suspect that the original poster meant to use FROM in place of WHERE, but given the code, I'm fairly sure that there's a much easier way to...

Why even parameterize the date if you have the date needed in the table? Just change the query that exists for the report itself to do an INNER...

ramana3327 (5/26/2015)

---

Hi,

SELECT TOP 20

ROUND(s.avg_total_user_cost *

s.avg_user_impact

* (s.user_seeks + s.user_scans),0)

...

PJ_SQL (5/26/2015)

---

Hi,

I have table which consists of images. I am trying to export those images to a folder.

declare @path varchar(100)= 'c:\images\'

SELECT [PICTURE]

,@path+[PICTURE] AS Path

FROM [A].[dbo].[PICTURE]

I am getting this error:...

I suspect that the original poster meant to use FROM in place of WHERE, but given the code, I'm fairly sure that there's a much easier way to code this...

Velveeta22 (2/17/2015)

---

Matched the column names to the original stuck query and added friendly alias'. Results pull matching data in both test and prod (fresh data). My hope is...

Velveeta22 (2/17/2015)

---

Matched the column names to the original stuck query and added friendly alias'. Results pull matching data in both test and prod (fresh data). My hope is...

The following part of the LEFT JOIN isn't needed:

AND O.CompanyClientMemberID IS NOT NULL

That field is already part of the rest of the JOIN condition (the specific line follows) based on...

Let me know if the following simplified version of that previous query is functionally equivalent:

DECLARE @p0 DATETIME = '2013-12-23 15:09:31.000';

DECLARE @p1 INT = 1;

DECLARE @p2 INT = 1;...

Matt Miller (#4) (2/12/2015)

---

Jeff Moden (2/12/2015)

---

I'm thinking that the following from the original code could be the real problem here. Dunno for sure because I don't know the data...

ChrisM@home (2/12/2015)

---

You're absolutely right Steve, it's an OUTER APPLY coded using CROSS APPLY! I'd love to see some ddl and dml for the tables referenced within it. If the rest...

ChrisM@home (2/12/2015)

---

sgmunson (2/12/2015)

---

ChrisM@Work,

Just curious, but I've never seen anyone use an ON clause together with CROSS APPLY. Given that it's an ON 1=1, it would seem to be...