Forum Replies Created

Viewing 15 posts - 4,336 through 4,350 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (2/5/2010)

    Lutz,

    I could track back the person, but I don't think it's appropriate, at least without a subpoena or other legal instrument. We worked hard to protect...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 5, 2010 at 11:09 am

    #1114643

  • RE: SQL Query Involving Dynamic IN Statements

    Please provide table def, sample data, expected result and what you've tried so far as described in the first link in my signature.

    It's much easier to demonstrate what you're trying...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 4:53 pm

    #1114082

  • RE: Time gap query

    Mishelle (2/4/2010)

    ...You all have just replaced my husband!...

    I truly hope just in terms of SQL stuff!! Family/social life is even more important than SQL! 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 4:50 pm

    #1114081

  • RE: Are the posted questions getting worse?

    Paul White (2/4/2010)

    lmu92 (2/4/2010)

    Special thanks to the standard purchasing guidelines to have an RFQ process that involves at least 10 suppliers (each one having your contact information) if you need...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 4:42 pm

    #1114080

  • RE: Dynamic Order by - is there any way to sort Dates correctly

    I'm glad I could help! 😀

    bboufford (2/4/2010)

    ...I was checking character by character there was a space at the begining of my variable name, it wasn't recognizing it. ...

    Sometimes those rather...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 4:15 pm

    #1114068

  • RE: Are the posted questions getting worse?

    Thank you for your response.

    I'm still not sure what I should learn from it:

    On one hand it shows that it's important to notice if an OP obviously posts "real data"...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 3:34 pm

    #1114050

  • RE: Dynamic Order by - is there any way to sort Dates correctly

    I can't see a reason why the following concept wouldn't work...

    DECLARE @orderby VARCHAR(30)

    SET @orderby='MSDue'

    SELECT *

    FROM myTable

    ORDER BY

    CASE @orderby

    WHEN 'Job' THEN Col1

    WHEN 'Author' THEN Col2

    WHEN...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 1:34 pm

    #1113990

  • RE: Dynamic Order by -need both Dates and Varchars

    No. Not in this thread, since I don't think there should be a parallel discussion.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 1:21 pm

    #1113981

  • RE: Time gap query

    mbookout (2/4/2010)

    One more question. I'm running a query that is pulling username, but sometimes there are trailing spaces at the end of the username that I don't want. ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 1:19 pm

    #1113979

  • RE: Are the posted questions getting worse?

    Just a short update regarding the real life address data I talked about a few dozens posts ago:

    I talked to my friend and he forwarded the info to his IT...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 1:13 pm

    #1113972

  • RE: Dynamic Order by -need both Dates and Varchars

    You need to convert your date values to varchar using CONVERT() function.

    You could use CONVERT(VARCHAR(19),Job.[MS Due Date],120) to get a date format which can be sorted.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 12:15 pm

    #1113921

  • RE: Dynamic Order by - is there any way to sort Dates correctly

    Duplicate post.

    Please continue discussion here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 12:12 pm

    #1113918

  • RE: Stored Procedure Help..

    Would you mind providing some more test data to play with?

    I'm thinking of a solution that might work but I'd like to test it a little further...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 11:22 am

    #1113894

  • RE: Time gap query

    Yes, it's possible.

    You need to do a self join on the table on id=id-1 (or based on row_number(), if there are gaps in the id values).

    For a more detailed answer...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 4, 2010 at 10:21 am

    #1113856

  • RE: sp_send_dbmail problems

    You have to define the recipients outside of the @query parameter.

    I'd use that query to build a temp table and assign the related value to @recipients.

    @query then would be something...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    February 3, 2010 at 5:28 pm

    #1113356

Viewing 15 posts - 4,336 through 4,350 (of 5,502 total)