How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask projectx2501-PHD-DBA Your Own Question
projectx2501-PHD-DBA
projectx2501-PHD-DBA, Information Systems Manager
Category: Computer
Satisfied Customers: 1276
Experience:  Over ten years experience in information systems management!
65274887
Type Your Computer Question Here...
projectx2501-PHD-DBA is online now

I am looking for help with SQL Query, Validating data in

This answer was rated:

Hi
JA: Hi. How can I help?
Customer: I am looking for help with SQL Query
JA: What's your objective for this SQL project?
Customer: Validating data in time
JA: Anything else you want the programmer to know before I connect you?
Customer: No really Thanks
Hello, and thank you for the question. Sorry to hear about the issue you’re having. Can you please post the details of the assignment? I’ll be happy to review and assist as best I can.
Customer: replied 13 days ago.
Hi Ben
Customer: replied 13 days ago.
Thanks hope you can help me
Customer: replied 13 days ago.
I am new to this
Customer: replied 13 days ago.
I want to impress my boss
Customer: replied 13 days ago.
Will be much appreciated you help

Sure, I just need some more information about the issue you're facing so I can see how I can best assist.

Customer: replied 13 days ago.
Can I put a picture

Sure, anything would help.

Customer: replied 13 days ago.
let me get the info
Customer: replied 13 days ago.
This is the two tables need to be join
Customer: replied 13 days ago.
the code we do is
Customer: replied 13 days ago.
File attached (LSS36MQ)
Customer: replied 13 days ago.
The output is
Customer: replied 13 days ago.
File attached (TP5ZMG6)
Customer: replied 13 days ago.
Now we are comparing the value over two different IDs and field ids

Unfortunately I am going to have to opt out and allow another expert to assist.

Customer: replied 13 days ago.
Looking for when they don't allign
Customer: replied 13 days ago.
compare over time

Thank you for your question. My name is ***** ***** I will be happy to assist you. Are you ready now or did you need a few minutes?

Customer: replied 13 days ago.
In the example if I run
Customer: replied 13 days ago.
File attached (23VG6L1)

Ok, the SQL actually only pulls the data as specified in a query. You also need to build a report for that data to go to. In the report you can place the fields that you want to have it show and put filters, etc. What report software are you using?

Customer: replied 13 days ago.
Shows the values always been the same so they should not be in the output
Customer: replied 13 days ago.
In this case just so happens that the dates do match
Customer: replied 13 days ago.
But we can't assume that will be always the case

Well, that would be a report function. You would filter those out in the report. You can suppress duplicates or add filters. What report writing software are you using??

Customer: replied 13 days ago.
Need to change the query to not show the result without relying adding a filter on what explicit date values
Customer: replied 13 days ago.
Don't want to mention any specific like I'd=xxx or date=xxx
Customer: replied 13 days ago.
Microsoft SQL

Thank you. I can give you the best answer if you tell me what report software are you using? Are you viewing the data directly in SQL??

What program do the pictures show?

Customer: replied 13 days ago.
Read Sql
Customer: replied 13 days ago.
Am
Customer: replied 13 days ago.
Viewing the data directy

Ok, you also need to use a program to generate a report and be able to do this correctly. For example, excel. You can add your database connection to Excel and then do a report that looks at the table but only populates the information you need. Are you using anything like that?

Be careful using SQL directly as you can accidently cause a few problems.

Customer: replied 13 days ago.
Oh I see
Customer: replied 13 days ago.
The plan is to work with Jupyter notebook
Customer: replied 13 days ago.
But they ask me to fix the query
Customer: replied 13 days ago.
I am new and want to impress
Customer: replied 13 days ago.
You help will be enormous
Customer: replied 13 days ago.
Please thanks

Ok, the query should be ok. You can add commands to how have that data there however that will lead to problems.

This is how you would do it in excel. I will give you a way to do it in query in just a second.

https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-excel

Customer: replied 13 days ago.
Thank you Art

In query, you would add this to your Select at the end.

COUNT(*) AS CNT

Then after your grouping entries, you would add this (after all your group part of the query):

HAVING COUNT(*) > 1;

Then you should have another query where you add a MAX functions;

WHERE ID NOT IN

(SELECT MAX(ID) AS MaxRecordID

GROUP BY [YOUR GROUP INFO],

[YOUR INFO 2],

);

Customer: replied 13 days ago.
Sounds great hope it works

Again, I strongly suggest not doing this unless you know exactly what you are doing. I recommend doing it in excel however you would know best :)

Customer: replied 13 days ago.
You seem very knowledgeable
Customer: replied 13 days ago.
Can I ask for email can pay separately
Customer: replied 13 days ago.
Need someone like you in my friend group
Customer: replied 13 days ago.
Actually is only read we allowed

Well, there are no additional fees unless you require us to connect to your computer to help. I am not supposed to give out my email address unless it is for those purposes. However you can request me here again and I would be happy to assist :)

Customer: replied 13 days ago.
Can't do any changes
Customer: replied 13 days ago.
No my work computer no access
Customer: replied 13 days ago.
Ok

Oh, ok. That is actually a good thing. Again, you should probably do this in Excel, Access or my favorite, Crystal Reports.

I mean, its a good thing that you cant edit the database accidently.

Customer: replied 13 days ago.
Thanks Art

My pleasure :)

Customer: replied 13 days ago.
Would it be possible for you to write the entire code
Customer: replied 13 days ago.
I can pay the extra thing

I would have to connect so I can see your database structure however there is no code to write. Once you connect the database to excel you basically just use an excel spreadsheet and excel writes the queries as needed in the background. If you would like I can connect to you and help out or you can try the link I provide that shows you how to connect excel. I would be happy to help you with this project but would need to connect to you.

Customer: replied 13 days ago.
Ok if I want just to show them on this current query
Customer: replied 13 days ago.
I just do the step you told me

Of it is a database that is facing the internet that anyone can access with the credentials, I could do that if you give me access.

Customer: replied 13 days ago.
Unfortunately no Access

Yes, if you want to just do it in query you can do that but you would get better results in excel or crystal reports. You can have it build the query for you and then look at how it did it.

Customer: replied 13 days ago.
But you got the idea about the values
Customer: replied 13 days ago.
in validating in time
Customer: replied 13 days ago.
Orbi can create my own example tables on my personal computer and call you to access it

Yes, however I dont know how the database is structured, what table things come from, and how they are linked. You may not be able to filter them that way but may have to use more than one table.

They would need to match the tables, name and in part the data for us to test. There is no magic formula because it will depend on how the tables are set up and which table you are pulling from.

Customer: replied 13 days ago.
Will listen to your instructions above then

It might be best. Again, I recommend Crystal Reports however that is a paid software, excel is my second favorite for this :)

Customer: replied 13 days ago.
I will give a try tomorrow

Sounds great :)

Customer: replied 13 days ago.
Can I request you again

Absolutely, I would be happy to assist you :)

projectx2501-PHD-DBA, Information Systems Manager
Category: Computer
Satisfied Customers: 1276
Experience: Over ten years experience in information systems management!
projectx2501-PHD-DBA and 2 other Computer Specialists are ready to help you
Customer: replied 13 days ago.
Many thanks Art
Customer: replied 13 days ago.
Talk to you soon
Customer: replied 12 days ago.
Good morning
Customer: replied 12 days ago.
Sorry need help with the query
Customer: replied 12 days ago.
If Art is available many thanks
Customer: replied 12 days ago.
Hi
Customer: replied 12 days ago.
Hello
Customer: replied 12 days ago.
Hello Art
I
Customer: replied 12 days ago.
need your help please

Hello, good morning. I see that we are in different time zones. I am in California so it was midnight when you messaged me. What can I help with?

Customer: replied 12 days ago.
hi
Customer: replied 12 days ago.
can we please review my early request
Customer: replied 12 days ago.
i cant connect to any software like excel
Customer: replied 12 days ago.
can we focus on what i can do on the query

Ok, what error do you get?? Did you review the link I provided?

Customer: replied 12 days ago.
would it be possible to connect on remote assistance and write exactly what you ment on the query
Customer: replied 12 days ago.
on word document

Yes, that would be a good idea. I would need to see the database tables and a lot of other variables.

Or if you send me screenshots, that would work too but you will notice what I mean when I connect. There are just so many variables. I am almost sure we should be looking at another table or that we need visual linking.

Customer: replied 12 days ago.
i paid it- i could not understand what to do with your query if you can explain as well

Sure, as soon as I connect, you can watch me work on it and I will leave you the instructions. It is just that it all depends on the structure of your database tables.

Customer: replied 12 days ago.
sorry just need to deactivate the security

No, you dont have to deactivate anything at all.

Anydesk runs on normal protocols and doesnt install to your computer usually. It runs and I can only connect while open. It uses common ports so no changes needed. It should be allowed to make changes to your computer or I wont be able to do anything that requires elevation.

Customer: replied 12 days ago.
just downloading it now
Customer: replied 12 days ago.
what i need to do

Just open the file that downloaded and give me the numbers you see on your screen.

Customer: replied 12 days ago.

Thank you. You should click on accept now.

Customer: replied 12 days ago.
File attached (T5ZT723)
Customer: replied 12 days ago.
File attached (2ZV6P57)

Thank you, ***** ***** thought I would be connected to the database. Without connecting and seeing the query, where it comes from and the structure, it is hard to determine why something might not be working. Thank you for the pictures. I hope you have a wonderful day.

Customer: replied 2 day ago.
Hello