I have data source like this: 1°18’19.74″N But when I insert it to Azure data warehouse it look like this: 1�18’19.74″N
Tag: database
Avoiding redundancy in database tables sql mysql
I have a question please. I am developing an online mall website. I have an orders table.. I have put the product_id as an attribute in order to know which product is ordered. In the customer’s purchase history page, I need to present all the orders purchased by the customer, including the product title…
SQL SERVER: Reset running total according to two conditions
I need to reset the running total when two conditions are met. See update below for clarification. Using SQL SERVER UPDATE 1: The Data: The data is partitioned by item number and ordered by the week of the year. Therefore, Item_Number = the item number. Cartons = the number of cartons sold that week per item …
How to update specific column with values from another table
I have a table called “bug_table” that looks like this: and a table called “bug_revision_table” that looks like this: Now comes the question: How can I modify the timestamp of each id from the first table with the latest/most recent one from the second table? As you can see, each bug_i…
How to create a table address and query it by states?
How can I create a table with following schema: I wrote the above query for creating the table. But I’m not able to link this table to another table for the query shown below and fetch all state names and total of account balance for the users belonging to those states. Answer You should be able to use …
Select everything from SQL database except duplicate
I have a database that looks like this: It measures how many times participant1 and participant2 have shaked hands. I want to select the amount of times total people have shaken hands (without the duplicates counted). So in this example the output would be like this: Can anyone help me with the SQL Statement …
MySQL find column name where it’s value match the pattern
How to search the entire database for column name equal to my rule and specific value as well. Let’s say that i want to search for column name like voucher where it’s value contain that word value10 So far i can find the column name but i don’t know how to match with value as well. So the en…
Problem with connecting Crystal Reports to SQL Server
I have a problem I am a project worker vb.net 2015 with sql After I cleared the project and tried the project at the client An error appears when the reports are shown by the crystal Report whereas mserver = server mdb = the name of the database muser = username sql mpass = sql password They are retrieved fro…
How to retrieve single record for a column based on SQL Server CASE statement
I am trying to write a SQL Server CASE statement to retrieve a student’s category based on the following condition. If the category column from the student_category table has both values ‘X’ and ‘Y’ for a student_id value from the student table, then only display the record where…
Display all duplicated values and their IDs from a table (SQL)
I’m using SQL Sever. I have a table that looks like this: Is there a way I can retrieve all the duplicated values only? Not just one of them, but all. This is the desired output: Answer This works in SQL Server.