Forum Replies Created

Viewing 15 posts - 376 through 390 (of 859 total)

  • RE: help with SQL query please

    vinu512 (5/1/2012)

    This does:

    SSelect * From ClientDetails

    Where InterviewDate IN (Select MAX(InterviewDate) From ClientDetails Group By ClientID)

    the problem with that query is the IN list contains the max interview date for each...

    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]

    May 2, 2012 at 8:32 am

    #1482423

  • RE: nth occurance of a alphabet

    since in your other thread you ask how to build a tally table i thought i would give you one method to do it with a tally table. it...

    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]

    May 2, 2012 at 8:07 am

    #1482397

  • RE: Today's Random Word!

    crookj (5/1/2012)

    Daniel Bowlin (5/1/2012)

    Revenant (4/30/2012)

    Peter Trast (4/30/2012)

    crookj (4/30/2012)

    Peter Trast (4/30/2012)

    Peter Trast (4/30/2012)

    Lynn Pettis (4/30/2012)

    Peter Trast (4/30/2012)

    EL Jerry (4/30/2012)

    Daniel Bowlin (4/30/2012)

    anthony.green (4/30/2012)

    capn.hector (4/27/2012)

    SQLRNNR (4/27/2012)

    EL Jerry (4/27/2012)

    Lynn Pettis (4/26/2012)

    Freedom!

    Wallace?

    Gromit

    tie down

    kangaroo

    captain

    Ship.

    Wreck

    Iceberg

    Lettuce

    Pray

    ing

    Mantis

    Raimi

    Spiderman

    Mothman

    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]

    May 1, 2012 at 12:52 pm

    #1482029

  • RE: Changing Default Directory for Transaction logs

    paradski (5/1/2012)

    Yes, that is it. The only hitch is that the software we use creates the projects by using the default settings so we will have to change that....

    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]

    May 1, 2012 at 12:46 pm

    #1482024

  • RE: how to join many rows from table in 1 row in sql server 2008

    Lynn Pettis (5/1/2012)

    +1. Yes, it is possible.

    If you would take the time to read the first article I reference below in my signature block and follwo the instructions regarding...

    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]

    May 1, 2012 at 12:18 pm

    #1481989

  • RE: t-sql query

    Eugene Elutin (5/1/2012)

    Jeff Moden (5/1/2012)

    capn.hector (5/1/2012)

    Eugene Elutin (5/1/2012)

    Jeff Moden (5/1/2012)

    Phil Parkin (5/1/2012)

    Eugene Elutin (5/1/2012)

    ...

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    ...

    I...

    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]

    May 1, 2012 at 10:07 am

    #1481894

  • RE: Aggregating counts and getting cumulative counts by date

    jmadsen 98862 (5/1/2012)

    This seems like a good time to point something out I've thought about.

    It is quite disappointing that SQL ServerCentral continues to leave Mr. Celko's comments on this...

    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]

    May 1, 2012 at 9:58 am

    #1481883

  • RE: Referencing a case statement in the Where Clause

    Can you post DDL and Sample date (See the link in my signature for help on posting that if you need it.) it looks like your where clause is...

    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]

    May 1, 2012 at 9:33 am

    #1481862

  • RE: Please convert cursor based query to a set based query

    looking through the code it looks like you select LinkID and name then run them through individually getting one result for each LinkID and Name. you can deffinitly rewrite...

    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]

    May 1, 2012 at 9:29 am

    #1481859

  • RE: Howto retrieve new unicode rupee notation ?

    S_Kumar_S (5/1/2012)

    The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned...

    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]

    May 1, 2012 at 9:07 am

    #1481846

  • RE: t-sql query

    Eugene Elutin (5/1/2012)

    Jeff Moden (5/1/2012)

    Phil Parkin (5/1/2012)

    Eugene Elutin (5/1/2012)

    ...

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    ...

    I prefer to use "!=" over...

    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]

    May 1, 2012 at 9:03 am

    #1481843

  • RE: help with SQL query please

    imex (4/30/2012)

    Try:

    with CTE as

    (

    select ClientID, max(ID) as ID from ClientDetails group by ClientID

    )

    select d.ID, d.ClientID, d.InterviewDate

    from CTE as c

    join ClientDetails as d on d.ID = c.ID

    Hope...

    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]

    May 1, 2012 at 8:40 am

    #1481821

  • RE: help with SQL query please

    to those who are saying its a cross post look at the DDL and Sample data and output. clearly a different problem just that the OP used the same...

    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]

    May 1, 2012 at 7:58 am

    #1481799

  • RE: question on memory settings

    mohammed moinudheen (4/30/2012)

    Sapen (4/30/2012)

    If upgrading the OS to Enterprise edition is the only solution then I am sure it is wasted (budget constraints).

    What would be the implications on SQL Server...

    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 30, 2012 at 8:37 pm

    #1481581

  • RE: please give me a solution for this request

    Jeff Moden (4/28/2012)

    capn.hector (4/23/2012)

    SQLKnowItAll (4/23/2012)

    Jeff Moden (4/23/2012)

    capn.hector (4/23/2012)

    +1 however i saw this same question as homework for one of my sql classes.

    Interesting! Where did you take...

    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 30, 2012 at 6:14 pm

    #1481558

Viewing 15 posts - 376 through 390 (of 859 total)