Recent questions tagged SQL

0 votes

419 views

1 answer

sql - Error "value" does not exist - postgresql INSERT INTO issue

I've created a new table but I'm struggling to insert any data The table looks like the below where the id ... this issue What am I missing?! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

364 views

1 answer

sql - MySQL query finding matches across multiple rows

I have two tables, Data(Name, dataID) and Attributes(Name, attributeID, dataID) with a one-to-many ... more than very basic selects. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

449 views

1 answer

sql - How to partition postgres table using intermediate table

I am using postgres 10 db. I am having Customers table consisting of following columns custid (primary key), ... another partition of last month See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

438 views

1 answer

sql - Pivot table with non-cardinal values

I have a table that looks like Test Reader Result 1 John 1.6 1 Jack 5.2 2 Ursula 2.5 3 Albert 3.0 2 ... of possible columns (3). Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

343 views

1 answer

sql - Procedure With IN Parameter

Can you please help me, i want to create a procedure that allows me to send a parameter to put it in ... the multi parameters to the procedure. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

483 views

1 answer

sql server - Remove ASCII Extended Characters 128 onwards (SQL)

Is there a simple way to remove extended ASCII characters in a varchar(max). I want to remove all ASCII characters ... a string in T-SQL? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

394 views

1 answer

sql server - best way to "glue" columns together

I need to combine columns from about 15 tables in one large table. Something the following works. But it takes very ... order by t1.empid, t2.rn See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

494 views

1 answer

sql - How to convert "2019-11-02T20:18:00Z" to timestamp in HQL?

I have datetime string "2019-11-02T20:18:00Z". How can I convert it into timestamp in Hive HQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

360 views

1 answer

sql - How to create select dynamic fields from a table in mysql?

I have query join in select statement like this : select a.item_number, total_quantity, store, factory from ( ... still confused to do it See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

350 views

1 answer

sql - How do i merge two or more rows based on their foreign key?

I have three tables which are: A(a1, a2, a3) //This tbl (Table) can have multiple instances of a1 ... | DosageSrength | Unit | ControlStatusID See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

321 views

1 answer

sql server - How to query SQL Table and remove duplicate rows from a result set

I know this is simple... Please advise on how I can get a result set of rows 1, 9, 18, and 21 (based on the attached image)?? Thanks, Brad See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

597 views

1 answer

sql - Insert inserted id to another table

Here's the scenario: create table a ( id serial primary key, val text ); create table b ( id serial primary key, ... . Any way to work this out? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

508 views

1 answer

sql server - How to connect to a sql database using classic asp?

Could someone please help solve this problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

462 views

1 answer

sql server 2005 - SQL Group and Sum By Month - Default to Zero

I am currently grouping and summing inventory usage by month: SELECT Inventory.itemid AS ItemID, SUM(Inventory. ... 13188 20 12 December See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

324 views

1 answer

sql server - Open XML document and return for every row, based on row's path to xml file

I'm pretty new to using XML with TSQL, and recently ran into an issue that I can't think around and need ... I can't think through right now. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

466 views

1 answer

sql - MySQL Find Related Articles

I'm trying to select a maximum of 10 related articles, where a related article is an article that has 3 ... ? Any help is greatly appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

451 views

1 answer

sql - ORACLE - Select Count on a Subquery

I've got an Oracle table that holds a set of ranges (RangeA and RangeB). These columns are varchar as they ... ? Any help is much appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

541 views

1 answer

sql - Crosstab View in mySQL?

I dont know I titled this correct, but let me explain what i am looking for. I have two tables. Clients ... in this view. Thanks in advance. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

535 views

1 answer

sql - How to fill missing dates and values in partitioned data?

How to fill missing dates and values in partitioned data? I'm having a lot of trouble Googling this as most of the ... /2014 1 B 01/09/2014 1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

531 views

1 answer

sql server - Hamming weight/population count in T-SQL

I'm looking for a fast way to calculate the hamming weight/population count/"the number of 1 bits" of a ... article about the hamming weight. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

365 views

1 answer

sql - Generate date range from two date columns

The source table it's following: Id start_date end_date field1 1 01/03/2019 07/03/2019 text1 2 10/04/2019 ... populate this table ? Thank you See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

438 views

1 answer

sql server - Using SSIS, How do I find the cities with the largest population?

I have a dataflow task with information that looks something like this: Province | City | Population ----------- ... I do with the City column? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

392 views

1 answer

sql - ST_HexagonGrid geom vector to find all points

I was reviewing this function in PostGis https://postgis.net/docs/manual-dev/ST_HexagonGrid.html 1) What I don' ... 12076.9943663072 (6 rows) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

444 views

1 answer

sql - Stored procedure, pass table name as a parameter

I have about half a dozen generic, but fairly complex stored procedures and functions that I would like to use in ... am using SQL Server 2005. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

620 views

1 answer

sql - ORA-00904 invalid identifier on decode alias

I am running into the error stated in the Title when I attempt to use the alias of a decode in my ... it work differently in this situation? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

496 views

1 answer

sql server 2008 - Linq selecting range of records

var q = (from Comments in db.tblBlogComments where Comments.blogID == this.ID orderby Comments.date descending ... load any redundant data? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

sql server - How to pass SSIS variables in ODBC SQLCommand expression?

I'm trying to load incremental data from ODBC server to SQL server using common table expression. When running ... server using ssis variables? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

395 views

1 answer

sql server - WildCards in SSIS Collection {not include} name xlsx

I have a process built in SSIS that loops through Excel files and Import data only from those that include name ... ? Thanks for help! Matt See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags