Shouldn't this work for you , It seems pretty straight forward

update TGT

set TGT.address=SRC.address

from ADDRESSES TGT

join AddressUpdates SRC

on TGT.id=SRC.id

where SRC.address like 'PO%'

update TGT

set TGT.address=SRC.address

from ADDRESSES TGT

join AddressUpdates SRC

on TGT.id=SRC.id

where SRC.address...

I cant believe I am saying this but how about remote backups :-

if hes ur boss he must come into office , and if he is on the same network...

Usually the archival policy applies to few highly transactional table within a database, most of the time they have a column which can be used to sequence the rows that...

CASE input_expression

WHEN when_expression THEN result_expression

[ ...n ]

[

...

What kind of actions are being performed by the package ? Would they actually need to be manually executed ?

Do have service accounts for the package ?

Elliott Whitlow (6/28/2011)

---

I don't see this as much of a...

Remote backups require configuration changes such as setting Trace flag 1807 , having accounts with the right privileges , solid network , etc.

A simpler approach would be to take the...

defaulting parameter is the same regardless of datatype

Were you facing any particular issue when you defaulted @b-2 to null ?

You could pass the list of file name as part of a record set and then use the for each loop container.

If your on a budget there is always the SSRS route , assuming you know which system tables to query

Backups create the backup file on the local disk of the server on which the backup is being performed. You would need to transfer to bak file over the n/w...

manning20 (6/28/2011)

---

No I am not using filestream. We have a Web page that inserts the image into the corresponding directory folder. Should I use filestream to sync images with...

I found the below article on the usage of greater than vs greater than or equal to

http://www.lcard.ru/~nail/sybase/perf/18295.htm

The logic seems sound but i doubt if i will consider it when...

http://www-03.ibm.com/ibm/history/exhibits/builders/builders_codd.html

The company is great because of the people working in it. For a giant like IBM to stay relevant after a 100 years is a big thing. Very few achieve...

or you could use the sql publisher wizard under

C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.4

SqlPubWiz.exe

its GUI which allows you to publish the procs directly to the target rather than script and...