help with a query

  • Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

  • erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

    Enjoy smiling at your sarcastic responses. Hope it makes you feel better.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

    I find your response a bit unnecessary, nor have I seen you provide anything of use in helping us solve your problems. You have relied on the volunteers to setup the necessary test environment instead of providing it for us in a readily consummable format so that all we would need to do is cut, paste, and run in a sandbox database and work on a solution.

    Oh, no snarky response is necessary as I already have an idea of what you may say.

  • Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

    I find your response a bit unnecessary, nor have I seen you provide anything of use in helping us solve your problems. You have relied on the volunteers to setup the necessary test environment instead of providing it for us in a readily consummable format so that all we would need to do is cut, paste, and run in a sandbox database and work on a solution.

    Oh, no snarky response is necessary as I already have an idea of what you may say.

    read the thread

    i posted

    someone said i posted badly

    I reposted as requested and said something a long the lines of "sorry for the bad post"

    then i get

    "But same issue of lack of details. I guess Luis has his mind reading cap on today"

    so, my snarky post was in response to a snarkier post and then in apologysing for that snarkier reposnse the snarkier respondee gave another arguably even snarkier reponse

    and yes i have relied on the help of volunteers of which i am very greatful

    the snarkier responder did nothing to help my thread tho 🙂

    and i have no idea what snarky means

  • At this moment, I wish I didn't post any response.

    Your answers have been rude to someone that is trying to help you by giving a good advise.

    This might cause others to be unwilling to help you unless you change your manners.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (9/20/2012)


    At this moment, I wish I didn't post any response.

    Your answers have been rude to someone that is trying to help you by giving a good advise.

    This might cause others to be unwilling to help you unless you change your manners.

    thats a pity

    where was he trying to help?

    in fact his original post on this thread could only ever be a hinderance to it getting resolved rather than a help

  • Luis Cazares (9/20/2012)


    At this moment, I wish I didn't post any response.

    Your answers have been rude to someone that is trying to help you by giving a good advise.

    This might cause others to be unwilling to help you unless you change your manners.

    You should never feel sorry for helping. That is what we do around here.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • erics44 (9/20/2012)


    Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

    I find your response a bit unnecessary, nor have I seen you provide anything of use in helping us solve your problems. You have relied on the volunteers to setup the necessary test environment instead of providing it for us in a readily consummable format so that all we would need to do is cut, paste, and run in a sandbox database and work on a solution.

    Oh, no snarky response is necessary as I already have an idea of what you may say.

    read the thread

    i posted

    someone said i posted badly

    I reposted as requested and said something a long the lines of "sorry for the bad post"

    then i get

    "But same issue of lack of details. I guess Luis has his mind reading cap on today"

    so, my snarky post was in response to a snarkier post and then in apologysing for that snarkier reposnse the snarkier respondee gave another arguably even snarkier reponse

    and yes i have relied on the help of volunteers of which i am very greatful

    the snarkier responder did nothing to help my thread tho 🙂

    and i have no idea what snarky means

    Nope, looked back through the thread and I don't see you posting any code what so ever.

    Found it. Really should use the IFCode shortcuts when posting code. Helps make it more visible.

    All the code posted was by Luis.

    By the way, I have no idea what you are trying to accomplish as nothing you posted helped with my understanding of the problem. The fact that Luis was able to develop a solution is a testament to his problem solving skills, and a willingness to dive in when others (myself included) have decided there isn't enough there to warrant trying. We do have our own jobs to do and there are others asking for help that are willing to help us help them.

  • erics44 (9/20/2012)


    Luis Cazares (9/20/2012)


    At this moment, I wish I didn't post any response.

    Your answers have been rude to someone that is trying to help you by giving a good advise.

    This might cause others to be unwilling to help you unless you change your manners.

    thats a pity

    where was he trying to help?

    in fact his original post on this thread could only ever be a hinderance to it getting resolved rather than a help

    Actually I was trying to help.

    After Luis put together something usable to try to work on it you wrote this:

    thanks a lot mate

    it works a treat for the example table

    issue i have now is that for an 800 row table it takes ages

    I pointed out that if you had posted the details you would get help. That is a pretty good indication that your actual table and your little temp table are vastly different from each other. Without some details nobody can help.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    well spotted pal, the two are linked

    completely different problem tho

    But same issue of lack of details. I guess Luis has his mind reading cap on today.

    you ok matey? got out of the wrong side of the bed?

    the other question was answered by multiple people conclusively, perhaps the world is full of mind readers do you think?

    Perhaps my response was more aggressive than it needed to be. However in both of your threads the people that helped you had to post something usable first. The point I was trying to make is that if you do a little of the leg work the people around here (all volunteers) can spend their time working on your issue instead of setting it up. You will have a much wider audience if you put in the effort so they don't have to. Hopefully in the future you will post ddl and sample data so other don't have to create it for you.

    Glad you were able to fix your issues.

    this was a point already made and resolved in this very thread

    it didnt need any additional involvement from the sql server central police 🙂

    shouldnt you be out on the street checking if anyone else id posting properly?

    I apologized for being aggressive. A little smiley face does not the mask the tone of your snarky response.

    im not trying to mask anything, im quite pleased with my sarcastic response as it makes you look a bit daft

    im sat here with a smile on my face

    I find your response a bit unnecessary, nor have I seen you provide anything of use in helping us solve your problems. You have relied on the volunteers to setup the necessary test environment instead of providing it for us in a readily consummable format so that all we would need to do is cut, paste, and run in a sandbox database and work on a solution.

    Oh, no snarky response is necessary as I already have an idea of what you may say.

    read the thread

    i posted

    someone said i posted badly

    I reposted as requested and said something a long the lines of "sorry for the bad post"

    then i get

    "But same issue of lack of details. I guess Luis has his mind reading cap on today"

    so, my snarky post was in response to a snarkier post and then in apologysing for that snarkier reposnse the snarkier respondee gave another arguably even snarkier reponse

    and yes i have relied on the help of volunteers of which i am very greatful

    the snarkier responder did nothing to help my thread tho 🙂

    and i have no idea what snarky means

    Nope, looked back through the thread and I don't see you posting any code what so ever.

    Found it. Really should use the IFCode shortcuts when posting code. Helps make it more visible.

    All the code posted was by Luis.

    By the way, I have no idea what you are trying to accomplish as nothing you posted helped with my understanding of the problem. The fact that Luis was able to develop a solution is a testament to his problem solving skills, and a willingness to dive in when others (myself included) have decided there isn't enough there to warrant trying. We do have our own jobs to do and there are others asking for help that are willing to help us help them.

    Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being objective

  • Sean Lange (9/20/2012)


    erics44 (9/20/2012)


    Luis Cazares (9/20/2012)


    At this moment, I wish I didn't post any response.

    Your answers have been rude to someone that is trying to help you by giving a good advise.

    This might cause others to be unwilling to help you unless you change your manners.

    thats a pity

    where was he trying to help?

    in fact his original post on this thread could only ever be a hinderance to it getting resolved rather than a help

    Actually I was trying to help.

    After Luis put together something usable to try to work on it you wrote this:

    thanks a lot mate

    it works a treat for the example table

    issue i have now is that for an 800 row table it takes ages

    I pointed out that if you had posted the details you would get help. That is a pretty good indication that your actual table and your little temp table are vastly different from each other. Without some details nobody can help.

    Luis was a great help, his code worked well

    i now have a solution, he read the thread and when he felt I hadnt posted as well as i could gave a very informative sugestion which i took on board, acted and then the situation was resolved

    no snark, no pedanticness, just love 🙂

  • erics44 (9/20/2012)


    ...

    Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being objective

    I had no opinion of you and didn't let my feelings keep me from being objective. I couldn't understand the problem you were trying to solve, nothing you posted subsequently helped me understand it any better,. Luis was working it, I passed it by. It was the later comments you posted that had me post my responses. I found them to be snarky and uncalled for as I read them.

  • Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    ...

    Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being objective

    I had no opinion of you and didn't let my feelings keep me from being objective. I couldn't understand the problem you were trying to solve, nothing you posted subsequently helped me understand it any better,. Luis was working it, I passed it by. It was the later comments you posted that had me post my responses. I found them to be snarky and uncalled for as I read them.

    I dont agree

    "all your posts have lack of details, anyone who answers them must be mind readers"

  • erics44 (9/20/2012)


    Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    ...

    Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being objective

    I had no opinion of you and didn't let my feelings keep me from being objective. I couldn't understand the problem you were trying to solve, nothing you posted subsequently helped me understand it any better,. Luis was working it, I passed it by. It was the later comments you posted that had me post my responses. I found them to be snarky and uncalled for as I read them.

    I dont agree

    "all your posts have lack of details, anyone who answers them must be mind readers"

    You know, I have gone through the all the posts in this thread and I can't find this quote anywhere:

    "all your posts have lack of details, anyone who answers them must be mind readers"

    And I definately don't see it in any of my posts.

  • Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    Lynn Pettis (9/20/2012)


    erics44 (9/20/2012)


    ...

    Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from being objective

    I had no opinion of you and didn't let my feelings keep me from being objective. I couldn't understand the problem you were trying to solve, nothing you posted subsequently helped me understand it any better,. Luis was working it, I passed it by. It was the later comments you posted that had me post my responses. I found them to be snarky and uncalled for as I read them.

    I dont agree

    "all your posts have lack of details, anyone who answers them must be mind readers"

    You know, I have gone through the all the posts in this thread and I can't find this quote anywhere:

    "all your posts have lack of details, anyone who answers them must be mind readers"

    And I definately don't see it in any of my posts.

    thats coz you didnt post it

    Your mate was being a divy, he posted an uneccessary and agressive post

    I tried to make light of it (look at the top of page 2)

    If someone had posted the same post towards you you would have responded in a similar way to i did (although perhaps not as witty)

Viewing 15 posts - 16 through 30 (of 44 total)

You must be logged in to reply to this topic. Login to reply