Forum Replies Created

Viewing 15 posts - 796 through 810 (of 2,894 total)

  • RE: Exercises in t-SQL

    ScottPletcher (11/30/2012)

    ...

    Are you sure that hi __[blank] low is "more logical" than "hi lo __"?

    What about a potential for 10 scores?

    If you're reading it, do you want to see "hi...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 1, 2012 at 3:47 pm

    #1564658

  • RE: Exercises in t-SQL

    ScottPletcher (11/30/2012)

    ...

    In the interests of being thorough, I added a Message to my proposed solution back to them:

    SELECT

    ...as above...,

    CASE WHEN COUNT(*) >...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 3:28 pm

    #1564593

  • RE: Identity Seeding

    jasona.work (11/30/2012)

    If our devs had used the patient ID value as the identity, it would have been a (10,10) seed. The way the current billing application handles patient IDs...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 9:50 am

    #1564470

  • RE: Bulk Insert Row Terminator Woes

    If you using flat-text-files for export-import of data, you should not allow data to contain the same control character (or combination of them) used as row or column separators.

    As...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 9:27 am

    #1564465

  • RE: Exercises in t-SQL

    another one, for my logic only, without even CASE WHEN (actually it's hidden under NULLIF):

    select student_id

    ,high_score = MAX(score) ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 9:13 am

    #1564455

  • RE: Exercises in t-SQL

    ... and got some pretty mediocre answers from (supposedly) experienced and skilled T-SQLers.

    I am not be surprised when good skilled T-SQLers come up with stupid answers on paper during interviews....

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 9:06 am

    #1564447

  • RE: Exercises in t-SQL

    what do you mean by "mid-score"? Do you mean average or second largest score (from three possible ones)?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 8:49 am

    #1564431

  • RE: Exercises in t-SQL

    reposted

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 8:45 am

    #1564423

  • RE: Exercises in t-SQL

    mid_score --may be NULL if only one test taken

    low_score --may be NULL if only one or two tests taken

    Looks a bit illogical to me...

    I can see why mid_score should...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 8:42 am

    #1564421

  • RE: Why the server are running to slow?

    Shadab Shah (11/30/2012)

    Chris Harshman (11/30/2012)

    Have you looked at the execution plan of the query to see what part seems to be a bottleneck? It could be possible that an...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 8:10 am

    #1564393

  • RE: XML outcome shorter in the Management Studio then expected

    It's not an issue. It is default setting.

    menu Tools/Options

    expand Query Results/SQL Server

    select Results to Text

    change "maximum number of characters displayed..." to 8192 (that is absolute max to be displayed...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 8:09 am

    #1564390

  • RE: QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

    freecoder (11/30/2012)

    can u please help me! I have never written dynamic sql. And I dont have time to learn :(.

    Can you give it to someone else to do? Surely if...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 5:52 am

    #1564318

  • RE: QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

    How many records does query return without parameters?

    Looking the latest version of your sp, I can tell that it has quite few things...

    1. Brackets in WHERE clause of your...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 5:50 am

    #1564317

  • RE: QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

    I have also noticed that your code is changes from post to post 😉

    Now I can see that you also trying to page it.

    Please note:

    SET ROWCOUNT is not the...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 5:31 am

    #1564304

  • RE: QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

    freecoder (11/30/2012)

    ok I tried your query and the result has not change at all. I change the responsibilitycode parameter to a specific one instead of 'ALL' the query works fine...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    November 30, 2012 at 5:23 am

    #1564299

Viewing 15 posts - 796 through 810 (of 2,894 total)