Forum Replies Created

Viewing 15 posts - 7,306 through 7,320 (of 8,761 total)

  • RE: Are the posted questions getting worse?

    Does anyone have some funny sequence code to pitch in here?

    😎

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/27/2014)


    Steve Jones - SSC Editor (8/27/2014)


    Lynn Pettis (8/27/2014)


    Anyone else feel uncomfortable answering this question?

    Not at all. I'd give a range for my company, rather than specifics, but no...

  • RE: Need Help - SQL Select Statement

    Lynn Pettis (8/27/2014)


    Eirikur Eiriksson (8/27/2014)


    keshabsingh (8/27/2014)


    Thanks Eirikur Eiriksson!.

    Your attempt is not bad. πŸ˜›The approaches other users presented are more robust and accurate. Thanks anyway.

    I guess that now it's your turn...

  • RE: Unicode issue

    Robert Heynen-454800 (8/27/2014)


    I tried that first...didn't work

    I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces...

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    Thanks Eirikur Eiriksson!.

    Your attempt is not bad. πŸ˜›The approaches other users presented are more robust and accurate. Thanks anyway.

    I guess that now it's your turn to make an effort....

  • RE: Need Help - SQL Select Statement

    Lynn Pettis (8/27/2014)


    Why did people post code? It would have been nice to see what the OP had tried first since this looks like homework even though the OP...

  • RE: Unicode issue

    Robert Heynen-454800 (8/27/2014)


    I tried that first...didn't work

    I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces...

  • RE: Need Help - SQL Select Statement

    Quick question, what version and edition of sql server (select @@version) are you on?

    😎

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    This is not homework session. Your approach is very limited with hard coding the values. What if data is like this?

    Then, that in itself is a change to the...

  • RE: How to get the resultset datatypes of a stored procedure ?

    patrickmcginnis59 10839 (8/27/2014)


    fregatepllada (8/27/2014)


    Deprecated SET FMTONLY statement did the trick

    http://msdn.microsoft.com/en-us/library/ms173839.aspx

    also check sp_describe_first_result_set, thanks to Eirikur Eiriksson for heads up on that one!

    http://www.sqlservercentral.com/Forums/FindPost1573301.aspx

    Further on this, the code in my initial post...

  • RE: Need Help - SQL Select Statement

    keshabsingh (8/27/2014)


    Run this script

    create table #table1(steps int)

    insert into #table1(steps)values(1)

    insert into #table1(steps)values(3)

    insert into #table1(steps)values(4)

    insert into #table1(steps)values(5)

    select steps from #table1

    drop table #table1

    You will get this

    steps

    1

    3

    4

    5

    I want this way.

    stepFrom stepTo

    1...

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/27/2014)


    rodjkidd (8/27/2014)


    jcrawf02 (8/27/2014)


    rodjkidd (8/27/2014)


    One of the PM's near me is having a meting at his desk. Explaining something to another person. They are almost replying with umhum with...

  • Viewing 15 posts - 7,306 through 7,320 (of 8,761 total)