I have two tables in SQL Server. Address Points & District Regions Both have geom fields and share common SRID The Address Points have an integer value field. For each district I want to take the …
Tag: sql
postgresql conditionally generating value for each row
I am trying to implement a simple search functionalitu over links.name column. I would like to match keywords against name values and wanted to get the names with more matchings on the top of result. …
Isolate/Sum Data Conditionally Based On Event Sequence
I have a table that tracks events sequentially and calculates the time for each event. What I want to do using the below sample data, is calculate the total number of Time Elapse (Seconds) of all …
Query SQL with similar values
I have to make a query to a base using as a comparison a string like this 12345678, but the value to compare is this way12.345.678, if I do the following query it does not return anything. SELECT * …
Is there a way that i can highlight or colour various table rows based on data entered in textfield?
What i’m trying to do it’s highlight the serial number that i scan from a box of items. So when i scan the S/N. My idea is that the table, which contains the items in the box, change their color. My …
Filtering out non-zero values unless the value is the only one within its group (SQL or R)
I have a data set of record numbers, with multiple values in a column for each record. I would like to produce a table where within each group it returns the minimum non-negative, non-NA value. But if …
Grouping sql result by a specific criteria
i am writing a query that supposed to show for a set of users, what emails he/she received, and if the email was open or not. This is the result of the query: Product | Year | Month | …
Data selected from SQL database from top item in checkboxlist is copied to all Gridview rows
I am trying to create a grid view table where i want to show some selected data from a checkboxlist. THe problem is that whenever i select some data from the checkboxlist, the gridview will only show …
i getting this error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint “foreign_key1”
CREATE TABLE singer( name varchar(50) primary key, email varchar(50) not null, account_number varchar(50) not null, balance int not null ); create table song( id int primary key, …
How to ‘create’ NULL data in Teradata SQL for non existing relations
I have 2 tables, one lists features with a feature value that an account might or might not have (TBL_Feat), the other lists the accounts (TBL_Acct). I’m looking for a query to give me all features …