May 11, 2014 at 8:28 am
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.
May 11, 2014 at 8:33 am
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.
😎
May 11, 2014 at 9:45 am
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.
May 11, 2014 at 9:53 am
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.
May 11, 2014 at 10:00 am
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.
May 11, 2014 at 10:48 am
I hope all goes well 🙂
Far away is close at hand in the images of elsewhere.
Anon.
May 12, 2014 at 3:30 pm
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
May 12, 2014 at 3:34 pm
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
May 13, 2014 at 1:48 am
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