Forum Replies Created

Viewing 15 posts - 511 through 525 (of 5,502 total)

  • RE: SQL exercises for job applicants

    I like the FizzBuzz puzzle.

    I use it to identify if an applicant

    - prefers using a set or loop based method where both methods are possible

    - knows enough T-SQL to...


    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]

    March 11, 2012 at 3:59 am

    #1457561

  • RE: how to write an insert store for a input like 1_2|3_4 it should get seprated and stored in...

    I surrender.


    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]

    March 11, 2012 at 3:38 am

    #1457558

  • RE: Sorting comma separated numbers

    Please copy the code I posted and run it as it is. Without any modification. Neither renaming columns nor anything else.

    What result do you get?


    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]

    March 11, 2012 at 3:30 am

    #1457556

  • RE: how to write an insert store for a input like 1_2|3_4 it should get seprated and stored in...

    I've seen the expected output before.

    But what rules do apply?

    Are the values of indexnumber identical to adbid or how are those values calculated? What does the value in...


    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]

    March 11, 2012 at 3:12 am

    #1457551

  • RE: Sorting comma separated numbers

    shyamhr (3/11/2012)

    hi Lutz,

    ...

    Thanks... Please suggest any other solution

    I can't really offer any other solution since the one I posted works just fine for me (= returning the expected result).

    One reason...


    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]

    March 11, 2012 at 3:06 am

    #1457549

  • RE: Sorting comma separated numbers

    I'm wondering why this needs to be a T-SQL task.

    In a decent normalized database structure there shouldn't be a column with a comma separated list and esepcially not the 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]

    March 11, 2012 at 1:31 am

    #1457540

  • RE: Why this query doesn't work

    I can't spot the difference of the two queries. Both seem to be identical.

    And why do you return columns in the subquery that aren't used in the outer query at...


    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]

    March 11, 2012 at 1:01 am

    #1457539

  • RE: how to write an insert store for a input like 1_2|3_4 it should get seprated and stored in...

    Please describe how the input data need to be separated to return the result set you're looking for. Even though we could figure most of it by reverse-engineer your undocumented...


    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]

    March 11, 2012 at 12:56 am

    #1457538

  • RE: BCP OUT - Force Order

    May I kindly ask you again to include the Sortorder column in the output of your select statement?

    I know you can't post your real data. But when troubleshooting it really...


    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]

    March 10, 2012 at 9:40 am

    #1457503

  • RE: BCP OUT - Force Order

    What is the Sortorder column based on? Can you add it to your output to see what values are in that column?

    Just guessing here but the order might be exactly...


    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]

    March 10, 2012 at 8:55 am

    #1457493

  • RE: BCP OUT - Force Order

    Is the issue resolved or do you still get unordered results?


    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]

    March 10, 2012 at 8:45 am

    #1457489

  • RE: BCP OUT - Force Order

    I can't see any ORDER BY in your query...

    bcp "select 'Col1', 'Col2', 'Col3','Date' union all select top 15 cast(Col1 as varchar(25)) as Col1,Col2,Col3,cast(DATE as varchar(25))as DATE from TABLENAME where SortOrder<>0...


    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]

    March 10, 2012 at 8:07 am

    #1457481

  • RE: BCP OUT - Force Order

    Can you post the bcp statement you're using?


    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]

    March 10, 2012 at 7:12 am

    #1457476

  • RE: Can a select statement be used to parse the results of a stored procedure ?

    You might want to have a look at Erlands blog for several options.


    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]

    March 10, 2012 at 6:25 am

    #1457470

  • RE: BCP OUT - Force Order

    Do you have an ORDER BY in the SELECT statement used in the BCP command?

    As long as there's no specific ORDER BY in a statemewnt, the order of returned rows...


    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]

    March 10, 2012 at 6:14 am

    #1457468

Viewing 15 posts - 511 through 525 (of 5,502 total)