If it's ##temptable it won't go out of scope, but the example said #temptable, then it will.

One letter can make all the difference

/Kenneth

Something weird happened with last post, so I repost:

Jeff,

it works fine up to the part when 'double barreled' names comes up.

 select '''Smith Johnsson'' John Mr'

 select '''Smythe Johnsson'' John'

We...

You have to create the temptable in the outer proc (A)

then you can call proc, have it insert into the temptable, return, and then you select from it again in...

Well, can't really see that there would be any difference from the optimizer's point of view, since it deals primarily with finding the data, not how to display what it...

Try both and compare the plans.

My guess is that there is no measurable difference.

/Kenneth

You're not allowed to do DML (like the insert) inside scalar functions.

/Kenneth

Assuming that the column holding your dates is a datetime datatype, you can convert it to a string and use a style parameter.

SELECT CONVERT(CHAR(8), myDateColumn, 112) FROM ....

..will probably do...

Well, it's not a black or white issue, bcp has it's good apsects, as does bulk insert - they are two ways of quickly loading files. Which to use is...

Could you post your bcp commandline?

If you're running locally, try to leave out the -S server parameter. (if you've not done so already)

In the 'old days' this was a trick...

SELECT col1 AS 'A', col1 AS 'B'

FROM myTable

The clientside will refer to the columns as 'A' and 'B'.

/Kenneth

Codepage 862 seems to be Hebrew (DOS).

Is this what the file contains?

Perhaps you need to install support for Hebrew in order to load the file successfully..?

/Kenneth

Try this experiment.

Switch the servername for the actual IP address of the server in the bcp commandline.

If time improves, you're probably having a nameresolution issue.

/Kenneth

Talk to the mailserver guys and ask them to make what need be so your server will be able to send mails through that server. (I assume it's like setting...

Could be a DNS resolution problem for you Vladan.

I use a fully qualified FQDN 'server.abc.def.se', and it works with no problems.

Though I must confess I don't quite know what the...

Ah, you're correct. It doesn't support a @query parameter like xp_sendmail does. However.....

if the result of the query is placed in a file on disk, you could then attach it...