Is it a good idea to store phone number as a primary key on RDBMS? They are unique to nearly all of us. But my friend suggests it is not a good idea because of the following reasons. What if two …
Tag: sql
Insert stored procedure results into temp table
I have a stored procedure that returns this result: The way I call the stored procedure is: I want to store these results into a temp table so I used insert into like this: But I get an error like this: INSERT EXEC failed because the stored procedure altered the schema of the target table. Answer Hard to say …
Why is my Me. Reference and INSERT INTO causing error?
I am receiving two errors when attempting to create a query which updates my audit log after an update is made to a record. First I am prompted to enter a Parameter Value where I believed my ME. code would point to any record with the current value of field [Corrected Med Ed ID]. Secondly I receive message: S…
Is there an other way to add calculated information to a table?
I have a table on BigQuery with some information and need to create another table with aggregated information by name with columns that have values with some condition. Here is an example of a table: …
How to use LAST_VALUE in PostgreSQL?
I have a little table to try to understand how the LAST_VALUE function works in PostgreSQL. It looks like this: id | value —-+——– 0 | A 1 | B 2 | C 3 | D 4 | E 5 | [null] 6 | F …
I’m going to get the ten day sales report and i want to return 0 if there is not record for each day
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Sp_Rsv_DailyContractReport] @ContractDate datetime =null, @RegisterUsersId varchar(32) = null AS Select …
Why does the number of tuples selected vary in these queries
I am new to DBMS and SQL. While practicing some basic queries i had come across this doubt. Suppose this query’s result is null:select * from table2 b where b.age>50; i.e. there is no age in table2 …
In Hive, how to convert an array of string to an array of numeric numbers
I have a hive table that looks like the following: I want the result to be the following: I need to convert them into an array of float so that I can use them in ST_Constains(ST_MultiPolygon(), st_point()) to determine if a point is in an area. I am new to Hive, not sure if that is possible, any help would
Getting the primacy function for an emolyee
I have this following query to get the primacy for an employee : My output is like below : What I want is to get primacy (primary,secondary, tertiary) to each function like below : The function having the minimal sumOrder will be the primary function and so on. Answer You can use a ROW_NUMBER() ordered by the…
Update column with below query?
How do I write this query to update a column based on the case statement? Answer As commented, you query looks pretty good, apart from these: the ORDER BY clause does not make sense; an UPDATE query does not return any record, so ordering is out of scope for the same reason, you don’t have to alias the …