In my submission using SQL pivot, you could replace the first occurrence of denominator with

case when Denominator = 0 then 1 else Denominator end

to handle cases where you have set...

My wife is a teacher. Try this

Select sID,

ClassWork, Homework, Quiz, Test,

cast(round(((Cwt + Hwt + Qwt + TWt) / Denominator), 0) as int) as Average

from

(Select sID,

Classwork, Homework,...

Hey, Danny ... great question.

Check out

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=852573&SiteID=1

Your command should look like this:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME="MyInstance" UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

I haven't seen that "UPGRADE=" parameter in the online help. You...

How about something like...

create procedure dbo.CreateTable

(

@TemplateTable varchar(50),

@NewTable varchar(50),

@primarykey-2 varchar(50)

@FileGroup varchar(50)

)

as

declare @SQLCmd as varchar(8000)

Set @SqlCmd = 'SELECT * INTO ' + @NewTable + ' FROM ' + @TemplateTable +...

In database properties under options, check the setting for Auto Close. The default for 2000 and 2005 is false, BUT upgrading DB compatibility from 2000 to 2005 ("EXEC SP_DBCMPTLEVEL Ensite,...