insert into people_request(org_code, email)

select pa.org_code, p.email

from people p

inner join people_assignment pa

on p.id= pa.id

left outer join people_request pr

on p.email = pr.email

and pa.org_code = pr.org_code

where pr.key_id...

You can install alongside. I just finished doing exactly that.

The learning curve is pretty shallow from 2005 to 2008.

I'm pretty sure it's not, but the way to find out for sure is contact Microsoft about it.

I don't have 2000, but I have 2 instances of 2005 on my desktop machine. I just finished installing an instance of 2008 on the same computer. I...

You probably can, but why not install 2008 and run the databases in compatibility 90 if you really need to do that?

You'd have to check with Microsoft to be certain,...

You're welcome.

Management Studio 2008 can't use it's debugging features on SQL 2005/2000.

I just installed a trial copy of 2008 today. Tested both Intellisense and debugging on 2008 and then on...

That datediff calculation is using the 15 Aug start date for all of it's calculations. Thus, it adds the days for each month to the total for the prior...

andrew gothard (8/15/2008)

Sorry - totally disagree. Give me one good...

It will affect inserts, but how much will depend on a couple of things, including how often you defragment the clustered index, how you set the fill factor on the...

Here's the script I use for testing upgrade from 80 to 90.

use [database] -- Please remember to fill this in!!

go

dbcc UPDATEUSAGE (0) WITH NO_INFOMSGS;

go

DBCC CHECKDB (0) with no_infomsgs;

go

-- Update...

Nope, it can't do that.

The way to move data from one filegroup to another is to rebuild clustered indexes and designate the file group you want the index in. That moves the table...

Not sure what you mean by a batch file. Most .BAT files (which is what I think of when I think of a batch file), operate mostly without human...

Have you tried just typing "(local)" in to the server name box? As opposed to browsing, I mean.