do it the same way you would do a select statement and get the values into one column:

...

SET address = b.address1 + " " + b.city + ", " +...

You can do this by joining in the UPDATE statement.  It's best to use an alias when doing this:

UPDATE a

SET columnname = b.columnname2

FROM tablename a

        JOIN tablename b ON a.key...

Lots of ways of doing this...

Off the top of my head, I'd probably create a "pending" transaction table something like:

req_id INT IDENTITY

,ticket_type --key info to tickets

,reserve_qty INT

,expire_date DATETIME

Then I'd...

I think AJ was implying that the task table would contain the the many to many relationship inherently: the key being projectid, taskid.

It is not clear if you are intending tasks...

You've hit the nail on the head with the most the fundamental solution in distributed data: data ownership (by site/database).  You're on the right track and you'll  be ok.

(So many...

It's all subjective and has *nothing* to do with the size of the database.  A datawarehouse is appropriate for a 1 meg DB if the data changes over time and...

It's not clear what you're really trying to accomplish, but this can do what you're asking:

select a.key1, a.id, COUNT( b.id )

from table1 a

     left outer join idlookuptable b ON a.id...

And so?

did you run sp_who when the process was "hanging" and see if it was blocked by another process?

Not all dead lock conditions are automatically detected by sqlserver and live...

one way is to use isnull:

select MAX( ISNULL( checkdate, '1/1/2050') ) ...

then use a case statement to translate that date literal back to a null.

if the table has indexes, the load is going to be logged and that portion of the log will not be truncated.

You can always do the crude and some would say klugy thing of a execsql step that says:

IF NOT EXISTS( select 1 from table where condition) RAISERROR...

and use the success path...

select * from tablename where transaction_date >= ( select MAX(modified_date) from whatevertablename)

The problem is with distributed transactions (DTC).  When you want to update a separate database within the context of a SQLServer transaction this thing (DTC) wants to manage it...

So...

The reality is that very, very many places will hire solely on the basis of paper certifications.  Yeah, experience is great, but if you want the quick way in, get those...

Do the CROSS JOIN as first reply but then simply filter one ID <= the other ID

This does permutations:

select a.id, b.id

  FROM sysobjects a

       JOIN sysobjects b ON 1=1

WHERE a.id...