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

this is just a guess, where i'm trying to reduce the rows in the join by using a sub select;

does this produce results that are close to what you want?

SELECT...

well, if there was only one in the "p" table for shift 3, the issue is your joins are bringing in 4 more rows, right? i would guess the other...

well the SQL looks right, so it's gotta be the data not meeting your expectations.

i would expect the SQL below to show you that there really is 4 items in...

i believe by single developer, it is single installation. they do not want you to buy one copy and install it on 20 developers machines. 20 installations would require 20...

if your table t1 already has those values, you should be able to use the integer modulus to determine/select only those values that are perfectly divisible by 100; then do...

easily bob;

if the table exists, or if you create a staging table, there's no porblem; you want to use BULK INSERT command to do it. your example seemed to be...

when you run the profiler, does the spid in the loop change, or is it incrementing?

if it was incrementing, that would imply to me that it is getting new connections.

if...