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

40 years old
Poland
Male

My Sections

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

Leszek Gniadkowski's Home

My name is Leszek Gniadkowski.
  • Serial number generation in T-SQL

    Leszek Gniadkowski Commented 7 Months ago through Ask
    select *,row_number() over(order by Carrier,Truckno,Elg,Trip desc) TripNo from t...
    imrajesh
    1773 · 0% · 11
  • what are Difference between DATALENGTH and LEN?

    Leszek Gniadkowski Commented 1 Years ago through Blogs
    Some additional info from http://msdn.microsoft.com/en-us/library/ms143726.aspx The following table compares the behavior of some string functions and string operators when they use supplementary characters with and without a SC collation. With an...
    nirav.gandhi
    38 · 5% · 1567
  • UTF-16 to UTF-8

    Leszek Gniadkowski Posted 1 Years ago through Blogs
    Functions:gocreate function dbo.utf16_to_utf8 (@s varbinary(8000),@endian bit) returns varchar(8000) -- @endian 0-little 1-big null-BOMbegin if @s is null return null if @endian is null and not (convert(char(4),@s,2) = 'FEFF' or convert(char(4),@s...
  • Problem with query

    Leszek Gniadkowski Commented 1 Years ago through Ask
    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
    129 · 1% · 397
  • How the max(id) value differ based on Datatype

    Leszek Gniadkowski Commented 1 Years ago through Ask
    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
    105 · 2% · 503
  • How the max(id) value differ based on Datatype

    Leszek Gniadkowski Commented 1 Years ago through Ask
    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
    105 · 2% · 503
  • sql group

    Leszek Gniadkowski Commented 1 Years ago through Ask
    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
    350 · 0% · 117
  • sql server like

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

    Leszek Gniadkowski Commented 2 Years ago through Ask
    >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
    69 · 3% · 810
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.