Report Properties | Code

looks promising

Maybe i can get a embedded VisualBasic challenge/response thing to work nicely

Letting the target report decide what to display could be a useful approach. Perhaps subreports are not quite the way to go, since all subreport queries get run regardless and...

Thanks Koen,

I was hoping not to write too much code, but perhaps the URL option is where I'll end up.

One thing about using an expression for the target report name........

I was not proposing that the WHERE and the ORDER BY were cooperating in some way to get the 3 values of the result. Those 3 values match the 3...

I would have thought the "order by" clause is absoutely necessary to guarantee a match to the sequence supplied as the answer. There is no implicit row order involved in...

Thanks Lynn, got it. Safer is Better,

YYYYMMDD is in fact the Basic date format proposed by ISO8601.

YYYY-MM-DD is named the Extended format.

Using either is OK by the standard.

Shaking head. Moving on.

Given a Calendar table something like this one

(I only allow NULLS for the contruction phase of the table)

CREATE TABLE [dbo].[Calendar](

[CalendarDate] [smalldatetime] NOT NULL,

...

Using Joe's Calendar table, this might provide a way for the kapil to get to the answer he wants.

It removes the need to recursively check if you added another sunday...

Anyone know if Joe's query

SELECT (C2.julian_business_nbr - C1.julian_business_nbr)

FROM Calendar AS C1, Calendar AS C2

WHERE C1.cal_date = '2007-04-05',

AND C2.cal_date = '2007-04-10';

causes a cross join before the complete...

Maybe I'm missing something here but why do you have an Identity column that you can abritrarily change the value of?

Hi Bernabe,

Nice idea if you have the need.

I was thinking of a less procedural approach and came up with this.

Given a "Calendar Table" with the following definition

CREATE TABLE [dbo].[Dates](

[CalendarDate] [smalldatetime]...

After creating a clustered index on the Months.Monthname (ref my first post) and rearranging the Select as follows, I get about the same performance as Jeff's original select.

SELECT Amount,...

Thanks for the pointers Jeff.

I'll SARG and test again