Do you want the #inbound #outbound calls to be cumulative? Can you give us an example results set?

- James

Not sure if its a better idea or not but you could also group by direction,

SELECT sum/count etc FROM phonelog GROUP BY direction;

EDIT: *cough* this wont work if you want...

Hi there,

somthing along the lines of the folowing should work:

SELECT a.ID, a.Year, a.Level, a.m_l - c.m_l [value_left_in_course]

FROM

academic a

LEFT JOIN

(SELECT SUM(m_l) [m_l] FROM course GROUP BY ID) b

ON a.ID =...

Hi Dan,

I would probably go down the root of DTSing out the information to Excel (http://support.microsoft.com/kb/319951) however your reformatting sounds slightly more fun to do, probably the easiest thing...

Is the SQL Agent service running? You can check this from the service controller shipped with SQL 2000 or through EM/SSMS.

- James

Steve,

Congratulations on the successful migration. Dan H seems to be a lot calmer and has started smiling again

- James

Hi Raman,

Brad has a nice explaination of Log Shipping over on SQL Server Performance: http://www.sql-server-performance.com/sql_server_log_shipping.asp - Several 3rd party backup tools will also help you with this, for example Red Gate's...

Hi David,

One way to do this is to do a left join and then check for null on the right handle columns, for example

SELECT Table1.* FROM

Table1

LEFT JOIN

Table2

ON Table1.ID =...

Hi there,

You might want to take a look at the (undocumented) stored procedure sp_MSforeachtable: http://www.sqlservercentral.com/columnists/bknight/sp_msforeachtable.asp 

Somthing like:

USE database;

GO

EXECUTE sp_msforeachtable 'EXECUTE sp_help ''?'''

- James

Hi Ramandeep,

You probably want to look into log shipping or some form of replication depending on your needs. Have a look in BOL.

- James

Hi there,

sp_start_job should do the trick for you..

somthing like:

EXECUTE msdb..sp_start_job @job_name='job1'

or

EXECUTE

msdb..

Hi there,

You can do this with DateAdd/DateDiff.. somthing like:

CREATE PROCEDURE sp_GetPreviousFriday

 @date DATETIME,

 @lastFriday DATETIME OUT

AS

 DECLARE @rootDate DATETIME;

 DECLARE @dayOfWeek INT;

 SET @rootDate = CAST('1990/01/05' as Datetime)

 SELECT @dayOfWeek = DATEPART(weekday, @date)

 print @dayOfWeek

 IF(@dayOfWeek < 6)

 BEGIN

  SELECT...

Hi Garry,

Red Gate has several tools which will help you with this - SQL Doc  will generate documentation for you database including dependency information. SQL Dependency Tracker has...

Hi,

Is the SQL Browser service running on that machine? Could anything be blocking UDP port 1433 as this is the default port SQL Browser uses to report on what versions...

Hi,

What is happening in the database between those times? Have you got any jobs scheduled between those times? Are your maintenance plans rebuilding your indexes/updating your statistics?

It might be worth...