ok i think i followed your logic; this was fun for me. made me think hard about how to get a calendar in 12 increments.

correct me if i'm wrong, but...

if the first query returns 6 rows, and the second returns 1, that is the results of the cartesian join we warned you about.

you have to determine what joins the...

you'll want to use the datediff function; but would you want a value in minutes if the difference was say 1823 minutes, or would you rather see 30 hours and...

can you connect with SSMS to the server 'targetsvrname' as the user sql2000login?

if the server was rebuilt, the login sql2000login might not exist and need to be re-added.

does this work? if your SQLs return just one line, this look good, otherwise it'd do a cartesian join unless you add a where statement.

SELECT

X.MemoryPages, X.MemoryAvailableMbytes, X.ProcessorTime, X.[DateTime], Y.MemoryPages_1

FROM

(

...

RP this is the syntax i've always used,a dn works without any problems for me:

here i'm connecting to a SQL instance named "DBSQL2K5", but for fun, I'm aliasing it as...

both Standard and Enterpise will only install on server versions of windows: 2000 Server/Advanced Server, 2003 Server, etc.

Express, Professional, Workgroup, etc versions will install on any Windows Operating system, as...

something like this might get you started.

for any given week, this returns the starting date of monday(@12am, the start of friday, and the last possible datetime of friday.

from there, you...

as others have pointed out, without a WHERE clause, you are updating every row.

here's an example, which uses the output clause, so you can see how to use it:

Create Table...

developer version is only a fifty dollar investment.

xp_cmdshell is the method that opens the door to operating system commands ; once granted you have access to do just about everything.

what you should do is create a...

that's easy.

there is no way to ENFORCE a relationship between two databases; Foreign keys,constraints,etc can only exist within a database. if you cannot use the built in fuinctionality of...

here you go: i had this saved in my SQL2000 snippets.

it produces results like this:

TableName IndexName ...

no; you can change the color of the text in the textbox, but not format PART of it's value, as far as i know.

you could put bold text before...

you can select the results of any calculation as a column in your query.

SELECT

COLUMNA ,

Modifier,

(COLUMNA * Modifier) As Result

from MyTable