Recent questions tagged SQL

0 votes

493 views

1 answer

sql - Interesting tree/hierarchical data structure problem

Colleges have different ways of organizing their departments. Some schools go School -> Term -> Department. Others ... of doing things here. See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

sql - How to make comment reply query in MYSQL?

I am having comment reply (only till one level) functionality. All comments can have as many as replies but no ... how I can do that? Thanks See Question&Answers more detail:os...

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

0 votes

670 views

1 answer

sql - AspenTech InfoPlus 21 - How to connect and query data

I will be given access to an AspenTech InfoPlus 21 endpoint, but the systems seems to be quite legacy and ... help would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

758 views

1 answer

sql - Self Join to get employee manager name

Hello I have a Employee Table with following columns Emp_id, Emp_Name and Mgr_id. I am trying to create a view ... [PRIMARY] ) ON [PRIMARY] See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

sql - How to use parameters with RPostgreSQL (to insert data)

I'm trying to insert data into a pre-existing PostgreSQL table using RPostgreSQL and I can't figure out ... just missing something obvious... See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

sql server - CTE and FOR XML to generate nested XML

I have an adjacency list in the DB and want to deliver the data in XML format to the client through a SQL ... : ... WHERE ParentPageId IS NULL See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Spark Dataframe Nested Case When Statement

I need to implement the below SQL logic in Spark DataFrame SELECT KEY, CASE WHEN tc in ('a','b') ... case when statements in Spark DataFrames? See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

sql - SSRS Report Builder - Only Show Header On First Page (With Page Numbers)

So I am running into the problem where my report header is being displayed on every page, but I only want ... any solution to this problem? See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

sql - Error Importing Azure bacpac file to local db error incorrect syntax near EXTERNAL

When importing db fro azure bacpac file to local sql server 2016 I'm geting the following error. Error SQL72014 ... ); (Microsoft.SqlServer.Dac) See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

sql - PostgreSQL recursive with

I need help with a recursive query. Assuming the following table: CREATE TEMPORARY TABLE tree ( id integer ... 's parent-child relationships. See Question&Answers more detail:os...

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

0 votes

639 views

1 answer

sql server - Deleting database from C#

I have an MDF file that I'm attaching to my local SQL server during testing with MSTEST and I don't want to have ... Refresh(); db.Drop(); }); See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

sql - Drop all temporary tables for an instance

I was wondering how / if it's possible to have a query which drops all temporary tables? I've been trying ... on a named basis? Thanks! See Question&Answers more detail:os...

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

0 votes

651 views

1 answer

sql - MySQL Select First Day of Year and Month

How to find first day of year in SELECT? SELECT `DATE`,`SomeValue1`,`SomeValue2` FROM `SomeTableName` WHERE (`DATE` >= ... -%m-01') AND NOW() ) See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql server 2005 - SQL group by day, show orders for each day

I have an SQL 2005 table, let's call it Orders, in the format: OrderID, OrderDate, OrderAmount 1, 25/11/2008, ... stack limits me to 100 rows)? See Question&Answers more detail:os...

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

0 votes

845 views

1 answer

sql - Merge Multiple Databases into a Single Database

All, I have to create a single database which has a basic schema. This database is going to be large (100GB ... database)? Thanks for your time. See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

sql - Check if stored procedure is running

How to check if a stored procedure or query is still running in SQL Server? Ideas I've thought of having a ... fails or the system is restarted See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

sql server - Convert datetime value from one timezone to UTC timezone using sql query

I have a datetime value. That datetime value may be in any timezone like 'Eastern Standard Time' or 'India Standard ... how can I convert that? See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

sql - How do you match multiple column in a table with SQLite FTS3?

Lets say I have a table with columns A , B , C , D and I want to do a match on column A and C ... get around this? Thanks for your suggestion! See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

sql server - sp_send_dbmail executed from job fails with query result attached as file

I have faced with the following issue: when trying to send email with results of query attached as file, using ... 'test.csv' Any suggestions? See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

sql server - SQL Query aggregate may not appear in WHERE clause

I have this SQL statement and SQL Server is giving me the following error: An aggregate may not appear in ... does not like aggregated amounts. See Question&Answers more detail:os...

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

0 votes

584 views

1 answer

sql - Is it possible to execute a stored procedure over a set without using a cursor?

I would like to execute a stored procedure over each row in a set without using a cursor with something ... if possible (company standards) See Question&Answers more detail:os...

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

0 votes

607 views

1 answer

sql - How to select rows having column value as null?

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

0 votes

897 views

1 answer

sql - Pivot / Crosstab Query in Oracle 10g (Dynamic column number)

I have this table view UserName Product NumberPurchaces -------- ------- --------------- 'John ... development time so this has to be dynamic See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

sql server 2005 - Error:The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect

I am using Windows 7 Netbeans IDE 7.1.2 SQL Server Management Studio Express 2005 JDK1.6 I am getting the ... Browser Service both are running. See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

sql server - How do I avoid dynamic SQL when using an undetermined number of parameters?

I have a StackOverflow-like tagging system for a database I'm working on. And I'm writing a stored procedure ... 'color' and 'saturation' tags. See Question&Answers more detail:os...

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

0 votes

486 views

1 answer

sql server - I have data about deadlocks, but I can't understand why they occur

I am receiving a lot of deadlocks in my big web application. How to automatically re-run deadlocked transaction? ( ... ? Please help. Thank you See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

sql - Why does the SqlServer optimizer get so confused with parameters?

I know this has something to do with parameter sniffing, but I'm just perplexed at how something like ... parameter copying runs instantly. See Question&Answers more detail:os...

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

0 votes

513 views

1 answer

sql server - Best pattern for Constants in SQL?

I have seen several patterns used to 'overcome' the lack of constants in SQL Server, but none of them seem ... as per Remus answer and comment? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags