You mean - something like this?

update emp

set empname='Bob Smoot',

EmpTitle='Emperor',

Emprole='Master Bottle Washer inspector'

where

...

Or - you could skip SSIS, and use a customized tool to do just what you're after: the SQL Server Migration Assistant for Access. It should transfer quite a...

If you want to see some REALLY interesting things...

Grant Fritchey (5/21/2008)

---

Ah, partition by... crud. I was bouncing all around it and I just couldn't figure it out. That looks great. I tested it against the single row and...

hmm... never mind earlier comment. I think this one's a little better anyway.

SELECT d.[DocumentName],

d.[DocumentId],

...

Hmm...Trying to work this one out.

The first one (in the CROSS APPLY), returns the Highest version of a given document in the VERSION TABLE.

The second one seems to be taking...

Keep in mind that your choice of clustered index will have a LOT of bearing on how quickly a table will fragment.

Remember that the clustered index dictates the...

The use of functions against column values in the WHERE clause tends to force the optimizer to have to use index SCANS instead of SEEKS, since the function has to...

GSquared (5/21/2008)

---

The reason for this is that, in a Left Outer Join, any criteria on the left table need to be in the Join clause, or they make it into...

#2 is a bad idea all around.

Shrinking a file that's going to grow again only encourage fragmentation. If you just leave it alone - it will grow to the...

There's NO scenario in SQL server with NO logging. As a matter of course (and as part of the definition of an RDBMS), activity is logged in a way...

crever (5/21/2008)

---

There's no reason why upgrading your clients would effect the domain controller, so AD will remain in tact.

I've recently upgraded to vista too, and the only issue...

I've actually started to notice this. I'm in the market right now, but having been a "jack of all trades" forever, I'm apparently a bit of a challenge for...

OH you've...

If you're talking about accessing data from the base table not used in the insert...unfortunately - you have to relink to it somehow.