Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,114 total)

  • RE: Add " + " to add column values dynamically

    I think there was some problem while posting the thread. I have received some error message like

    "contact board administrator". Thats why some threads are repeating more number of times in...

    July 9, 2009 at 4:29 am

    #1022247

  • RE: Add " + " to add column values dynamically

    any idea about my requirement #2.

    July 9, 2009 at 4:27 am

    #1022246

  • RE: Add " + " to add column values dynamically

    any idea about my requirement #2.

    July 9, 2009 at 4:27 am

    #1022245

  • RE: Finding longest period where dates are consecutive

    I followed Dave blog and wrote this query.

    #1)

    create table Contig(Id integer)

    go

    insert into contig values(1)

    insert into contig values(2)

    insert into contig values(3)

    insert into contig values(5)

    insert into contig values(6)

    insert into contig values(7)

    insert...

    July 2, 2009 at 3:42 am

    #1018997

  • RE: arithabort error when queying a view

    Please post the code.

    June 16, 2009 at 3:50 am

    #1010080

  • RE: O(n) , O(n log n), O(n^2)

    Now I understood your point #2 and #3. But still #1 is not clear for me...

    {(n)*(n+1)/2} cost of the naive implementation to {n +(n)*(n-1)/(2*k)}

    Again, if you could explain your...

    June 9, 2009 at 3:03 pm

    #1007077

  • RE: O(n) , O(n log n), O(n^2)

    RBarryYoung (6/8/2009)

    karthikeyan (6/8/2009)

    4) What LHS (Left-hand side) function denotes exactly?

    Left-hand Functions appear left of the assignment operator ("="):

    Set @str = UPPER('Some text.')

    These are normal functions, and AFAIK, in T-SQL,...

    June 9, 2009 at 1:54 pm

    #1007032

  • RE: O(n) , O(n log n), O(n^2)

    Declare @str varchar(5)

    select @str = ''

    select @str = @str + no from mystring

    step 1: '' + '1'

    step 2: '1' + '2'

    step 3: '12' + '3'

    step 4: '123' + '4'

    step 5:...

    June 9, 2009 at 1:27 pm

    #1007019

  • RE: O(n) , O(n log n), O(n^2)

    Gail,

    i expected this question from you. Since i studied these concepts just to pass the exams, beacuse that time i don't know the real time usage and it will be...

    June 9, 2009 at 4:31 am

    #1006568

  • RE: O(n) , O(n log n), O(n^2)

    RBarryYoung (6/8/2009)

    karthikeyan (6/8/2009)

    1) What is mean by pseudo cursor?

    Pusedocursor is a name that some people (including me) use for the SQL Server (and Sybase too, I believe) trick of being...

    June 9, 2009 at 4:24 am

    #1006565

  • RE: O(n) , O(n log n), O(n^2)

    1) SQL Server apparently (based on my tests) already does the "buffer-extension" trick available to mutable strings. Unfortunately, the Extension trick does NOT solve the O(n^2) problem,

    If it...

    June 9, 2009 at 4:22 am

    #1006563

  • RE: O(n) , O(n log n), O(n^2)

    RBarryYoung (6/8/2009)

    karthikeyan (6/8/2009)

    They used some concepts which i couldn't understand.

    1) O(n) means ?

    2) O(n^2) means ?

    3) O(n log n) means ?

    4) What is mean naive linear string concatenation?

    For (1-3),...

    June 9, 2009 at 4:12 am

    #1006557

  • RE: O(n) , O(n log n), O(n^2)

    Yes Gail...I have studied...But i don't remember the functionality...

    I have reviewed the above mentioed URL, Since there are lot of formula's are there,it is confusing...

    If you or anybody gave the...

    June 8, 2009 at 7:07 am

    #1006049

  • RE: Query to get the minimum id

    A small modification in the code

    SELECT TOP 1 id, Eff_Date, DATEDIFF( MINUTE, Eff_Date, GETDATE() ) AS DateDifference

    FROM [log]

    WHERE ecode = 200

    ORDER BY DateDifference desc

    will give the...

    June 2, 2009 at 8:17 am

    #1003426

  • RE: Query to get the minimum id

    No...

    Expected result:

    100,2,'02/jun/2009'

    200,3,'05/jun/2009'

    June 2, 2009 at 8:15 am

    #1003425

Viewing 15 posts - 211 through 225 (of 1,114 total)