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

Request Friendship



Upload Image

43 years old
Poland
Male

My Sections

0082 (Blogs)
Leszek Gniadkowski
8 · 18% · 5729

Leszek Gniadkowski - Ask

  • Serial number generation in T-SQL

    Leszek Gniadkowski Commented 3 Years ago through Ask | 10 Points
    select *,row_number() over(order by Carrier,Truckno,Elg,Trip desc) TripNo from t...
    imrajesh
    1808 · 0% · 11
  • Problem with query

    Leszek Gniadkowski Commented 4 Years ago through Ask | 10 Points
    code select dok,stawka,min(zid),max(zid) from (select *,zid - row_number() over(partition by dok,stawka order by zid) grp from @t) x group by dok,stawka,grp order by min(zid)...
    gogul
    132 · 1% · 397
  • How the max(id) value differ based on Datatype

    Leszek Gniadkowski Commented 4 Years ago through Ask | 10 Points
    Some hints: 1. From http://www.unicode.org/reports/tr10/ *Treatment of punctuation varies. In some situations a punctuation character is treated like a base letter. In other situations, it should be ignored if there are any base, accent, or case dif...
    ABHISHEKONLINE4ALL
    106 · 2% · 503
  • How the max(id) value differ based on Datatype

    Leszek Gniadkowski Commented 4 Years ago through Ask | 10 Points
    Unicode sorting ignores minus char in string - [http://www.unicode.org/reports/tr10/][1] CREATE TABLE #TBL(ID NVARCHAR(20)) GO INSERT INTO #TBL SELECT 'aaa----bbb1' UNION ALL SELECT '-----aaa-bbb2' GO SELECT MAX(ID)...
    ABHISHEKONLINE4ALL
    106 · 2% · 503
  • sql group

    Leszek Gniadkowski Commented 4 Years ago through Ask | 10 Points
    select e.Employeeid ,min(e.name) ,max(ei.Attemptdate) ,count(distinct datediff(d,0,ei.Attemptdate)) from Employee e inner join EmpIN ei on e.Employeeid = ei.Employeeid group by e.Employeeid...
    anuvarshini
    354 · 0% · 117
  • sql server like

    Leszek Gniadkowski Commented 5 Years ago through Ask | 10 Points
    like 'lee[^k]%' like 'lee[0-9]%'...
    ruboneswar
    1189 · 0% · 22
  • Best way to sort below mention condition

    Leszek Gniadkowski Commented 5 Years ago through Ask | 10 Points
    >But you still need to pad with zeroes to handle numbers with more than 1 digit. or convert to int / bigint - order by cast(reverse(parsename(reverse(c),1)) as bigint),cast......
    Alok Chandra Shahi
    70 · 3% · 810
  • Best way to sort below mention condition

    Leszek Gniadkowski Commented 5 Years ago through Ask | 10 Points
    @dishdy >Have you got something clever for ss 2005? :-) select c from cte cross apply ( select right(replicate('0',10) + x.i.value('.', 'varchar(8000)'),10) from (select cast(('

    ' + replace(c,'.','

    ') + '

    ') as x...
    Alok Chandra Shahi
    70 · 3% · 810
  • Best way to sort below mention condition

    Leszek Gniadkowski Commented 5 Years ago through Ask | 10 Points
    order by cast('/' + replace(x,'.','/' ) + '/' as hierarchyid) -- sql 2008 order by parsename(x,1),parsename(x,2),parsename(x,3),parsename(x,4) -- max 4 levels...
    Alok Chandra Shahi
    70 · 3% · 810
  • SQL Query

    Leszek Gniadkowski Commented 5 Years ago through Ask | 10 Points
    @abhIShek BandI - You're welcome @dishdy - It's a neat, but not universal (only for difference greater than 2)....
    ABHISHEKONLINE4ALL
    106 · 2% · 503
Previous 1 | 2 | 3 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.