Recent questions tagged SQL

0 votes

510 views

1 answer

sql - Using PIVOT to Flip Data from Wide to Tall

I have a table that is rather wide that I would like to convert to tall. The data currently resides like this: ... 't seem to figure this out. See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql server - How to execute SQL statements saved in a table with T-SQL

Is it possible to execute a SQL statement Stored in a Table, with T-SQL? DECLARE @Query text SET @Query = ... running a MSSQL 2005 enviroment) See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

sql server - Using SQL to transpose/flatten XML structure to columns

I am using SQL Server (2008/2012) and I know there are similar answers from lots of searching, however I ... me! Any help gratefully received!! See Question&Answers more detail:os...

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

0 votes

575 views

1 answer

sql - Rails, Ransack: How to search HABTM relationship for "all" matches instead of "any"

I'm wondering if anyone has experience using Ransack with HABTM relationships. My app has photos which have a habtm ... ".* FROM "photos" " See Question&Answers more detail:os...

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

0 votes

357 views

1 answer

sql server - SQL Syntax to Pivot multiple tables

I have spent the past couple of days working on this and am going around in circles. My question is ... discussions. Thank you in advanced. See Question&Answers more detail:os...

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

0 votes

486 views

1 answer

sql - Oracle insert failure : not a valid month

I'm trying to import data from an .xlsx spreadsheet which contains date columns. In those columns, dates are ... change it to "AMERICAN" ? See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

sql server - How to return all records if parameter is null

The following is my SP: Alter PROCEDURE GetList ( @FromDate date = null, @ToDate date = null ) AS Select * FROM ... records. How would I do it? See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql - Insert Data From One Server To Another?

If I want to run this sort of query in SQL Server, how can I do the same query from one server I am ... .[dbo].[TableName] Is this possible? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

sql - Reordering an ordered list

I have a following SQL table with data ProductList id order productname 79 1 name1 42 2 name2 67 3 somename 88 ... update every record under 3. See Question&Answers more detail:os...

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

0 votes

509 views

1 answer

sql - Recursion On Database Query to get hierarchical result using Hibernate - Java

I have a table in my Oracle database with child parent relationship like - What I need is to access the list of ... in java. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

sql - Oracle dynamic DESC and ASC in order by

Order by is dynamic but the sort order is static. SELECT ... Order By CASE WHEN InputParam = 'PRICE' THEN ... order dynamic in the above query? See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

sql - How to create tables with N:M relationship in MySQL?

Let's say I have this two tables: Store and Product. I want my store to have a list of products. How can I ... to finish, can you guys help me? See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql - Retrieve Rank from sqlite table

Say I have a table in an sqlite DB with two fields: name and age. Bob|40 Rob|50 Zek|60 How can I ... ranked 133455 (by age). Thanks, Colorado See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

sql - Using guid in sqlite select where guid is stored in the sqlite db as binaries

I have a table Employee in the SQLite database. Whose primary key is "ID" of GUID type. I try to find the ... should I write the query? Thanks, See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql - Order by Maximum condition match

Please help me to create a select query which contains 10 'where' clause and the order should be like that: ... record should be at bottom. See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Reason for System.Transactions.TransactionInDoubtException

I have 2 Jobs that read and produce data in a Sql Server Database. Every once in a while the jobs crash with ... find the root of this error? See Question&Answers more detail:os...

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

0 votes

613 views

1 answer

sql - ON UPDATE CURRENT_TIMESTAMP and JPA

I have an entity with fields @Temporal(TemporalType.TIMESTAMP) @Column(name = "edit_timestamp", columnDefinition="TIMESTAMP ... is not updated? See Question&Answers more detail:os...

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

0 votes

682 views

1 answer

sql - How to select all hours between two dates?

declare @minDateTime as datetime; declare @maxDateTime as datetime; set @minDateTime = '2014-01-13 02:00:00'; set ... 2014-12-31 14:00:00 See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql server 2005 - Evaluate in T-SQL

I've got a stored procedure that allows an IN parameter specify what database to use. I then use a ... * FROM myserver.mydatabase.dbo.MyTable See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - Rounding issue in LOG and EXP functions

I am trying to perform cumulative multiplication. I am trying two methods to do this sample data: DECLARE @TEST ... a fix for this problem? See Question&Answers more detail:os...

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

0 votes

641 views

1 answer

sql - How to split comma separated string inside stored procedure?

How to split comma separated string into strings inside store procedure and insert them into a table field? Using Firebird 2.5 See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

sql - MySQL SELECT INTO OUTFILE to a different server?

I have a shell script on server a. The script spits out a csv file to a local directory. The problem ... there something like that for outfile? See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql server 2008 - SQL - Pivot table and group by not working

I have a table as follows: Product #users Date Count Type prodA 29 2013-02-27 113 Document prodA 31 2013-03 ... within the first WITH AS? Thanks See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql - Unsupported SubQuery Expression : Correlating expression cannot contain unqualified column references

In Hive the following query fails : Select a,b,c from t1 where a in (0,100) AND b in (select b from ... can you generalize the error here .. See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - 2PL, Rigorous vs Strict Model, Is there any benefit?

In 2PL (two phase locking), what advantage(s) does the rigorous model have over the strict model? I) There is no ... why all of this is false? See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

sql - Performing a WHERE - IN query in CouchDB

I would like to query for a list of particular documents with one call to CouchDB. With SQL I would do ... by either _id or another field? See Question&Answers more detail:os...

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

0 votes

569 views

1 answer

sql - Oracle 10g express home page is not coming up

I installed Oracle 10g express. Installation went well, But the home page is not coming up. I can connect ... Have anybody faced this issue? See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql server - How to avoid UPDATE statement locking out the entire table when updating large number of records

I am fairly new to locks and hints. I have a table with very frequent SELECT and INSERT operations. The ... locked out during this update. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags