Control-of-Flow Language is the section that refers to the Case statement.

And yes I know that GOTO is messy but I don't think there is another way around it in this...

Yes, Yes, Yes. 

I want my default to be grid and then through a command change it to text.

Steve

Yeah  I was looking for a program command like a SET command.

It is a select with a sum and group by. 

Tools-> Options are set to 4, 0, 0

'right click on the server name, select properties, tab connection, in the second square exist...

Why did you add % 60?  Second answer seems to work as expected.

Happy New Year!

Steve

Riddle me this batman...

(and no I'm not the orginator of this discussion)

What if you want the number of Seconds since some time period?

Let say you want to know the number...

Why do you want to do this?  What are the requirements?

Here is a fun "Select"

SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())   

Perhaps this was too complicated.  But I have created a fun APOST to add a second Apost to any string.

So O'Brien

is returned

O''Brien

Here is the code

Function funApost(X) As String

On Error GoTo...

Back to the original comment...

What if the database is receiving 300  committed transactions per second?  What if its 60K per second?

People having a large volume of transactions beleive that many...

Well we had a report from a Microsoft Conference that the number of files for transaction logs should match the number of processors on the server, thus preventing I/O contention...

Great Suggestion!

Here is the original and another method.

It works from 1743 to 9998

Steve

Declare @Year_Begin as int, @Year_End as int,

      @IndependeceDay as char(10), @DayofWeek as char(10)

If...

BOL states

The ListAvailableSQLServers method returns a NameList object that enumerates network-visible instances of Microsoft® SQL Server™ 2000.

Wouldn't that make "A" the correct answer?

Here is my final SQL query that I used to get this information.

DECLARE @olddatabasename as sysname,@backuppath as NVARCHAR(4000)

SELECT @backuppath = MAX([physical_device_name]) FROM [msdb].[dbo].[backupmediafamily]

WHERE  [physical_device_name] like '%' + @olddatabasename + '%'...

Thanks Peter, but it only has the .mdf and .ldf files not the location of the .BAK.

Still looking,

Steve