Forum Replies Created

Viewing 15 posts - 676 through 690 (of 859 total)

  • RE: a looping subquery whose result set is used by parent? do I use a CTE?

    your rownumber over will work and may be faster than my join to a sub query. i would try both in your system and use which every is faster.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 6:04 pm

    #1469240

  • RE: a looping subquery whose result set is used by parent? do I use a CTE?

    patrickmcginnis59 (4/4/2012)

    Here's my attempt, probably can be shortened or better versions posted by the experts.

    select row, studentid, revision_cycle, grade_assigned, reason

    from

    (

    select row_number() over (partition by studentid order by revision_cycle desc) row,

    studentid,...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 5:50 pm

    #1469235

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/4/2012)

    http://en.wikipedia.org/wiki/Schutzstaffel

    and how different can you get in 6 links?

    i got to rolling stone

    http://en.wikipedia.org/wiki/Rolling_Stone

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 4:50 pm

    #1469220

  • RE: query for consecutive alphabets

    sharky (4/4/2012)

    SQL is pretty bad at doing any character manipulation and comparison. I always use LIKE, CHARINDEX etc. as a last resort. I agree, your solution performs much better...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 1:19 pm

    #1469124

  • RE: Are the posted questions getting worse?

    Jack Corbett (4/4/2012)

    Stefan Krzywicki (4/4/2012)

    Ever worked with someone who can't seem to handle answering more than one question in an email? I'll ask several related questions and receive...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 12:22 pm

    #1469078

  • RE: datetime field

    Cadavre (4/4/2012)

    capn.hector (4/4/2012)

    i would test to see which is faster.

    I know what you're thinking, it's far faster to not cast a datetime as a string so it follows that it'll...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 9:35 am

    #1468967

  • RE: Need some help figuring out my first trigger

    joshd 1807 (4/4/2012)

    I don't think I'd need to test for a valid date as the FedEx software would take care of that itself.

    I'll give your suggestion a try and let...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:58 am

    #1468925

  • RE: Are the posted questions getting worse?

    GSquared (4/4/2012)

    capn.hector (4/4/2012)

    Lynn Pettis (4/4/2012)

    GilaMonster (4/4/2012)

    A new misspelling for my records...

    Thank you Linn and Gylla

    Me too.

    i always like the ones that thank my post count level thingy (ssc-whatever)

    I get a...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:54 am

    #1468922

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/4/2012)

    GilaMonster (4/4/2012)

    A new misspelling for my records...

    Thank you Linn and Gylla

    Me too.

    i always like the ones that thank my post count level thingy (ssc-whatever)

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:24 am

    #1468899

  • RE: datetime field

    Gianluca Sartori (4/4/2012)

    You can cast both to DATE type:

    SELECT CASE

    WHEN CAST(@datetimefield AS DATE) = CAST(@dateonlyparameter AS DATE)

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:16 am

    #1468893

  • RE: SELECT next "jobs" to do

    if you are writing a custom program or want to write triggers on a table we do something similar to this. we have a waiting assignment table. the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:13 am

    #1468890

  • RE: is it possible to re-order the intellisense options as they appear?

    davidandrews13 (4/4/2012)

    ok. thats weird.

    my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.

    Here are my...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 8:01 am

    #1468877

  • RE: Improved performance of restore process

    GilaMonster (4/4/2012)

    Highly unlikely.

    If it's running at a different time of the day it could be that the disk and network are under less load.

    Backup and restore time are principally governed...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 7:56 am

    #1468872

  • RE: How to access sysobjects information through a non admin user

    GilaMonster (4/4/2012)

    The answer is grant view definition to that user. Why is that not an option here?

    p.s. sysobjects is deprecated, should not be used any longer, included only for backward...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 7:38 am

    #1468847

  • RE: CASE WHEN LEFT(...) Pretty please - why isn't this working?

    can you post sample data and the table DDL and an exlination of what you are trying to achieve. right now i see a case statement and have no...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 7:29 am

    #1468835

Viewing 15 posts - 676 through 690 (of 859 total)