Leonid's Blog - All Comments

re: Solution for Challenge #4

Leonid Koyfman — Thu, 14 May 2009 18:00:27 GMT

Hi Cleber,

Thank you for the tip about "*".

I didn't know it would work.

Thanks to this site we all can learn something new.

Using "*" reminded me about other, more practical trick I'd like to share.

Instead of "count(*)" in queries I use "count(9)".

It doesn't have to be "9", just any digit.

But it's easier to type "9" because "(" and "9" are on the same key.

It works in ORACLE as well.

-LK-

TSQL Challenge 5 - Solution by Leonid Koyfman

TSQL Challenges — Tue, 12 May 2009 08:24:38 GMT

There were a lot of different solutions for this challenge but globaly the key point to release the split

re: Solution for Challenge #4

Cleber — Tue, 12 May 2009 03:23:58 GMT

Hi Leonid, I saw about this site on Pinal's blog (thanks Pinal, as I said, lot of good stuff on yours...) Well, this is my first comment but you will see me around, back to business, two extra bytes to save on the shortest solution you got, the "*" doesn't need spaces around it. Thanks for spending time helping us, the cusious amateurs, to understand it better.

-Cleber

re: Solution for challenge #5

Ashish Gilhotra — Mon, 11 May 2009 11:57:01 GMT

Thanks..

your solution is always up to mark...

i like the way from which you compare or match the things in your Queries..

there is lots of things which we learn from you..

Thanks...

re: Blog Inaugural Post

Antoine Gémis — Sun, 10 May 2009 10:56:00 GMT

Hi Leonid !

I'm eager too to read your posts.

re: Blog Inaugural Post

Rui Carvalho — Sat, 09 May 2009 10:08:34 GMT

Welcome Leonid!

it will be great to read your future posts.

re: Blog Inaugural Post

Pinal Dave — Sat, 09 May 2009 02:47:01 GMT

Welcome Leonid,

Eager to read your future blogs.

Regards,

Pinal