ONe more called VIEW 3 scheduled for the 20th of March and 2 more pending have been submitted .. waiting to be scheduled.

My concern is having an application require SQL Server 2008 R2 and not having anywhere to put the database. I haven't run across anything with that requirement yet, but who...

What I thought was a nice straigt forward simple question, the results are discouraging in the number of incorrect...

If it is or is not come on back and post, it might be valuable for others to know

Do not know if BOL is included, but here is where you could download SQL Server 6.5, and see if BOL is included.

http://download.cnet.com/Microsoft-SQL-Server-6-5/3000-10254_4-19517.html

And thank you for letting us know that in some way we assisted you.

And now a request for...

LutzM (3/11/2012)

---

I wonder if the following scenario should be implemented, too:

One person can play different instruments in either the same band or in different bands (e.g. Bass guitar and Acoustic...

Here is something (rather simple) to start you off

We create two (2) tables, the first Bands to hold basic information on the band itself. Nothing about an individual member.

CREATE...

First of all let me say that you will most likely get a tested answer if you post your table definitions, sample data, and what you have attempted, following the...

And thank you ... it is nice for everyone who assists others to know that they did some good ... either directly or indirectly

SQLRNNR (3/9/2012)

---

That typo threw me way off. I want my point back.

So OK let you have one of mine ...

Thanks for the laugh I need it and that...

Here is one way of performing what I think you want. Now it is not the most efficient way, so if you have 100,000s of rows in your table...

Here is an idea for you

DECLARE @Date DATETIME

SET @Date = GETDATE()

WHILE @Date < '2013-01-01'

BEGIN

INSERT INTO CalDay

( DayDate, NextDay, DayNum, NameOfDay )

SELECT dateadd(day,datediff(day, 0,@Date),0)

,...

L' Eomot Inversé (3/9/2012)

---

Good straightforward question and answer.

Easy for me, as it was from Hugo's first comment that I first discovered that people could have named constraints (instead of letting...

Hugo Kornelis (3/9/2012)

---

I am embarassed to admit that I got this question, that apparently was based on my comments, wrong.

I should have been warned. I even checked the code several...