Hi Gents,

I have definately seen this in these forums somewhere before.

All the best

Hi Eno,

Quick clarification.

Col a     Col b

2            2

2            4

5            9

Is this what you require?

CDO can be quite flaky at times.

Have you tried using Sequels own xp_sendmail instead?

e.g:

exec master.dbo.xp_stopmail

exec master.dbo.xp_startmail

exec master.dbo.xp_sendmail @recipients = @varRecipients, @copy_recipients = @varCopyTo, @message = @varMessage, @subject =...

Must admit - when I saw AKM's post, that is my intention now. To use EM to create scripts more often and see what its doing in the background.

One little...

Thats fair enough matey. No surprise really - As long as the job gets done and all that......

Would have expected a warning at least though.

SELECT     TOP 7 *

FROM         tblNames

WHERE     (PK > 10)

Have Fun

More Sequel wierdness.....

Had a quick look - If you try to run the code, sure enough you get the error.

Strangely enough, if you go into Entrprise manager, right click the...

Hi,

Just change the order in which you do things logically - make the column NOT NULL at its initial declaration before you create the index:-

create table test2(a integer NOT NULL,b...

Hi Max,

"You’ll notice that the Contract Field contains ‘N/A’ and the MNTRVU contains Nulls. So in the Where statements I’ve been using ‘WHERE MNTRVU>0 or MNTRVU>0 and Contract <> 'N/A'’ to...

Only slightly.

But the person posting the original thread hasn't come back with any form of reply - no feedback or answers to the questions raised.

So, it's only fair that...

Whenever you use exec, anything used or generated is only available during the lifetime of that exec as it generates a new spid to work in. It cant be accessed...

Sorry Frank,

The one out of the Bible........

Best regards

Hi All,

I would like to see a comparison with the original query, the optimised query and the query without the joins - if it isn't too much trouble.

Is there some...

Sorry to drop this in on you gents......

I only asked because I was asked to re-write a search query that had performance issues and when I changed it from the...

Seems to fit into this thread so, can anyone tell me why the INNER JOIN is preferred to creating the relationships in the WHERE clause e.g.

SELECT TOP 50 ACC.AccountID,AIN.AccountNumber, ATP.AccountTypeDesc, BOR.FullName,

BPH.PH1Phone,BPH.PH2Phone,BAD.ADD1Address1,BAD.ADD1Address2,

BAD.ADD1City,BAD.ADD1State,BAD.ADD1Postal,...