Recent questions tagged Sql

0 votes

411 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

356 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

441 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

430 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

336 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

475 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

387 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

486 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

353 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

340 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

314 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

590 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

500 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

455 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

317 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

459 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

443 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

534 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

527 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

524 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

358 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

429 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

384 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

437 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

613 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

488 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

388 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