Stupid question... Are you sure that this column exists in the table "outmgd"?

Sounds like the plan of the query needs to be rebuilt... or the indexes and stats need work.

Have you tried recompiling the SP when it starts running slow??

As for the learning curve part.  I just recently started using 2005 but since 99% of what worked on 2000 works on 2005 the basic learning curve is quite easy...

We can try to help you tune your query but we'll need a few things.

Table definition with indexes, the query itself and the execution plan if possible.  I'm sure we...

Run this to create my set based split function :

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null, CONSTRAINT...

You might want to rethink the table design if at all possible... there should be a new table containing the tests instead of 5-10-20 columns???

You were just missing 2 end...

I don't see a lot of possible improvements.  How fast is this running on your server?  Is it at acceptable speed?

Those types of searches are pretty much impossible to...

I think you are looking for partinioning (tables or views).  Check out books online for more details.  I can't help much because I never had to use that feature.

I've never heard of anything like that... the only thing I can suggest is that they use templates which contain the begin tran statement... but other than that I don't...

You want to do that in case they accidentally delete/update some important data??

If this is the case, then I  really suggest you set up a test environnement where they can...

First you should not use <> null; you should use "is not null" (you can search for articles on this matter on this site... there must be like 5-10 of...

You NEVER HAVE TO use dynamic sql.  There's always a way around it by coding correctly. Now I agree that sometimes it's a waste of time to go around dynamic...

Can we get the full problem (sample data, required output and table definition)... There's a few ways to do this but it depends on what comes before and after that...

Dick's idea is great if you can't make the initial code work... but since you can, I have to agree with you that you're better off with a single proc...

That's also why it's better to use outer joins for queries like that .