David Burrows

Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 3,544 total)

RE: Import and export data

quote:
How long it takes to transfer 7GB. Are you deleting before import data, if so what happens if the job failed after...
Far away is close at hand in the images of elsewhere.
Anon.

November 25, 2003 at 8:22 am

#483547
RE: Bypassing Triggers

Good article, learn something new every day.
quote:
If we execute the following statement, what trigger(s) will fire and how many times will...
Far away is close at hand in the images of elsewhere.
Anon.

November 25, 2003 at 7:31 am

#483536
RE: return a subset from a query

If you are using an ADO recordset it has paging abilities.
Far away is close at hand in the images of elsewhere.
Anon.

November 25, 2003 at 5:48 am

#483522
RE: Import and export data

I agree with phillcart's postings, I transfer 7GB (46 tables) daily from a 3rd party database using ODBC and DTS is the fastest method. I create one DTS package per...
Far away is close at hand in the images of elsewhere.
Anon.

November 25, 2003 at 5:30 am

#483520
RE: Invalid column
Could use exec to insert column
```
exec ('alter TABLE #temptable add TEMPCOL int identity (1,1) NOT NULL ') 
```
but GRN's solution is better.
Far away is close at hand in the images of elsewhere.
Anon.
November 25, 2003 at 5:10 am

#483518
RE: Can't figure out recursion without dyanmic SQL
If table is as described and GROUP is sequential (no gaps) then you can use two temp tables as follows
```
DECLARE @group int,@max int 

SET @group...
```
Far away is close at hand in the images of elsewhere.
Anon.
November 24, 2003 at 6:45 am

#483329
RE: How to import a .sql file with DTS

quote:
Incorrect syntax near ' '.
Just remembered, isql gives this error for unicode files. Try...
Far away is close at hand in the images of elsewhere.
Anon.

November 21, 2003 at 6:44 am

#483072
RE: DTS Lookups - Type Mismatch error

quote:
many a mickel mucks a muckel sic!
It's one of those obscure scottish (and I'm...
Far away is close at hand in the images of elsewhere.
Anon.

November 21, 2003 at 6:38 am

#483070
RE: DTS Lookups - Type Mismatch error

Auch Mench, Frank.
Are you referring to the quote or the dialogue in the other thread?
Far away is close at hand in the images of elsewhere.
Anon.

November 21, 2003 at 6:25 am

#483068
RE: DTS Lookups - Type Mismatch error
Could be. DTSLookups will return empty variant if no data. To protect against error use
```
If IsEmpty(arrAddresses) Then

...

else

..

End If

 
```
Far away is close at hand in the images of elsewhere.
Anon.
November 21, 2003 at 6:02 am

#483055
RE: Running Query batches in stored procedure

quote:
At the end of the script, the original writer needed to return all column values except one.
Far away is close at hand in the images of elsewhere.
Anon.

November 20, 2003 at 7:54 am

#482863

RE: Get SQL Server Case Sencetive

sp_helpsort

 select (value & 0x1) from master.dbo.syscurconfigs where config = 1125

will return 1 if 'case insensitive'

Far away is close at hand in the images of elsewhere.
Anon.

November 20, 2003 at 7:02 am

#482848

RE: Running Query batches in stored procedure

Why do it?

What is it about the system that requires you to do it?

The proc can only be run once unless you are dropping and creating the table each time!!...

Far away is close at hand in the images of elsewhere.
Anon.

November 20, 2003 at 6:37 am

#482843

RE: Running Query batches in stored procedure

create proc customersproc as 

exec ('alter table customers add sname varchar(50)') 

exec ('select sname from customers') 

go

Works but would not advocate it.

Far away is close at hand in the images of elsewhere.
Anon.

November 20, 2003 at 6:23 am

#482839

RE: How to import a .sql file with DTS

The script is executing but

quote:
1> 2> Msg 170, Level 15, State 1, Server CEDE, Line 1

Far away is close at hand in the images of elsewhere.
Anon.

November 19, 2003 at 8:07 am

#482653

Viewing 15 posts - 2,911 through 2,925 (of 3,544 total)