That error tells me you have made additional changes and now you have a situation where the query is trying to use your tables as aliases and cannot figure it...

Okay, I reformatted your query and used aliases. What I found is another problem you have:

CREATE PROCEDURE usp_rptOpenTicketsByYard

AS

SELECT t.*

,ts.status

,tp.priority

,cts.Description

,tct.CallType

,u.First_Name

,u.Last_Name

,yi.YardName

,t.CreatedOn

,t.Yard

,tp.PriorityStatus

,CASE WHEN t.ProjectTicketOption = 0

...

gomikem (7/22/2008)

---

Thank you guys for all your help! I've gotten the query working so far, but I'm trying to figure out Aliasing on Joins. I can't seem to...

Andy Warren (7/22/2008)

---

Have to find the tipping point. Drop/create may or may not be faster, for example if you are adding 1 million rows to a 100 million row table....

Is there a particular...

I have used this feature a lot in an ETL process where it is very useful. The process is:

1) Extract data from OLTP into staging tables

2) Disable...

I have to ask - why are you using dynamic SQL? There is no need in this case - just write the query and use the variable as you...

I recommend reviewing the help in BOL for sp_send_dbmail for additional parameters.

From BOL:

[ @query = ] 'query'

Is a query to execute. The results of the query can be attached as...

Hmmm,...

Eera (7/21/2008)

---

Thank you all for your replies.

I will have no problem if i add a new identity column and make it a PK. and this is the quickest solution....

jonathanmreynolds (7/21/2008)

---

Jeffrey Williams (7/21/2008)

---

The alias t1 was used in the sub-query and I didn't remove it. Modify the sum statements and change the reference from t1 to t and...

Optional parameters can be done using the following:

CREATE PROCEDURE [procedure]

@date1 datetime

...

The call to the procedure should be:

Execute...

To do something like this you are going to have to use dynamic SQL. You might want to consider putting a procedure in each database instead and call the...

The only thing I can think of is that the database was deleted far enough back that it no longer shows up in the default trace.