Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 15,381 total)

  • RE: The inline TVF

    george.p (12/15/2016)


    Sean Lange (12/15/2016)


    george.p (12/15/2016)


    I missed the title so I assumed it meant Scalar functions 🙁

    You're one of those people that puts all of the details in the title of...

  • RE: The inline TVF

    george.p (12/15/2016)


    I missed the title so I assumed it meant Scalar functions 🙁

    You're one of those people that puts all of the details in the title of an email aren't...

  • RE: The inline TVF

    Luis Cazares (12/15/2016)


    ChrisM@Work (12/15/2016)


    Luis Cazares (12/15/2016)


    I've never written an iTVF using parenthesis around the query. However, the other answers were completely wrong and the correct answer states that it can...

  • RE: NULL Datetime causing NULL string when converting

    Lynn Pettis (12/14/2016)


    Not necessarily, being older I mean. Where were you when the original Star Wars hit the theaters?

    In the fourth row!!! LOL.

    I know you have me by...

  • RE: The inline TVF

    Yeah I felt that none of the answers were totally accurate. I knew that you neither required parenthesis nor used begin/end. I had to guess between them and chose incorrectly....

  • RE: Are the posted questions getting worse?

    Not many truly know just how scary old man Fred Phelps was and his whole clan better than I do. I grew up in Topeka right across the street from...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/7/2016)


    In Orlando this week for Live360. Leaving this afternoon, and it's 18F at home. Didn't bring a coat, and couldn't wear a long sleeve this...

  • RE: Query optimization

    CELKO (12/6/2016)


    You know that we have two options, either portable code or fast code. You can't have both.

    No, I do not know that because the building entire career...

  • RE: Are the posted questions getting worse?

    I sure wish JC would get off his high horse once in awhile. His constant diatribe about portability is a joke. Then he berates posters for not making things clear....

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (12/6/2016)


    Ed Wagner (12/6/2016)


    Sean Lange (12/6/2016)


    Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to...

  • RE: Query optimization

    CELKO (12/6/2016)


    Using proprietary dialect constructs like CROSS APPLY and TOP make optimization difficult and portability impossible.

    Joe you make me laugh. You know that we have two options, either portable...

  • RE: Are the posted questions getting worse?

    Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to a location and pay for the...

  • RE: Extract values from a string

    eshaw (12/6/2016)


    Good day gurus!!!

    I have a string in a varchar(max) field where I need to extract out only certain values. How would I go about getting everything out of...

  • RE: Select query inside procedure taking long time, clustered indexes doing scans, need suggestion

    sqlandbiuser (12/5/2016)


    @SSCrazy- Thanks for these valuable inputs..

    fn_SplitString - This function is used to split the pipe delim. parameters being passed from multi-select dropdown boxes, and we have 5 such parameters....

  • RE: Query optimization

    Slight detour from the task at hand. You have a couple subqueries here using TOP 1 but there is no order by. Without an order by you have know of...

Viewing 15 posts - 1,096 through 1,110 (of 15,381 total)