Viewing 15 posts - 571 through 585 (of 3,221 total)
SQLRNNR (3/13/2012)
Got any more like this Ron?
ONe more called VIEW 3 scheduled for the 20th of March and 2 more pending have been submitted .. waiting to be scheduled.
March 13, 2012 at 3:35 pm
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...
March 12, 2012 at 9:27 pm
Incorrect answers: 67% (2)
Total attempts: 3
What I thought was a nice straigt forward simple question, the results are discouraging in the number of incorrect...
March 12, 2012 at 9:14 pm
derek.colley (3/12/2012)
Thanks everyone, I'll see if BOL is included in the download.
If it is or is not come on back and post, it might be valuable for others to know
March 12, 2012 at 12:48 pm
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
March 12, 2012 at 9:47 am
lamiajoyee (3/11/2012)
yes i think im close to solving my problem.thank u all
And thank you for letting us know that in some way we assisted you.
And now a request for...
March 11, 2012 at 9:22 am
LutzM (3/11/2012)
One person can play different instruments in either the same band or in different bands (e.g. Bass guitar and Acoustic...
March 11, 2012 at 8:45 am
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...
March 11, 2012 at 8:12 am
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...
March 10, 2012 at 9:26 am
And thank you ... it is nice for everyone who assists others to know that they did some good ... either directly or indirectly
March 9, 2012 at 11:39 am
SQLRNNR (3/9/2012)
So OK let you have one of mine ...
Thanks for the laugh I need it and that...
March 9, 2012 at 10:55 am
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...
March 9, 2012 at 10:35 am
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)
,...
March 9, 2012 at 9:57 am
L' Eomot Inversé (3/9/2012)
Easy for me, as it was from Hugo's first comment that I first discovered that people could have named constraints (instead of letting...
March 9, 2012 at 5:49 am
Hugo Kornelis (3/9/2012)
I should have been warned. I even checked the code several...
March 9, 2012 at 5:21 am
Viewing 15 posts - 571 through 585 (of 3,221 total)