Shucks - not only do I need to learn SQL 2005, but I also need to learn to navigate this site better 🙂 Sorry about that...

Got it Craig. here it is:

SET @Where = @Where + 'AND ProbTicketSubDept LIKE ''%'' + @_Dept + ''%'' '

All single quotes of course. Seems to be working OK....

Hi Craig and thanks. OK, I added those single quotes like so:

SET @Where = @Where + 'AND ProbTicketSubDept LIKE ''%@_Dept%'' '

I got no errors but no records were returned...

Hi Gail - to intialize @Where, I did this right after declaring it:

SET @Where = ''

When I tried to do this:

@Where NVARCHAR(4000) = ''

I got this error message:

Cannot assign a...

Gail - you are awesome. Thanks again.

I did read and use your example on your blog as my template. Unfortunately, in the proces of making my changes, I...

Hi Gail - got one more question for you. Here's what I now have:

ALTER PROCEDURE [dbo].[PTicketSearch]

(

@StartDate datetime = NULL,

@EndDate datetime = NULL,

@Dept nvarchar(50) = NULL,

@Submitter nvarchar(100) = NULL,

@Assigned...

Gail - and a big thanks to you too of course. Wishing you a happy and safe holiday season with your family and happy New Year!

Craig - thanks so much for your post today. Really appreciated and a little overwhelmed here by your going above-and-beyond with all your help - especially to an anonymous...

Gail - I am SO sorry. Found the problem in the procedure. Like you mentioned, I MESSED UP the quotes big time. I used a combination of single/doouble which...

ARGGHH! Sorry about that Gail! I meant single quotes... Thanks again!

Hi Craig aand thanks again. OK, so I commented out 'execute(@SQL)' and put in 'print(@SQL)'. I got the following message:

SELECT * FROM PROBLEMTICKET WHERE 1=1 AND PROBTICKETDATE...

Thanks Gail! OK so using NULL for the parameters returned all the records which is good. I then put in the double quotes. Now when I entered...

Thanks GilaMonster for the link! Very interesting and helpful blog post.

Here you go! Thanks again Craig.

ALTER PROCEDURE [dbo].[PTicketSearch]

(

@StartDate datetime,

@EndDate datetime,

@Submitter varchar(100),

@Assigned varchar(100),

@status varchar(10)

)

AS

BEGIN

DECLARE @sql...

Thanks Craig! That's taken care of now. But when I execute the stored procedure to test like so (just trying to get ALL records from the table):

-- exec...