Unfortunately, no. Row_number() function was launched in SQL 2005

You will have to find another ways for SQL 2000

Do as follows in the report designer- layout - report parameters

1. Check the items: Allow Null value and Allow blank value

2. Add blank/null in the available values

It works for me.

Also...

You will find your answer here

Linking to the Previous Row

http://www.sqlservercentral.com/articles/T-SQL/62159/

You can say

EXEC [Your Stored Procedure] null

It will depend on your stored procedure what result it will give if you provide null as a parameter value to the stored procedure...

Just use

EXEC [Your Stored Procedure]

in your Query String. You can use Parameters also as follows

EXEC [Your Stored Procedure] @[AnyParameter]

Of course you have to write your procedure yourself 🙂

I have been a seasoned Oracle developer before I was given assignments to develop using SQL Server around 3.5 years back. SQLServerCentral has been very fruitful to keep in tune...

You...

SQL Server 2008 will allow to store dates from 1/1/0001 to 12/31/9999.

We can say that MS is creating history 🙂

Thanks for info Jano Petras,

Could you provide the same info about the datatypes DATE & DATETIME2...

Thanks Adam. You are right. This is the required modification in the 2nd query which I pointed to in my 2nd post.

Best regards,

Maz

In case of situation where yopu have multiple products with the 4th highest price, you need to modify the quieries a little.

such as (use the with ties option with the...

There can be so many ways to do it:

Following are two of the ways; one using the top clause and the other using the ranking function row_number()of the SQL Server...

Nice to know. A happy end to the hair raising thriller.

By the way, the issue with your query is not the ovnd_key='13'. The issue is if the value of...

Hi thumor,

Now here is the climax of this nerve wracking thriller :exclamation:

select distinct h.ovnd_key, h.customer, h.division

from ord1 h , prcr c

where h.customer = c.customer

and h.division = c.division

and...

You are right david. It would be immensely useful in more complicated situations. I would have...