Forum Replies Created

Viewing 15 posts - 31 through 45 (of 859 total)

  • RE: Simular to PIVOT Table, but not

    AndrewSQLDBA (12/12/2012)

    Yes, that is exactly what I need / want. I mean, there will not be 2 million different LabNames, but one userID could have 3, and another have 30...

    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]

    December 12, 2012 at 2:10 pm

    #1568070

  • RE: Set Row Identity from a Variable

    AndrewSQLDBA (12/12/2012)

    I found that out about the table variable, so i now use a temp table. Not a big deal. I would much rather use a table variable, especially for...

    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]

    December 12, 2012 at 1:55 pm

    #1568062

  • RE: Today's Random Word!

    Cliff Jones (12/12/2012)

    Ray K (12/12/2012)

    Daniel Bowlin (12/12/2012)

    motley

    crue

    wine

    Complain

    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]

    December 12, 2012 at 12:37 pm

    #1568038

  • RE: query to get the name of a product with only incremental values in the quantity column

    This looks like homework or an interview question so ill post some usable data. Can you show what you have tried so far?

    CREATE TABLE tmpProduct (

    Product VARCHAR(32),

    [Year] INT,

    QTY INT,

    CONSTRAINT...

    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]

    December 12, 2012 at 11:12 am

    #1568015

  • RE: NEED HELP WITH RECURSIVE CTE

    This looks like a running total (from the math in the rCTE). Have a look at Jeff Modens article on the "Quirky Update" http://www.sqlservercentral.com/articles/T-SQL/68467/ It will at least...

    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]

    December 12, 2012 at 10:47 am

    #1568006

  • RE: Simular to PIVOT Table, but not

    AndrewSQLDBA (12/12/2012)

    The thing of the data is this. I have no idea what will be in that column, so a case statement will not work, that I see.

    And there are...

    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]

    December 12, 2012 at 10:41 am

    #1568004

  • RE: Set Row Identity from a Variable

    No problem. the only issue is i dont think it will work with the table variables. for those you may need dynamic sql or just use a temp...

    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]

    December 12, 2012 at 10:25 am

    #1567992

  • RE: Set Row Identity from a Variable

    one option is to create the table with an IDENTITY (1,1) and then a DBCC CHECKIDENT to reseed the table at the given value passing a variable to it

    IF OBJECT_ID('dbo.Test')...

    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]

    December 12, 2012 at 10:20 am

    #1567989

  • RE: ORDER BY Should be same as my input in IN()

    GSquared (12/11/2012)

    CELKO (12/11/2012)

    >> --But I need the result as below (i.e, the order should be same as how I had input the value in the IN() ) <<

    You 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]

    December 11, 2012 at 2:13 pm

    #1567613

  • RE: Multivalue Parameters with Stored Procedure

    DarthBurrito (12/6/2012)

    So I spent most of the dya searching for an answer, which I did find. As the title states, I was trying to find a method to pass multiple...

    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]

    December 6, 2012 at 4:10 pm

    #1566380

  • RE: An alternative to split for performance benefits?

    Rob-350472 (12/6/2012)

    I'd have to review the split function you linked to - I opened it and had a quick look but I've not had the time to read it yet.

    As...

    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]

    December 6, 2012 at 3:45 pm

    #1566375

  • RE: Breaking up a data load to prevent log file growth

    well the process ran yesterday evening with no ill affects. unfortunately i don't believe i can speed it up any more because of business rules about the data. ...

    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]

    December 6, 2012 at 11:00 am

    #1566273

  • RE: Logon failure: unknown user name or bad password

    I know this is an old post but needed to update. i just experienced this same error (only on 2008) and changing to the local system account for 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]

    December 6, 2012 at 10:57 am

    #1566272

  • RE: Solve Problems Using Recursive CTE

    This looks like a gaps and island problem. it also from the problem description sounds like homework or an interview question.

    Take a look at this for a detailed explanation...

    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]

    December 5, 2012 at 3:04 pm

    #1565942

  • RE: Dynamic SQL

    toddasd (12/5/2012)

    All your answers lie here:

    http://www.sommarskog.se/dynamic_sql.html

    Another person who posts the same dynamic sql article.

    i highly recommend the suggested reading.

    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]

    December 5, 2012 at 2:18 pm

    #1565920

Viewing 15 posts - 31 through 45 (of 859 total)