Urgent help needed..PLZ HELP ME..

  • Lynn Pettis (5/11/2014)


    David Burrows (5/11/2014)


    Lynn Pettis (5/11/2014)


    Eirikur Eiriksson (5/7/2014)


    rhythmk (5/7/2014)


    vasugunda (5/7/2014)


    Hi everyone..

    i just want retrieve patient information from 1st discharge date to 6 months later date .

    Can you please elaborate with more clarity as I am confused with above statement and your resultset.Also please let us know what you have tried so far so that we can easily help you.

    Hi rhythmk,

    sometimes it is simpler to respond with a suggestion which could technically be correct, but isn't necessarily so. The feedback is often closer to an accurate description, this can cut few steps in the requirements trawling:-D

    😎

    I hate to disagree with you, but if I don't understand the requirements I would rather ask questions to clarify what is needed rather than spend my time guessing at what the OP is after. This is especially true if I have to make the effort to setup the test environment to do the work as well. The more effort that an OP puts into their question, provides readily consumable DDL, sample data, and expected results the more effort I can apply to helping solve a problem than just making a shot in the dark that may or may not help.

    Generally I have to agree with you but in this case (and other elsewhere) you can ask continually for info but just get more and more befuddled. It is OK when OP gives you consistent data and results but sometimes a few queries prods them in the right direction and that can help. How many times have you on a thread asked for (and others) info and get little or no help. Yes, you can say OK I won't bother, that is your right, but it does not help the OP who could be a complete novice and wants to avoid the overbearing criticism that this site sometimes portrays.

    And I have been there giving shots in the dark, but usually because I managed to have somewhat of an understanding of the requirements. All I was saying that it isn't always best to throw out code in the hopes that you provide a usable answer. Sometimes you need to ask questions first. It also helps to get the OP to think through their problem a bit more before just giving them code.

    Plus, I have also been there when I have given code and all you get back from the OP is "Nope, that didn't work." Real helpful response when effort was made to try and help.

    Yes absolutely true, that is why you're a saint and I'm just a mere novice 😀

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Hi David and Lynn,

    thank you both for the input, I appreciate it.

    Firstly, this is a valuable discussion and would merit a thread on its own.

    Thanks to columnar editing in SSMS, preparing the sample data took less than drinking a cup of espresso. That also provided a platform for communication and a simple way to evaluate requirements and result. In my mind, a time well spent.

    😎

  • Eirikur Eiriksson (5/11/2014)


    Hi David and Lynn,

    thank you both for the input, I appreciate it.

    Firstly, this is a valuable discussion and would merit a thread on its own.

    Thanks to columnar editing in SSMS, preparing the sample data took less than drinking a cup of espresso. That also provided a platform for communication and a simple way to evaluate requirements and result. In my mind, a time well spent.

    😎

    Well, when you are working 12+ hour days 7 days a week, there isn't much free time so when I help it is nice when I don't have to take the time to create a test environment before starting to work a problem. Cut, paste, run to setup the test environment makes getting to the problem at hand much easier.

  • Lynn Pettis (5/11/2014)


    Eirikur Eiriksson (5/11/2014)


    Hi David and Lynn,

    thank you both for the input, I appreciate it.

    Firstly, this is a valuable discussion and would merit a thread on its own.

    Thanks to columnar editing in SSMS, preparing the sample data took less than drinking a cup of espresso. That also provided a platform for communication and a simple way to evaluate requirements and result. In my mind, a time well spent.

    😎

    Well, when you are working 12+ hour days 7 days a week, there isn't much free time so when I help it is nice when I don't have to take the time to create a test environment before starting to work a problem. Cut, paste, run to setup the test environment makes getting to the problem at hand much easier.

    +1

    By the way how things going over there 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

  • David Burrows (5/11/2014)


    Lynn Pettis (5/11/2014)


    Eirikur Eiriksson (5/11/2014)


    Hi David and Lynn,

    thank you both for the input, I appreciate it.

    Firstly, this is a valuable discussion and would merit a thread on its own.

    Thanks to columnar editing in SSMS, preparing the sample data took less than drinking a cup of espresso. That also provided a platform for communication and a simple way to evaluate requirements and result. In my mind, a time well spent.

    😎

    Well, when you are working 12+ hour days 7 days a week, there isn't much free time so when I help it is nice when I don't have to take the time to create a test environment before starting to work a problem. Cut, paste, run to setup the test environment makes getting to the problem at hand much easier.

    +1

    By the way how things going over there 🙂

    Going well. Still working on borrowed time, but I have extended until February 27, 2015 with a short 2 week visit home over Christmas/New Years.

    Would be nice to know if I will still have a job with this company when I go home. I have a couple of people working at trying to keep me with the company.

  • I hope all goes well 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Thanks for your help Much appreciated

    i changed a little bit of code

    i got the result but got any idea about the code

    can you help me in explaining the code

    Thanks in advance

  • its just adding the 6 months to the discharge record

    which is not the requirement

    any way Thanks a lot for helping me and trying to help me

    I got the result

    If you need the code i can post it for you

  • vasugunda (5/12/2014)


    If you need the code i can post it for you

    Yes please I'm curious as to the final solution.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 9 posts - 16 through 23 (of 23 total)

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