Viewing 15 posts - 24,706 through 24,720 (of 26,490 total)
Curious, looking at your code, are you running SQL 2005 or SQL 2000?
😎
June 5, 2008 at 9:38 am
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...
June 5, 2008 at 9:28 am
ORDER BY in a cursor works. Copy my code and test it.
😎
June 5, 2008 at 9:23 am
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...
June 5, 2008 at 9:16 am
Try this:
DECLARE @DB varchar(25)
DECLARE DBCursor CURSOR FOR
SELECT [name]
FROM master.sys.databases
...
June 5, 2008 at 9:12 am
What constitutes an ADD? For an existing ID, is the field blank (or null) if there is no entry?
😎
June 5, 2008 at 9:07 am
Could you provide the DDL for the two tables involved?
😎
June 5, 2008 at 9:05 am
Could you explain this in a little more detail?
Due to scoping restrictions, I am not able to perform a "select * into #temp from sourcetable".
😎
June 5, 2008 at 8:51 am
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
...
June 5, 2008 at 8:43 am
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...
June 5, 2008 at 8:38 am
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...
May 29, 2008 at 10:54 pm
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!!...
May 29, 2008 at 5:40 pm
You may want to run DBCC CHECKDB on the database.
😎
May 28, 2008 at 9:46 pm
Can you run a full backup manually using SSMS?
😎
May 28, 2008 at 9:06 pm
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...
May 28, 2008 at 8:52 pm
Viewing 15 posts - 24,706 through 24,720 (of 26,490 total)