I still get all records when passing 0. 🙁

Jason, thanks for your help. I don't know what to say about Part 1 though. I'm using Northwind on a 2000 Server. I get all records when 0...

Perhaps I could look into that, but

1) In your example, a passed value of 0 returns all records

2) That example was simple. I would like to do some...

Thanks Jason. Could you help me one step further? This is a basic example of how I might use this:

(Using Northwind)

CREATE PROCEDURE Test

@employee int = NULL

AS

SELECT @employee =...

Thanks Jack. I will check this out.

Thank you polecat! This is perfect and gives the desired result set.

DECLARE @dummy varchar(25)

SELECT@dummy = 'Sales Representative' --'Inside Sales Coordinator'--'Vice President, Sales'--NULL

SELECT * FROM #TestTable

WHERE (isnull(Title,'Sales Representative') = @dummy)...

Jeff,

Thanks, I appreciate your help. I do it the way I know how until I learn a better way. Then once I learn a better way (learning from...

Thanks for the suggestions.

ALZDBA, I was able to add a where clause and that did help a bit.

Greg, the times are all over.

With index I got 1:05 and 2:20.

Without I...

Jeff,

I don't see where the lazy is in your code. After a while, I was able to produce the desired result set on my own. My post then transformed...

Loner,

I smell what you steppin in.

Hey Jeff, thanks again. I had more time to look at it and made two minor changes. The core query is the same, but I

1) used a TABLE...

Thanks Jeff! I was hoping you would respond. You always have such brilliant responses!!

Many thanks!!

Here's a shorter version, but I know there is still room for improvement.

DECLARE @date smalldatetime,

@counter int

SELECT @date = '1998-06-11',

...

Here's one solution but it is quite lengthy. I'm sure there is a more efficient answer. So please show me your wisdom!

I used a different column though...

I can try. Can you explain what "ext" means precisely?