In which case you might use a nested case to test for this...

Depending on what you want to show when one or both parameters is NULL, what about using default values like so:

use northwind

go

create procedure dbo.test_me

@a datetime ='19000101', @b-2 datetime = '20760601'

as

select...

Under which security context is the stored procedure executed? It it the same in both db's?

Can you post the code?

Hey, nice you visited my site. However, this is my forum signature. My reply is above the signature. Sorry, if this is confusing.

See, if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

For your second question: SQL Server creates a PK as clustered by default. However, you can create the index using the nonclustered keyword explicitely, if you...

Hm, this http://www.rac4sql.com is a frequently referenced tool to help make the move from Access to SQL Server with respect to such issues. Maybe it helps a bit.

You can...

Not sure if I completely understood you or have missed something, but would this help?

use northwind

declare @a datetime

select top 3 @a= shippeddate

from orders

where shippeddate is not null

order by shippeddate

select...

Do a search here in the fora or in the script section. IIRC hat Antares686 posted a solution to your problem some time ago.

Btw, you are aware of the fact...

Sounds like your developer use dynamic sql within their stored procedures. Have a look at these procedures and tell your developers to avoid dynamic sql for updates.

This is of course only for the security of your network, hm?

Just in case you are familiar with VC++, there is or at...

Probably the easiest solution would be to use something like

USE northwind

declare @a bit

set @a = 0

if @a = 0

 select * from orders where shippeddate is null

else

 select * from orders where...

The tool is not for free, I can't afford for it to be. This is my full-time job so as my wife and children cannot live on air - I...

Hm, and altruistic as you are, this tool is provided for free, right?

Do a search in the script section here. As this is not a too exotic task, it's likely that you will find something useful there.