What reputation is that?

brown eye

Yep, Phil's correct. I did not see the assignment. You'll need to increment your variable...

Make sure you type cast your counter variable as string....otherwise, you cannot include it in your string variable.

Well, what error are you getting?

What error are you getting?

Just off the top of my head, you need to change your sysdatabases to sys.databases.

Looking back at the original post, I now see that we were not told of the nature of the timeout operation. I was assuming that a SELECT statement was...

No problem, glad to help.

Glad to help.

So now that you've fixed the performance problem with your SP, I think you still have some work to do. Go back to my first post and...

Very interesting...I have never read that before. When performance testing, I typically just issue the DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE commands.

It makes sense that dropping only the...

Where did you get the idea that you have to checkpoint before running this? DBCC DROPCLEANBUFFERS clears out the clean buffers. Checkpoints flush out the dirty buffers so...

One more thing to keep in mind.....if you plan to combine the 2 packages into one, you no longer need the Stored Procedure so everything I stated above was really...

It's how you write an outer join when you want...

First, your stored procedure will still be inefficient. Replace your query with the query that I posted in my last post. You are still using NOT IN....change that...

It really depends on what the data represents. If it represents numeric data, it needs to be stored as a numeric type like int. Theres a difference in...