sp_changedbowner

Answer#3 check if a string STARTS with a char in [0-9][A-Z]

2 is not good because fails on combination of letters and numbers

4 check against 1 char

1 is correct

SET DATEFORMAT 'dmy'

SET NOCOUNT ON

create table #tblOperations(Date Datetime,Funds int,SubScriber int, Parts int)

insert into #tblOperations VALUES('10/1/2005', 1, 100, 10)

insert into #tblOperations VALUES('15/1/2005', 1, 200, 30)

insert into #tblOperations VALUES('20/1/2005', 1, 100, 40)

insert...

SET DATEFORMAT 'dmy'

SET NOCOUNT ON

create table #tblOperations(Date Datetime,Funds int,SubScriber int, Parts int)

insert into #tblOperations VALUES('10/1/2005', 1, 100, 10)

insert into #tblOperations VALUES('15/1/2005', 1, 200, 30)

insert into #tblOperations VALUES('20/1/2005', 1, 100, 40)

insert...

"A previous post says that dates make good indexes. I tend to disagree."

Hmm I couldn't believe either so I analyzed Remi's code which came to agree with that.

I...

Or if you use the same server but different DBs try using full names

INSERT INTO DB1Name.dbo.MyTable1

SELECT * FROM DB2Name.dbo.MyTable2

WHERE ....

It seems like you actually want to move data from 1 db to another ... (I might be wrong)

You can try to use :

BCP to export/import data

Linked Servers

You need to try to separate the cause:

--the returned time is big because of the "time to get connection to SQL server"

or

--the retuned time is big because of the...

SP_MAKEWEBTASK might help you ...

you can pass as the output file a UNC path that resize on the needed server ( you need permissions for the server account to write...

Try to open the file with notepad for ex and replace the "" with a single " or empty space if you don't need them to be imported

Actually in real code I m returning more than 1 value.

But like it happens ... something changed and the code suddenly works ... I can't figure out what it is

before...

sp_MakeWebTask might be a better solution for you than retrieve the recordset to VB and generate the file

{call ?=myproc ?}

this is if you want the result of sp

"{call myproc ?}"

? param that you have to pass

You can make a view and transform in view each field to CHAR

select 

c_code,

c_type,

c_perio,

CAST(LTRIM(STR(c_prd_yr int)) as CHAR(4)) ,

CAST(LTRIM(STR(c_prd_mon)) as CHAR(2)) ,

.....

)

or make 1 field by adding them in DB