Quote:

I'd suggest that if you're thinking about using procedures, start using them now, not later.

OK, I'll keep this in mind

Jef, I know what you said about using a SP. But at this stage the Javascript is constantly changing and so does the SQL. So a SP would constantly have to...

Jeff, thank you, that is what I needed.

But what is Emeril and why BAM?

Is it a TV program?

Btw I'am not realy expecting a...

Ian,

The DECLARE is just for giving the reader of this tread a simple way for testing the code. In the real world the code is part of a big SQL...

Peter, thanks.

You asked: What are the reasons for needing to mention the parameter only once

The answer is not a real answer:

 "someone else (...)...

A UDF would be a solution, I think.

But, it should be possible without UDF.

I know that I once had a similar problem and had a solution based on a INNER...

Thank you KH, thank you very much.

I'll try your sql (I will also try to understand it).

What does the #dates mean? I never used a construction like that.

I will...

Jeff,

Some background information for you:

I need to show the days of 6 weeks on the internet.

Ie: When someone chooses the month september 2005 I want to show him/her a table...

Try this URL:

http://www.sqlservercentral.com/columnists/dpoole/alookatmysql.asp

It's about DTS but there are some MySql facts, seen from the point of view of SQLServer

I find it comical, to "misuse" the SYSOBJECTS table for getting a range of numbers

And thanks, for heading me in the good direction. 

Yelena, thank you for the extended explanation.

But I used the code of Jef and Carl because it fits the best in the way I have to use these date. I...

Yelena, thank you.

I never wordked with a cursor, I am more used to select statements, but it is nice to see this solution (now I see what KH ment, when...

Jeff, as you say:

"The difficult can be done immediately... the impossible takes slightly longer."

Thank you for showing me the slightly longer solution   It's...

KH, exactly what you said:

"I want a select statement to return all dates between the DateFrom and DateTo".

I think I have to make a table pre-populated with all dates (from now...

Homebrew01, thank you for your extensive explanation.

Don't forget, I'am a newbe in the field of SQLServer (coming from another branch), so I'am very pleased with the way you explain...