Snap.

But you said that wasn't the actual code you're running. Why does Piotr's example not work for you?

John

Yes, something like this:

SELECT SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME AS ProcName, LAST_ALTERED

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = 'PROCEDURE'

AND LAST_ALTERED > GETDATE() - 7

John

Debbie

A wrapper procedure is just a procedure that calls other procedures. Now, what is it exactly that you're trying to do?

John

Is your server involved in replication or log shipping? If not, it sounds as if you have 10GB of uncommitted transaction(s). Try using DBCC OPENTRAN and sp_who2 to...

Do you have users using the database at midnight? If not, it's probably a scheduled job that's doing it. If you do have users on at that time,...

Or you can do what somebody suggested on one of...

OK, how about putting the result set of the function into a temp table:

SELECT dbo.fn_Find_Security_Details(Sedol_Number, AsAt)

INTO #MyTempTable

FROM #tmpUsed

and then joining to that instead?

John

Jamie

Will this work?

...FROM #tmpUsed t INNER JOIN (

SELECT Bid, Price_date, sedol_number

FROM dbo.fn_Find_Security_Details(Sedol_Number, AsAt)

) f

ON f.sedol_number=t.sedol_number

John

As I mentioned, that's an extreme example. ...

Ah. Please take care to post in the correct forum. There are no CTEs in SQL Server 2000. Would you be able to use a subquery instead?...

Jeff Moden (3/13/2008)

---

No... no way to create a temp view. Creating a TempTable to hold what the TempView would have contained is the next best thing and pretty darned...

Kiran

You should read the topic "Cardinality estimation" in Books Online. If there's anything you don't understand, or if it doesn't cover everything you need to know, please post again....

Does this work where the foreign key constraint consists of more than one column?

John

What have you tried so far? It would also help if you were to post the DDL for your table(s) and some sample data.

Thanks

John