What errors are you getting? Also try moving the join criteria out of the where clause, it will make easier to work out whats going on.

Hi Steve

I'll take this.

Regards

There is actually quite a lot of value. When creating a system in a team environment, it allows the db developer to create all...

SUPER SQL STAR (3/16/2011)

---

Now there's a misnomer...

Sorry, must behave... The following links should get you started.

I've run the SELECT part of the statement in Master and a user database and it works, so the problem is no there. Without knowing the details of DBAdmin.dbo.sysprocesses_blocking_log, I...

I thought it was on 31st April,;-) or maybe on 22nd july.:-P

OK, from what I can see, you have an unhandled exception in btn_Search_Click. Stick some error handling in there at least. You have a null reference exception, so an object...

greg.bull (3/10/2011)

---

Thanks to you for responding. I am a newbie however, and wonder if a more worked example based on my dataset could be provided - possibly combining both techniques...

Wouldn't MERGE be useful in this situation?

You may also want to read this[/url] article comparing table variable with temp tables. It may explain the differences between the performance differences between the two.

This sounds like it could be a stale statistics problem. Have you run an update stats on your database?

Thanks for the link Steve. I was looking for something more from the virtualisation angle and came up with this which seems a good starting point.

Any chance of turning this into a SSC article? I'm sure there are plenty who...

I can infer from your initial post that:

1 Job can have 1 or many codes

1 Code can can belong to 1 or many jobs.

This is an example of a many...

By user, do you mean application users? That would be up to the admins of the machine. They could restrict user access to the directories where the files are. If...