Curious, looking at your code, are you running SQL 2005 or SQL 2000?

😎

Okay, I'm confused about what you are really trying to do. Please provide the DDL of the tables, some sample data (in the form of insert statements), and the...

ORDER BY in a cursor works. Copy my code and test it.

😎

You haven't completely answered my question. In both ID 1 and ID 2, you have a field that is blank. If that field is NOT blank the next...

Try this:

DECLARE @DB varchar(25)

DECLARE DBCursor CURSOR FOR

SELECT [name]

FROM master.sys.databases

...

What constitutes an ADD? For an existing ID, is the field blank (or null) if there is no entry?

😎

Could you provide the DDL for the two tables involved?

😎

Could you explain this in a little more detail?

😎

Here is the code using dynamic sql:

use [MyDatabase]

go

declare @T sysname,

@SQLCmd nvarchar(max)

set @T = 'second_db.dbo.more_records'

set @SQLCmd =

'update dbo.addresslist set

...

First, to do it the way you are trying, you need to use dynamic sql. I haven't written it that way yet, but based on your posted code I...

So far I have only done this once, but on one request for help after a few back and forth posts by several people (I seem to remember at least...

NE huh. Welcome to my stomping grounds. If after you drive in and out of the state, you have any questions about oh, say....corn. Let me know!!...

You may want to run DBCC CHECKDB on the database.

😎

Can you run a full backup manually using SSMS?

😎

As it looks like you are using SQL Server 2000, I'd use DTS packages to import the data from the two tables. Of course, you have only provided partial...