What about DB Ghost (http://www.dbghost.com/)

Hi All,

Thanks for the responses so far. I can't really do any kind of joins, is because I need to be able to allocate manufacture order qty's to customer...

Hi Gail, Chris,

Thank you both for your help.

I think I might have a stable secure procedure now, which does appear to be running substantially faster than previously and under all...

Oh also, thanks for that link to the Catch-all post. That was highly informative.

Hi Chris,

Thanks for the feedback.

So today I figured I'd start by building a whole new query which uses a string building method.

I've only tested 2 of the most basic scenarios...

The below is the current SP if that helps anyone help me.

CREATE PROCEDURE [dbo].[uspJobSearch_TEST]

@csType as varchar(20),

@status as varchar(20),

@startID as varchar(50),

@endID as varchar(50),

@complaintType as varchar(50),

@Subject as varchar(100),

@ComplaintDateStart as...

Hi Mark,

Thanks for the reply.

That is a shame that it doesn't really exist.

Is no one able to help?

Are there any other forums I should post the question on?

Thanks

Yes Exactly that. Thank you. As I said brain fart. For some reason I was trying From (Select ... from ...) instead of egnoring the select line.

Thank god...

Hey, thanks guys this has been a great help.

If I run the below statement just as a normal query it returns all the records I want it too, but if...

wow, isDate is great. Thanks for taht.

The only problem I have now is that it is returning false for all dates like this 30/07/2010. By the Server and...