Recent questions tagged SQL

0 votes

948 views

1 answer

sql - oracle query sequential summation per rows

I would like to ask to make a query like the following table? -------------------------------- ... ). how to create query with results as above. See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

sql server - Get all employees under manager with CTE

I have a table which has employee details EmpId ManagerId Level Value 1 0 5 CEO 2 1 4 EMP 3 1 4 ORG 4 2 3 ... 0) How can I achieve the same? See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

sql - How to pass a parameter from vb.net

I have a Program that will auto run each night, run a query, and email results. In my program I am ... (ReportCategoryID = 62)) AS unlimitedtbl See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Extract SP and DDL Scripts in sybase Server

How do I extract DDL, Stored Procedures (SP) and other database scripts from Sybase ASE. See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

sql server - SQL Table Size And Query Performance

We have a number of items coming in from a web service; each item containing an unknown number of properties. We ... a rule of thumb? Thanks. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - PostgreSQL Reverse LIKE

I need to test if any part of a column value is in a given string, instead of whether the string is part ... forums but none of them worked. See Question&Answers more detail:os...

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

0 votes

976 views

1 answer

sql server - How to compute the moving average over the last n hours

I am trying to compute efficiently (using SQL Server 2008) the moving average of the ProductCount over a period of 24 ... :00', 'Apple', 6000) See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

sql - How to write a mysql function with dynamic table name?

I'm trying to write a my sql function doing the following things: 1- get the table name used in join as a ... with static table name by the way. See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

sql - Getting the sum of a datediff result

I have a SQL statement (MS SQL Server 2005) that does a simple calculation of the differences in dates on a ... to return. Thanks in advance See Question&Answers more detail:os...

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

0 votes

910 views

1 answer

sql server - SQL connection in UWP app

I have am existing project that runs on windows, mac, ios and android. I'm looking for a way to make a ... I get access to databases in UWP? See Question&Answers more detail:os...

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

0 votes

869 views

1 answer

sql server - T-SQL: Separate String Into Multiple Columns

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

0 votes

952 views

1 answer

sql server - SQL function for last 12 months

I am looking for a SQL-function that gives the last 12 months with Start Date and End Date. Say you pick 10. ... 12-20 Anyone know what to do? See Question&Answers more detail:os...

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

0 votes

791 views

1 answer

sql - outputting values from database into html table PHP

I have the code below which grabs data from a table based on what week the user has chosen, there are only 2 ... 5, 'Supper & Snacks'); } See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Count CLOB Duplicates in a large Oracle Table

I have an Oracle database table LOG_MESSAGES with a CLOB column called MESSAGE. Some of the rows contain the same ... in advance for your help. See Question&Answers more detail:os...

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

0 votes

871 views

1 answer

sql - How to get rid of #temp tables from the query

I have three queries that put data in their respective #temp tables. Later, In one query those #temp tables are ... the third query!! Thanks Jai See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

sql - Find groups with matching rows

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

0 votes

897 views

1 answer

sql server - T-SQL Query : Getting Child nodes of a parent

I have a table with the following schema : ID , CatID, ParentCatID, SiteID I want to get all the sites ... category and all its descendants. 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 - bulk insert a date in YYYYMM format to date field in MS SQL table

I have a large text file (more than 300 million records). There is a field containing date in YYYYMM ... type? kind regards maciej pitucha See Question&Answers more detail:os...

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

0 votes

930 views

1 answer

sql server - Simplify Dynamic SQL Pivot Table

I have written a Dynamic Pivot Table Query based on the following. Here is a SQL FIDDLE for reference. CREATE ... AS pvt ORDER BY pvt.idnumber See Question&Answers more detail:os...

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

0 votes

819 views

1 answer

sql server - How to find diff between two string in SQL

I have two strings, I want to get difference between contents of two strings in SQL ?? for example, Declare @String1 ... two strings as "a,c,d" See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

sql - Join four tables involving LEFT JOIN without duplicates

I want to join four tables with null values and without duplicates and afterwards translate it into an ... translate it to SQLAlchemy? See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

sql - How to add functionality for ComboBox <Select All> in Microsoft Access forms

So I posted a question the other day about an access form that needed to have a "Select All" option added ... All" option for both ComboBoxes? See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

sql server - sql query to bring last letter in a string to first letter position

I have a table name called 'Supervisor' from a table JobData in a MSSQL database. In this 'Supervisor' column ... to all the remaining records. See Question&Answers more detail:os...

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

0 votes

874 views

1 answer

sql server - Delimited Function in SQL to Split Data between semi-colon

I have the data below. I'm only interested on program B. How do I change it into the table below using SQL ... ' Thanks guys for your help. Adhi See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

sql - Select unique column names from a list of joined tables

I have a list of tables that can be joined together by the same PK column. Since this list of tables can vary ... [int] NULL ) ON [PRIMARY] See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

sql - Mysql query search a string in all columns of a table

I wonder how I can mount a SQL as portable as possible to query for all columns of a table for a ... table::text ~~ '%augusto%2010%text%' See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

sql - Pivot a table on a value but group the data on one line by another?

My table CREATE TABLE #table ([Indicator] int, [Scenario_code] smallint, [period] nvarchar(50), [Value] int, ... started using SQL Server 2012. See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

sql server - Insert Data into MSSQL DB using PHP

Hello there am trying to insert data into MSSQL using PHP. I have tried many times to figure out what ... 110 Error querying MSSQL database See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags