quiesce

To quiesce is to put a computer, a program, a thread, or some other computer resource into a temporarily inactive or inhibited state. A resource...

Yes they are. Found an other article which does.

http://www.microsoft.com/sql/spotlight/expandsqlserver.asp 

Sorry but i do not see a developer version mentioned in this article. Are you sure this is the correct answer?

Hi Ben,

This is from Books OnLine:

The week (wk, ww) datepart reflects changes made to SET DATEFIRST. January 1 of any year defines the starting number for the week datepart,...

Hello Karen.

Maybe like this?

create table #table(field1 int, field2 int, field3 int, field4 int, field5 int, field6 int)

insert into #table values(0,0,1,0,3,9)

insert into #table values(0,1,1,0,3,9)

insert into #table values(0,0,0,1,3,9)

insert into #table values(0,0,0,0,1,9)

select

average =...

Hello Terry,

Try one of these.

EXEC sp_spaceused @updateusage = true

DBCC UPDATEUSAGE ('<databasename>')

create table #employee (emp_id int, salary int)

insert into #employee values(1, 24000)

insert into #employee values(2, 34000)

insert into #employee values(3, 54000)

insert into #employee values(6, 44000)

insert into #employee values(4, 44000)

insert into #employee values(5,...

Dharmendra,

Sorry, BOL is short for Books OnLine. The help files that come with your SQL server installation.

You can also have a look here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_0svo.asp

Hi Dharmendra,

Look at BOL.

CONTENTS =>

Installing SQL Server =>

Working with Instances and Versions of SQL Server =>

Running SQL Server 7.0 Along with a Named Instance of SQL Server 2000

Or simply drop the "SELECT" in

<= (select CASE WHEN DATEPART

Change it to

<=(CASE WHEN DATEPART

create Table #table (UserID int, ComplaintType varchar(10), CategoryDescript varchar(10), ClosedDateTime datetime, OpenedDateTime datetime)

declare @StartDate datetime, @EndDate datetime

SELECT

UserID,

ComplaintType,

COUNT(CategoryDescript) AS ClosedTot,

SUM(ClosedSevenDaysTot) AS ClosedSevenDaysTot

FROM

(

 SELECT

 UserID,

 ComplaintType,

 CategoryDescript,

 CASE

 WHEN DATEDIFF(DAY, ClosedDateTime, OpenedDateTime)

  <=

  CASE

  WHEN...

Hello /m

Maybe like this?

Create Table #tmpAgeGroups (NumberInAgeGroup int, AgeGroupName varchar(15))

Insert into #tmpAgeGroups (NumberInAgeGroup, AgeGroupName)

Values(102, 'youngsters')

Insert into #tmpAgeGroups (NumberInAgeGroup, AgeGroupName)

Values(504, 'middleaged')

Insert into #tmpAgeGroups (NumberInAgeGroup, AgeGroupName)

Values(706, 'retired')

Declare @LastGroup varchar(15)

Declare @sql...

Or this:

declare @year int

declare @month int

declare @day_of_week int

declare @nth_week int

declare @nth_day_of_month datetime

declare @first_of_month char(10)

declare @days_to_first_day int

declare @day_first_of_month int

--fill in the required vars

set @year = 2004

set @month = 8

set @day_of_week =...

I agree with SQLBill and his "you smell nice" post.

Please do not end the QOD’s.

Some people spell out the...

INSTEAD OFF is used to perfom another action.

Is there an other action you would like to perform?