Select dbo.OBTAIN_ID

or

Select * From dbo.OBTAIN_ID

if it returns a table.

Cheers,

Crispin

Frank, use an anonymizer

http://www.space.net.au/~thomas/quickbrowse.html

http://anon.luniac.com/

Of course, if the FW blocks them your are...

Cheers,

Crispin

Should mention:

Exec @vErr = sp_OAMethod @oHTTP, 'responseText', @vResponse OUTPUT

If the final param is supplied, sp_OAMethod returns the result to tis variable.

If not, it returns it as a record.

I find the...

You could also invoke the XMLHTTP object through SQL.

Using this, you write the retrieved source to SQL.

Set NoCount On



Declare

@vRootURLVarchar(100),

@vFileNamevarchar(20),

@vChannelIDInt,

@oHTTPInt,

@vErrInt,

@vDLengthInt,

@vCurLengthInt,

@vStartInt,

@vEndInt,

@vFinalURLVarchar(500)



Create Table #T(Data Text)

Create Table #T2(Ident Int Not...

quote:

---

My experience is that the case statement is slow when the optional parameter is NULL, I converted all my sp's to use...

I got one of the data captures to go report an ID Ten T (ID10T) error to sys admin.....

Cheers,

Crispin

After reading the article and BOL I found out that I am right. Only because someone told me about it...

Both are kept in temp and both...

SQL looks sp_ in the MasterDB cache and not actual SysObjects (Am I correct?)

SPXXX does not cause as cache miss so I assume that it does not check master first...

You can also use

Where

Col1 = @Param1

and (Col2 = @Param2 OR @Param2 Is Null)

and (Col3 = @Param3 OR @Param3 Is Null)

etc etc

When executing, Either Col2 will be = @Param2 or @Param2...

Hi Gunther,

When using mem tables with large amount of rows, I suspect that SQL starts dumping them to disk.

I tried the differences between the normal temp and mem tables.

With small...

Just arrived in South Africa

Cheers,

Crispin

Have to give Frank credit for this!

There was a URL to MS discussing it. Did caution on large tables.

Maybe Frank still has the URL.

Use PUBS

Go

select rank=count(*),...

Instead of using a double convert, why not just add a N infront.

eg:

Convert(Binary, N'below')

Not sure if this does a convert in the background (Might do) but if not, it does...

Access =

Is it really necessary for a NVarchar? Would a normal varchar not suffice?

Cheers,

Crispin

Converting it to binary and comparing that would also work on a string.

ASCII only retuyrns the first char's value.

Set NoCount On

Create Table #X(N Varchar(100))

Insert Into #X Values('Crispin')

Insert Into #X Values('crispin')

Insert...