Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 15,381 total)

  • RE: How to tune this query

    Since the constant side of your where predicate is not lower case I assume you don't have a case sensitive collation. That means you could greatly increase the performance just...

    March 9, 2015 at 8:01 am

    #1782526

  • RE: Ranking and Sequencing for equally ranked records

    bharatgi (3/6/2015)

    Thanks Sean.

    Apologies for using the wrong format, I wasn't sure which ifcode to use, but will remember for future reference

    Glad that worked for you. 🙂

    The point really wasn't...

    March 6, 2015 at 3:35 pm

    #1782308

  • RE: Optimizing a query

    Your code has a lot of nonSARGable predicates. Then it is compounded by what is essentially an inline scalar function. I am not at all surprised the performance is less...

    March 6, 2015 at 1:52 pm

    #1782282

  • RE: Ranking and Sequencing for equally ranked records

    bharatgi (3/6/2015)

    i have a table containing the top 5 teams points for the current season using the rank function, and as well as their points for last season.

    the only...

    March 6, 2015 at 1:41 pm

    #1782281

  • RE: bigint to datetime

    snomadj (3/5/2015)

    I have a column in a docave table (timecreated) that is typed bigint.

    I cannot for the life of me figure out how to convert this into a sensible datetime...

    March 5, 2015 at 1:30 pm

    #1782030

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (3/5/2015)

    Sean Lange (3/5/2015)

    Brandie Tarvin (3/5/2015)

    SQLRNNR (3/5/2015)

    dwain.c (3/5/2015)

    Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not...

    March 5, 2015 at 9:34 am

    #1781969

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/5/2015)

    SQLRNNR (3/5/2015)

    dwain.c (3/5/2015)

    Is it just that it's been so long that I haven't posted one, or does the Article Contribution Center (article editor) not play well with IE11?

    I...

    March 5, 2015 at 8:39 am

    #1781950

  • RE: Backing up from SETUSER

    DBCC TIMEWARP is active again I see. We have a question from the future about a deprecated feature. :w00t:

    March 5, 2015 at 7:54 am

    #1781930

  • RE: Joining to tables with bad data

    ps_vbdev (3/5/2015)

    Thanks

    yes totally agree with you, but i inherited this issue and the time scales. we are a seasonal business so data fix has to wait until our low season,...

    March 5, 2015 at 7:18 am

    #1781925

  • RE: How to divide the value in row 2 by the value in row 2 in the same column

    trishdiep (3/4/2015)

    Hi all,

    Can you please help what is wrong with my query, I try to take the value from row 1 divided by the value from row 2 but it...

    March 5, 2015 at 7:12 am

    #1781923

  • RE: Joining to tables with bad data

    ps_vbdev (3/5/2015)

    I have a table that holds product prices. It was originally designed to hold historical price values of products but this was abandoned after a few years. So now...

    March 5, 2015 at 7:08 am

    #1781921

  • RE: query grouping by month

    It is hard to say for sure because we don't have the tables and data to work with but you are grouping by dbo.tblCourses.CourseDate which is not returned in the...

    March 5, 2015 at 7:05 am

    #1781918

  • RE: Query to select parent details from child table

    Hi and welcome to the forums. In order to help we will need a few things:

    1. Sample DDL in the form of CREATE TABLE statements

    2. Sample data in the form...

    March 4, 2015 at 2:21 pm

    #1781775

  • RE: CONVERT and CAST question?

    eedgar 45478 (3/4/2015)

    Thank you Laurie..but how do i modify this so i can pull all the other records in that column? Thanks in advance:-)

    What do you mean by "pull all...

    March 4, 2015 at 2:18 pm

    #1781774

  • RE: Update Table - By Looping Through Field Name

    yungmunk (3/3/2015)

    Sean Lange (3/3/2015)

    yungmunk (3/2/2015)

    Hello, I'm sorry to resurrect such an old post but I'm trying to do basically the same thing the original poster was. Your code looks...

    March 4, 2015 at 7:07 am

    #1781615

Viewing 15 posts - 3,166 through 3,180 (of 15,381 total)