Matt Miller (12/8/2007)

GilaMonster (12/8/2007)

An index on a column does not guarantee that data will be returned in that order. Unless an order by is specified, you cannot be sure that...

Index

You need to aggreage the hours for each game,

SELECTCOALESCE( a.date, b.date ) AS Date,

COALESCE( a.game_id, b.game_id ) AS GameID,

COALESCE( a.level_id, b.level_id ) AS LevelID,

COALESCE( a.location_id, b.location_id ) AS LocationID,

SUM( COALESCE(...

It does at every workstation in my office!!!! I have to manually de-select the option.:D

Obviously, the "special" UPDATE relies purely on the guaranteed ordering of the rows to work, which I should have been mentioned earlier.

All of our applications, have a guaranteed...

Merry Christmas!!!!

Likewise all others, I don't have anything to ask for except the fact that, please, please, someone could shift me to some other project than what I'm currently working...

Nice Article Jeff!!!

Looking forward to Part 2, 3 & 4....:D

Before 2K5, many a times, we used the following methodology in our financial applications to get the running count for records....

You missed the ON clause....

CREATE DATABASE nwdata...

Ooops, an additional quote!!!!

Edited my previous post:

You could also do a TRUNCATE if possible.

DECLARE @dtStartDate DATETIME,

@dtEndDate DATETIME

SET @dtStartDate = CONVERT( DATETIME, CONVERT( VARCHAR(10), GETDATE(), 112 ) )

SET @dtEndDate = DATEADD( DAY, 1, @dtStartDate )

SELECTTOP 10 ID

FROMT1

WHERE[Date] >= @dtStartDate AND [Date] < @dtEndDate

AND [Gross...

You could also use the newer version for attaching database (as sp_attach_single_file_db is deprecated in SQL Server 2005)

CREATE DATABASE SomeDB

ON (FILENAME = 'c:\data\SomeDB.mdf')

FOR ATTACH

I doubt, I could understand your query well enough to answer. It would be better if you can provide a sample script with table structures, sample data and the...

You could find a lot of scripts here to get information about the server & database configurations. Just search for "Server Information" at the top-right of this page. ...

Oops.., You are correct. I could have read your post correctly before replying. Any hows, I'll check for some other resources and will let you if I could...