if the number of transactions isn't too great.

SELECT StockTransactions.StockID

,ISNULL(Tran1.AvgAmount,0) AS AvgAmountforTransactionid1 ,ISNULL(Tran2.AvgAmount,0) AS AvgAmountforTransactionid2

from ( /*All distinct StockIDs to join*/

select distinct StockID

from test.dbo.StockTransactions StockTransactions

) StockTransactions

left join /*Calculate transaction 1 */

(SELECT...

Normally it is computername\administrator.

You can find a valid list of users in usermanagement in windows.

(Start->Settings->Control Panel->Users & Passwords)

Can you change the sql agent service account to the administrator account instead of NT AUTHORITY\SYSTEM? So far I know local system account has no rights on any networking stuff.

If you...

Starting the profiler and tracing for any delete / truncate table / drop table statements?

What sql server version are they running and what is their service pack?

It might be a bug that was resolved in sql server 2000 sp 3

more info:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;328569

you can use a left join / inner join

if

SELECT picks.name AS Name, Count(picks.name) AS [Days Picked], Avg(picks.gain) AS [Week 1 Avg Gain]

FROM picks

WHERE (((picks.entrydate)>=#1/3/2005#) AND ((picks.entrydate)<=#1/7/2005#))

GROUP BY picks.name

ORDER BY Avg(picks.gain)...

I have no experience with adp-projects.

But probable you need to restore /attach/recreate the TimeandBill, Robin databases on your sql server.

There is nothing in the book or on the cd that provides...

Varchar will only store the actual data removing trailing white space, conserving diskspace in the process.

see

http://support.microsoft.com/lifecycle/search/

for life cycle management of microsoft products.

General support for sql server 7 will end at the first of 2006.

General support site for sql server

http://www.microsoft.com/sql/support/default.mspx

1)What is Windows 2000 Compatible Access Group ?

2)Sql server version:

SELECT @@VERSION

or

xp_msver (see books on line)

what recovery model are you using (full, simple, bulk)?

Truncate table isn't logged

The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. It is almost...

This question has many answers.

The number of users mostly depends on your hardware/ quality of software.

A quick internet searching gives a try to compare sql server 2000 vs oracle 9

SELECT

 CF.FileId

 ,CF.Transid

From #UsFavs UF  WITH (NOLOCK INDEX=IDX_2)

   , Cus_file CF WITH (NOLOCK)

Where

        UF.Transid = CF.Transid

ORDER BY P.LastNm,P.FirstNm

I'm not familiar with NOLOCK clauses, but

Why...

In case you can store some profiles (either permanent or temporary) to store all the requirements

profile_qualifications:

profileid

qualificationid

required  /*required might be weighted like 0 or -1 (@MyconstantforRequired

) for required, >(=)0 for non-required*/

/*Variables :