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.
Request Friendship



Upload Image

43 years old
Poland
Male

My Sections

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

Leszek Gniadkowski's Home

My name is Leszek Gniadkowski.
  • Best way to sort below mention condition

    Leszek Gniadkowski Commented 5 Years ago through Ask
    @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(('<p>' + replace(c,'.','</p><p>') + '</p>') as x...
    Alok Chandra Shahi
    70 · 3% · 810
  • Best way to sort below mention condition

    Leszek Gniadkowski Commented 5 Years ago through Ask
    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
    @abhIShek BandI - You're welcome @dishdy - It's a neat, but not universal (only for difference greater than 2)....
    ABHISHEKONLINE4ALL
    106 · 2% · 503
  • SQL Query

    Leszek Gniadkowski Commented 5 Years ago through Ask
    code: ;with cte1 as ( select * ,row_number() over(order by NUMBER) rn from #temp t1 ) ,cte2 as ( select c1.NUMBER - c1.rn x ,min(c1.NUMBER) minn ,max(c1.NUMBER) maxn ...
    ABHISHEKONLINE4ALL
    106 · 2% · 503
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.