Recent questions tagged sql

0 votes

813 views

1 answer

sql server - How to show blank record in sql if duplicate rows exists

My SQL Query Results, EmployeeID EmployeeName Department 1 John Sales 2 Robert Sales 3 Sudhir Sales 4 Roj ... 3 Sudhir 4 Roj Development See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

sql - Weekly total sums

I have a table in a PostgreSQL database containing dates and a total count per day. mydate total 2012-05-12 12 2012- ... 2012-05-30 2012-05-31 0 See Question&Answers more detail:os...

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

0 votes

880 views

1 answer

sql server - To change date format in sql

I have date in mm/dd/yyyy format in database.I want to display in form as dd/mm/yyyy. Can anybody help?I want to get time along with date. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - How to concatenate values with same id in sql

My table contains the details like with two fields: User ID Rolename 1 Editor 1 Reviewer 7 EIC 7 Editor 7 Reviewer ... ? How to write the Query? See Question&Answers more detail:os...

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

0 votes

872 views

1 answer

sql - Date column arithmetic in PostgreSQL query

I have two tables that look like this: CREATE TABLE table1 (user_id int, the_date date); CREATE TABLE table2 (user_id int ... I am using PG 8.4. See Question&Answers more detail:os...

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

0 votes

941 views

1 answer

sql - Fixing holes/gaps in numbers generated by Postgres sequence

I have a postgres database that uses sequences extensively to generate primary keys of tables. After a lot of ... other columns as ForeignKeys. See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

sql - When can we use an identifier number instead of its name in PostgreSQL?

I am developing a software need to remove user provided numbers but unfortunately some elements like column names (unrelated ... by 1,2,3; See Question&Answers more detail:os...

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

0 votes

957 views

1 answer

sql - How do I return a jsonb array and array of objects from my data?

I have the following table: CREATE TABLE mytable ( id serial PRIMARY KEY , employee text UNIQUE NOT NULL , data jsonb ); ... "us", "value": 76}] See Question&Answers more detail:os...

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

0 votes

817 views

1 answer

sql server - About 'CASE' a conversion failure

While using 'CASE' I encountered with problem that I'D never heard. The problem is so: I'M using 'CASE' statement ... 11/2011' to data type int. See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

sql - Convert Row to Column

How can I convert this table:- INV DESCRIPTION AMOUNT -------------------------- 1001 CHARGES 100 1001 ... -- 1001 100 30 20 1002 215 32 25 See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

sql - Transpose rows to columns based on ID column

I'm currently running SQL Server 2008 and trying to get the following subquery data: ID | Field Name | Field ... Thanks in advance! Cheers, Si See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

sql server - How do I change my asp.net membership database from express to standard sql?

I am building an ASP.NET 3.5 (C#) application and I plan to use the membership and roles security. I want to ... . How would I go about this? See Question&Answers more detail:os...

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

0 votes

817 views

1 answer

sql - No value given for the required parameter

I am trying to run the qry below against an access database and I get an error No value Given ... , Between90180, Between180365, GreaterThan365 See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

sql - MySQL SELECT function to sum current data

I have a query that return something like this: | ID | Val | | 0 | 10 | | 1 | 20 | | 2 | 30 | But ... it on the query (I'm using MySQL)? Tks See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

sql - MySQL count consecutive dates for current streak

Given a MySQL table with timestamp and user columns, I'd like to be able to count how many consecutive days ( ... a result broken down by user. See Question&Answers more detail:os...

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

0 votes

739 views

1 answer

sql - Why an cursor opened for a select with ORDER by does not reflect updates to the subsequent table

I have set this little example of a strange behavior SET NOCOUNT ON; create table #tmp (id int identity (1,1 ... Is this an intended behavior ? See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

sql server 2005 - Hebrew encoding in sql server2005

i try this code in sql server 2005 declare @userName nvarchar(50) set @userName='???2' print @userName but i get ... the Hebrew char to "?" 10x See Question&Answers more detail:os...

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

0 votes

883 views

1 answer

sql - Exporting data from a view

I am running the EXPORT WIZARD to a flat file on SQL Server 2008. I am providing a query ... 0xC0207016 (Microsoft.SqlServer.DTSPipelineWrap) 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 - Format excel destination column in ssis script task

Is it possible to format a column in an excel destination in ssis before generating it? I'm thinking a ... format within the excel spreadsheet See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

sql server - Mimic group_concat() combined with GROUP BY

I have a table 'booking' like this: booking_id, date, client, sponsor I'm trying to get a monthly summary: ... Big kudos for the answer :-) See Question&Answers more detail:os...

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

0 votes

934 views

1 answer

sql - Can't create Informix stored procedure using ISQL command?

I'm having trouble creating this stored procedure on IBM Informix Dynamic Server Version 10.00.FC9 (see Jonathan ... 2:30 pm type format. See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

sql - Using table just after creating it: object does not exist

I have a script in T-SQL that goes like this: create table TableName (...) SET IDENTITY INSERT ... programmatically from my C# application. See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

sql - Creating json from Oracle database table

Hi I have to create json file from Oracle table. I have data in the below form. I want data in this ... array and return to calling environment See Question&Answers more detail:os...

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

0 votes

848 views

1 answer

sql - Oracle Partitioned Sequence

I'm trying to see if exists something to create a sequence with partition logic. I need a sequence number that ... this 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 - Join query with only columns that have all values in `in` clause

I'm creating a simple filtering system for my website. I have a many to many relationship between venues and ... dynamic from query to query. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql server - How to execute a sql script file in a Kubernetes Pod?

I wanted to create a SQL Server database in Kubernetes pod using a SQL script file. I have the SQL script ... it after starting the container? See Question&Answers more detail:os...

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

0 votes

924 views

1 answer

sql - SPOOL command doesnt save result in query

I'm using SQL Developer and I'm trying to save result of a query into the text file using spool command. spool D ... it. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

5.8k views

1 answer

sql server 2005 - sql to pick apart a string of a persons name and output the initials

how can i get SQL to take a sting and return the first letter of each word passed into it. I want to use ... ...mname) words i am using sql2005 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags