Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a query that I need to write and I am having trouble…

Customer Question
I have a query that...
I have a query that I need to write and I am having trouble with writing it. I need to Get number of admissions for 2015 with the admission date by facility and bedtype
Submitted: 2 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 4 minutes by:
1/22/2016
Programmer: LogicPro, Computer Software Engineer replied 2 years ago
LogicPro
LogicPro, Computer Software Engineer
Category: Programming
Satisfied Customers: 13,507
Experience: Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
Verified

Hi

please provide me table structure

Ask Your Own Programming Question
Customer reply replied 2 years ago
Let me know if this helps
SELECT [Process Date]
,[Date File Created]
,[Action Code]
,[ProcCode]
,[WaiverCode]
,[LTCCode]
,[Payer Identifier Code]
,[Payer]
,[Maintenance Type Code]
,[MaintenanceReason]
,[Subcriber#/RIN#]
,[HICNumber]
,[MemberLastName]
,[MemberFirstName]
,[MemberAddress1]
,[MemberCity]
,[MemberState]
,[MemberZip]
,[Member Birthday]
,[DeathDate]
,[Gender]
,[MemberRace]
,[Race Desc]
,[Comm Qual Type]
,[Communication Nbr#]
,[Effective Date]
,[Policy Number]
,[PolicyName]
,[Medicaid Qualifier]
,[Medicaid Period Format]
,[Medicaid Begin]
,[Medicaid End]
,[Product/Service ID Qualifier]
,[Maintenance Type Code1]
,[Plan Coverage Description]
,[Benefit Qual]
,[Benefit Format]
,[Benefit Begin]
,[Benefit End]
,[InsuranceLine]
,[ResponsibleCode]
,[Entity Type Qual]
,[RespLastName]
,[RespFirstName]
,[RespCommQual1]
,[RespCommNumber1]
,[RespAddress1]
,[RespAddress2]
,[ResponsibleCity]
,[ResponsibleState]
FROM [HIN_SERVERA].[dbo].[AuditFiles_MI]
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

Please provide table structure also

Ask Your Own Programming Question
Customer reply replied 2 years ago
I'm thinking I may need to join to get by facility and bed type
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

Provide table structure of all tables you are referring

Ask Your Own Programming Question
Customer reply replied 2 years ago
Ok I will get back to you tomorrow with this. What time will you be back on here?
Thanks for responding.
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

I am available almost all the time.

Ask Your Own Programming Question
Customer reply replied 2 years ago
Ok perfect, it's pretty late here. I will definitely get back to you. Have a good night.
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

Thank you

good night

Ask Your Own Programming Question
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

let me know if you are available to proceed

Ask Your Own Programming Question
Customer reply replied 2 years ago
Hi,Please disregard last structure, here's the new one where I need to get number of admissions by facility, by bed type and using group by for 2012 for the state of Nebraska and NJ. The Benefit group for Nebraska is N6721 and NJ NIC56Select
Facility name
Facility ID
Admission date
MemberID
Member first
Member last
Authorization_number
Admission_type_description
Actual_discharge date
Authorized admission date
Provider first name
Provider last name
Admission reason
Line of service
Clinical day type
Admission procedure 1
Admission procedure 2
Admission procedure 3
Authorized admissions date
Benefit group
Benefit plan
From Hin_quest.dbo.spauthLet me know if you need anything else.
Customer reply replied 2 years ago
Include count of authorizations
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

It can be better done on your computer

I will have to see your screen. I'm going to make an offer for remote service that you can use. When you accept it, I'll be immediately notified and can do the work to help you while you watch. After accepting, let me know

Ask Your Own Programming Question
Customer reply replied 2 years ago
My computer is protected and not personal because it is company property. Because of these protections, it will not allow me to share my screen. Is there another way?
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

I will have to see the data too.

Which columns have these data:

facility

bed type

2012 for the state of Nebraska and NJ.

What is meant by:

The Benefit group for Nebraska is N6721 and NJ NIC56

Ask Your Own Programming Question
Customer reply replied 2 years ago
Hi LogicPro, I am unable to share my screen because it's company policy. I was told that it should be maybe 4 lines, maybe to look like the below but just need help. If you have any idea with the information given. Can you provide me with an idea of what that query might look like, then I can run it and see what my output is?Select count (authorizations) Auth
From Spauth table
Where
And
Group by
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

can you provide this information:

Which columns have these data:

facility

bed type

2012 for the state of Nebraska and NJ.

What is meant by:

The Benefit group for Nebraska is N6721 and NJ NIC56

Ask Your Own Programming Question
Customer reply replied 2 years ago
Here are the columns below where I need number of admissions by facility and bedtype, MemberID for the year of 2015. As for the state code that column is benefit group, so if I only want to look at all my admissions for Nebraska then I will need to specify. Admissions type is bed type.Facility name
Facility ID
Admission date
MemberID
Member first
Member last
Authorization_number
Admission_type_description
Actual_discharge date
Authorized admission date
Provider first name
Provider last name
Admission reason
Line of service
Clinical day type
Admission procedure 1
Admission procedure 2
Admission procedure 3
Authorized admissions date
Benefit group
Benefit plan
Programmer: LogicPro, Computer Software Engineer replied 2 years ago

My apologies, I am out of ideas and opting out for other Professionals to answer. Please wait. You will be notified by email as soon as any Professional joins you.

I would be happy to help you with your other questions though.

Thank you for your patience.

Ask Your Own Programming Question
Customer reply replied 2 years ago
If I can take a snapshot, would that help.
Customer reply replied 2 years ago
Ok thanks
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask LogicPro Your Own Question
LogicPro
LogicPro
LogicPro, Computer Software Engineer
Category: Programming
Satisfied Customers: 13,507
13,507 Satisfied Customers
Experience: Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

LogicPro is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

13,507 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have a table with 2 fields, EFFECTIVE_DT and END_DT. I
i have a table with 2 fields, EFFECTIVE_DT and END_DT. I have 10 records. I need the MIN effective date and the MAX end date of the records that overlap. Overlap means the END DATE OF the first record… read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
I have an Excel XLsm spreadsheet. I need to accomplish the
I have an Excel XLsm spreadsheet. I need to accomplish the following in the same column Range: 1. Import dates from another spreadsheet. 01/02/2015 DONE----- 2. Allow user to enter "YYYY" only in the … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
Need the answers to the following: 1. (TCO 7) Write a join
need the answers to the following: 1. (TCO 7) Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
13,507 satisfied customers
I am using Adobe Acrobat Pro X and I need a javascript
Hi, I am using Adobe Acrobat Pro X and I need a javascript to calculate a formula for some of my fillable fields.… read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
791 satisfied customers
I' m working with claims data table and need to eliminate records
I' m working with claims data table and need to eliminate records for same discharge date, provider and diagnosis. Can't think of how best to set up. Need to eliminate same day admissions, and use dis… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I'm getting an error I don't understand: Msg 4104, Level
I'm getting an error I don't understand: Msg 4104, Level 16, State 1, Line 5 The multi-part identifier "a.accNumber" could not be bound. What I'm trying to do: I have a single table. table key is the … read more
TheDoctor
TheDoctor
Software Engineer
Master's Degree
893 satisfied customers
I have to update SQL database. So here is what i am trying
I have to update SQL database. So here is what i am trying to do; i have table Invoicedetail, SOdetail I want a query to look: In invoicedetail table and look where any transcation that happend yester… read more
Jerubedo
Jerubedo
Software Engineer
Bachelor\u0027s Degree
7 satisfied customers
Develop the queries to support each of the reports that are
I AM USING SQL*PLUS. I EILL PROVIDE THE SCRIPT Using the BOOKS and PUBLISHER tables, create a query using the traditional join method that will return a list containing the book title, publisher conta… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
I would like to write an Access SQL query where I have these
I would like to write an Access SQL query where I have these fields [Employee] [Customer Ref] [Invoice Date] The user will enter a Employee Name and start and end dates (which I know how to do) and th… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
Help with Access 2010 - criteria in query. Heres a tricky
Help with Access 2010 - criteria in query. Here's a tricky one ... (for me, anyhow!) I have fields to nominate a date to follow up on a job. Every job will have several follow up dates as the job prog… read more
Ruben G.
Ruben G.
Vocational, Technical or Trade Scho
69 satisfied customers
i have a selection of admission dates for each patient in an
i have a selection of admission dates for each patient in an excel file I have. I want to identify the earliest dates for each patient and label that as admission number 1, and the second subsequent d… read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
L A B O V E R V I E W Scenario/Summary Lab #4 will
L A B O V E R V I E W Scenario/Summary Lab #4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. The lab will utilize a set of … read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
Write an application to be used in a college admissions office.
(Java) Write an application to be used in a college admissions office. To be admitted to this school, the student must have either: ?A grade point average of 3.0 or higher and an entrance score of 60 … read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
Hello, I need an answer to a question that you already answered.
Hello, I need an answer to a question that you already answered. File number is XXXXX How can I get it and for how much? Thanks, Unsure Can you respond ASAP, as I needed today. Thanks… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
13,507 satisfied customers
Write an Assembly program to determine the correct admission
Write an Assembly program to determine the correct admission price to a movie. The price of admission to a movie is $7 for kids (under 12) and $9 for adults. Display the correct admission fee after th… read more
Lisa P
Lisa P
Bachelor's Degree
57 satisfied customers
drouleau 3 more programs These are actually programs3 not
drouleau: 3 more programs These are actually programs3 not 4 Write an Assembly program to determine the correct admission price to a movie. The price of admission to a movie is $7 for kids (under 12) … read more
DRouleau
DRouleau
College Diploma
105 satisfied customers
I have copied a datedif formula into a number of cells in a
I have copied a datedif formula into a number of cells in a spreadsheet e.g. =datedif(A1,Today(), "d") The A1 cells whilst empty at the moment will eventually contain dates of admissions to hospital w… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need these in java Write an application to calculate how
I need these in java Write an application to calculate how many days it is from the current day until the first day of next summer ( assuming the date is June21). write an application for a furniture … read more
Rick
Rick
Principal Engineer - Mobile Engeering
Bachelor\u0027s Degree
81 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x