Actually I have already some of those brainteasers in my pocket.

But they are, of course, closely related to my profession and I am uneasy if financial mathematics is that interesting...

Curious how long this list is

Sorry, couldn't resist.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I know, I know. Don't hang out the window too far or what do you say?

You need help?

Well, here I am! And I'm sure there are other members who...

AAAAA: American Association Against Acronym Abuse

or

WYSIWYMGIYRRLAAGW: What You See Is What You Might Get If You're Really Really Lucky And All Goes Well

or

MICROSOFT: Most Intelligent Customers...

Hey, did I ever mention that I hold a certification, too??

Not?

Well, actually I am a MCM

Microsoft Certified Mouser

Frank

http://www.insidesql.de

http://www.familienzirkus.de

If you find someone, send a headhunter to contact him?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Oh, a typo! I was already searching...

Frank

http://www.insidesql.de

http://www.familienzirkus.de

It's a classical dilemma I know. You must apply some filter, otherwise you can't handle it. And even if you are in danger to miss a brilliant candidate without formal...

Sorry, my conclusion was missing

I don't give anybody credit per se just because of some might be credentials.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

What is ASAIK?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I think with an sufficient amount of spent time on learning and a certain amount of cleverness, you can get both a university degree and whatever certification you want.

Does...

Could it be you guys posting this in yesterday's QOD thread?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Actually it IS a fake table

Try this

SELECT 

OBJECTPROPERTY(OBJECT_ID('sysprocesses'),'TableIsFake'), 

OBJECTPROPERTY(OBJECT_ID('syslockinfo'),'TableIsFake'),

OBJECTPROPERTY(OBJECT_ID('sysperfinfo'),'TableIsFake'),

OBJECTPROPERTY(OBJECT_ID('syscolumns'),'TableIsFake')



                 ...

Not really!

In almost any case due to several reasons sooner or later there will be gaps in the identity sequence.

CREATE TABLE MyIdentity(

id INT IDENTITY(1,1) NOT NULL,

some_other...

Continuing to clean up my archive..

Anything new on this?

Frank

http://www.insidesql.de

http://www.familienzirkus.de