Recent questions tagged SQL

0 votes

424 views

1 answer

sql server - Check if column value exists in another column in SQL

I need a SQL query that compares two values and returns an ID. I have this table: ID Calling_ID Called_ID 1 27 10 ... would return 88, 30, 40. See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql server 2012 - Code first custom SQL migration timeout exception

I am trying to create FULL TEXT index using Entity Framework Migration by executing custom Sql. My migration class ... problem is still there. See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql - Conditional WHERE clause with CASE statement in Oracle

I'm brand-new to the Oracle world so this could be a softball. In working with an SSRS report, I'm passing in a ... :stateCode)) (else 0) end) ; See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Select distinct values from 1 column

I want to select distinct values from only one column (the BoekingPlaatsId column) with this query: SELECT MAX( ... do that in SQL Server? See Question&Answers more detail:os...

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

0 votes

296 views

1 answer

sql server - Subtraction between two sql queries

I have 2 queries in MS SQL that return a number of results using the COUNT function. I can run the the first ... as a function but no luck. See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql server - Sql error on update : The UPDATE statement conflicted with the FOREIGN KEY constraint

I have a table called patient_address, which reference a PK key in patient table. But if i try to run one ... know the possible cause ? Thanks. See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - Return zero if no record is found

I have a query inside a stored procedure that sums some values inside a table: SELECT SUM(columnA) FROM ... WHERE clause is not satisfied? See Question&Answers more detail:os...

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

0 votes

340 views

1 answer

sql - Using the correct, or preferable, not equal operator in MySQL

Which of the two (semantically equivalent) ways is preferable to test for inequality? 'foo' != 'bar' ( ... for the obvious NULL cases). See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - mysql SELECT IF statement with OR

The following works - returns Y when chargeback equal to 1 else it defaults to N IF(fd.charge_back = 1, 'Y' ... 'Y', 'N') AS customer_compliment See Question&Answers more detail:os...

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

0 votes

236 views

1 answer

sql - Can there be constraints with the same name in a DB?

This is a follow-on question from the one I asked here. Can constraints in a DB have the same name? Say I ... on how to work around it? See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql - Automate process by running excel VBA macro in SSIS

Recently, I have a project need to automate a process by combining SSIS package and excel VBA macro into one. ... be achieved! Thanks a lot. See Question&Answers more detail:os...

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

0 votes

278 views

1 answer

sql server 2005 - Passing multiple values for one SQL parameter

I have a CheckBoxList where users can select multiple items from the list. I then need to be able to pass ... help would be much appreciated! See Question&Answers more detail:os...

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

0 votes

250 views

1 answer

sql - Saving form data to an existing XML-file using PHP

Okay, so here's what I want to do (NOTE: I'm stil new to PHP): I have a registration form for movies ... 's relevant for answers on this matter. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - Correctly inserting literals in PL/PgSQL EXECUTE dynamic queries

The following is part of a plpgsql function. The problem is that the result of source_geom and target_geom is a ... I can solve this problem.? See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql server - Why insert TSQL statement block when transaction isolation level for another transaction is serializable with non-conflicting filter?

Serializable transaction isolation levels avoids the problem of phantom reads by blocking any inserts to a table in a ... -- Why this blocks? See Question&Answers more detail:os...

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

0 votes

439 views

1 answer

sql server 2008 - Creating a stored procedure via C#

I'm trying to create a seed DB in my web app, and i was able to create the DB, populate the tables, ... (); connection.Close(); } } See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Pivot table in MySQL - convert to pivot table with values in varchar format

i would like convert data from Table1 as you can see on first picture on data in Pivot_table. Is possible ... Geography C Thanks for your help See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql server - SQL: Dynamic view with column names based on column values in source table

Given the two sample tables here: Tickets Table ID User Description 0 James This is a support ticket 1 Fred This ... not. Is this even possible? See Question&Answers more detail:os...

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

0 votes

229 views

1 answer

sql - How to deal with mutually dependent inserts

I have a model that defines mutually recursive tables: Answer questionId QuestionId text Question text correct AnswerId What do ... (id); ```sql See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - Counting number of records hour by hour between two dates in oracle

I need a SINGLE query that does this sequence in oracle. select count(*) from table1 where request_time < timestamp' ... 318 2012-05-19 11 282 See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Window Functions - Running Total with reset

I am using SQL Server 2012 to build an inventory planning / reorder engine. I have a bunch of dated transactions, ... ? :) Thanks in advance! See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql server - How to run a database script file from Delphi?

I want to do the following. 1) Create a database. 2) Run a script when creates tables, stored procedures, ... fails it will generate exception?) See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - PIVOT with MONTH()

How can I pivot for a column with dates as month? Example: Data: |-----------------------------------| | ... -----------------| Thank you :) See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

sql - Multiple yet mutually exclusive foreign keys - is this the way to go?

I have three tables: Users, Companies and Websites. Users and companies have websites, and thus each user record ... there another way to go? See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

sql - Split a string into rows using pure SQLite

Using SQLite, I'd like to split a string in the following way. Input string: C:UsersfidelDesktopTemp and have the ... do this in pure SQLite? See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Export DB with PostgreSQL's PgAdmin-III

How to export a Postgresql db into SQL that can be executed into other pgAdmin? Exporting as backup file, doesn't ... of which version it is? See Question&Answers more detail:os...

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

0 votes

350 views

1 answer

sql server 2005 - How to create an error log or custom error log within an SSIS Package?

I am working on SQL 2008 - SSIS Package. I am executing the package from C# code. It's simple Flat File ( ... or Log File inside the Package? See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - C# SQLServer retrieving results and place in a .csv format

I had a look on the site and on Google, but I couldn't seem to find a good solution to what I'm trying ... on how to go about this please! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags