Recent questions tagged SQL

0 votes

555 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

464 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

479 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

611 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

410 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

533 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

481 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

457 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

516 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

547 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

846 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

784 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

525 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

658 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

439 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

431 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

664 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

725 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

504 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

423 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

685 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

585 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

426 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

650 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

507 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

499 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

614 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

395 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