Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

San Francisco
Male

My Sections

Leonid's Blog (Blogs)

My Activities

Blogs20
Pages1
Ask55
Puzzles135
Just Learned6
Leonid Koyfman
50 · 4% · 1183

Leonid Koyfman's Home

My name is Leonid Koyfman. I live in SAN FRANCISCO, USA. I work as DBA at AKQA.
  • RAND function - reset values for each group

    Leonid Koyfman Commented 4 Years ago through Blogs
    @ Madhivanan Thank you for this post. Learnt something new. I didn' t expect T-SQL Rand() takes parameter.(in other implementations(e.g. in Excel )it doesn't) @Imran rand()*number is not the same as rand(number). It gives the same numbers per g...
    Madhivanan JR
    2 · 40% · 13039
  • SSIS Expression for appending Datetime to the file

    Leonid Koyfman Commented 4 Years ago through Blogs
    Hi Divya, Why don't you build needed Date and Time string in T-SQL when you Execute SqL Task ? Thanks. Leonid...
    Divya
    89 · 2% · 629
  • Getting correct MAX version

    Leonid Koyfman Commented 5 Years ago through Blogs
    @Divya, If PARSENAME() function is sufficient to tokenize your version pattern(less than 5 tokens) you can sort your column with versions by each token from left to right in descending order and pick the topmost value: DECLARE @Versio...
    Divya
    89 · 2% · 629
  • Modulus operator in SQL Server

    Leonid Koyfman Commented 5 Years ago through Blogs
    Often overlooked useful application of the modulus operator is extracting a fractional part of the decimal number. For a number Num it will be Num%1....
    Madhivanan JR
    2 · 40% · 13039
  • Find last non-zero digits in a Number

    Leonid Koyfman Commented 5 Years ago through Blogs
    @dishdy ... and apostrophes around 0. select 1*right(replace(num,0,space(20)),20)from @t I believe that's it. BTW. I learnt about space before 'from' from Madhivanan....
    Madhivanan JR
    2 · 40% · 13039
  • Find last non-zero digits in a Number

    Leonid Koyfman Commented 5 Years ago through Blogs
    @dishdy, you challenged me. I'm not a big proponent of implicit conversion, but measured in charachters this one is shorter: select 1*(right(replace(num,'0',space(20)),20))from @t...
    Madhivanan JR
    2 · 40% · 13039
  • Find last non-zero digits in a Number

    Leonid Koyfman Commented 5 Years ago through Blogs
    I'd use the following: select ltrim(right(replace(num,'0',space(20)),20)) from @t It doesnt have to be 20 spaces. At most len(num)....
    Madhivanan JR
    2 · 40% · 13039
  • beyondrelational.com

    Leonid Koyfman Liked 5 Years ago through Pages
    We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
    Jacob Sebastian
    1 · 100% · 32235
  • openrowser sql server 2000 data to dbf file

    IvanFroilan Question Received 5 Years ago through ASK
    Hi, I want to insert sql server 2000 data into dbf file insert into openrowset ( 'Microsoft.Jet.OLEDB.4.0', 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;', 'Select * from [item.DBF]') select * from itemfact ...
    leonidk
    50 · 4% · 1183
Previous 1 | 2 | 3 | 4 | 5 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.