CASE @CheckBDate WHEN 0 THEN @NullBDate ELSE @BDate END AS BDate,

Is it a casting error?

BTW you should actually drop the temp table at the end of the proc... why should this be a problem for you??

Also note that each user can have its own...

It's not unfair, it's IT - geekfest .

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions in T-SQL

Arrays and Lists in SQL Server

Also this is not gonna work because @uidEventID will not be a...

No you started the Noeld thread, not the sscer.com one... don't try to get me mixed up.

I've been in that place where you say something in the best way you can but it gets misunderstood (that telephone game). Anyways it doesn't execuse his arrogance. ...

HTH.

These might come in handy :

A quote from rudy komacsar

time for:

exec sp_update_resume

possibly time for:

exec sp_distribute_resume

BTW, if yo send one parameter as null, that search condition will be ignored completely the way I wrote it. Can you post some sample data with exemples of...

WHERE

ISNULL(table.col, -1) = @varName

this will kill any possible use of an index on that column. Maybe this article may benefit you :

Dynamic Search Conditions in...

Sounds like he'd get your vote in that favorite sscer contest ...

Still valid point .

Guess we'll never know.

I'd still keep the validation though... it's only one more layer of protection, but it can be hacked too.

How do you call the sp, what are the parameter values?