Recent questions tagged SQL

0 votes

1.1k views

1 answer

sql server - Query Index for Dictionary Based Queries

What would be the most efficient way to query and index for the following: SELECT * Persons.LastName A-D SELECT ... to be more sargable. Thanks 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 - get all day of month then mapping data to specific date

I created a chart that will plot data to show value for present data on specific date with this SQL select substring( ... 1606 29 0 1606 30 0 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Why isn't my PostgreSQL array index getting used (Rails 4)?

I've got a PostgreSQL array of strings as a column in a table. I created an index using the GIN method. But ANY ... ' = ANY (tags)) => 20000 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Select latest records by datetime field

How could i select the latest records by datetime of an SQL Server? Here is the pseudo-code... SELECT Records FROM ... 26/10/2009 10:24:19 pm See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - mssql_connect in PHP does not exist

I've been struggling with this for a while now and I don't know what I'm missing. The error is: call to ... IIS, and Microsoft SQL Server 2008. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Concatenate a selected column in a single query?

I know you can do this, because I've seen it done once before, but I forget where and up until now I ... Thank you in advance for your help! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - How to correctly handle dates in queries constraints

I am currently using the following query to get all the inspections done on june 2010: select inspections.name ... makes a difference. 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 - Partition MySQL table by Column Value

I have a MySQL table with 20 million rows. I want to partition to boost speed. The table is in the following ... ? What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Misnamed field in subquery leads to join

I faced a problem with a data loss, caused by a wrong query. Data restored, but now I'd like to understand ... use an alias. Aliases are good. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - CHECKDB found 0 allocation errors and 218 consistency errors in table 'MyDatabase' (object ID 1509580416)

My database was unexpectedly went into suspect mode. After analyzing I found that this is because of the log ... in database 'CORRESPONDENCE'. 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 - define parameters from an Excel Cell for a CASE WHEN in SQL

I want to be able to define my parameter SA.FiscalWeek in the below code from a cell in Excel SUM(CASE WHEN ... in a CASE WHEN statement ? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - How do I remove repeated column values from report

FROM THIS: Hotel Type Room Guest From To ------------------------- ------ ---- ------------ ... -10 Tonya Harris 23-SEP-10 27-SEP-10 203 204 205 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Select all records don't meet certain conditions in a joined table

Let's say we have two tables here , posts and comments, the relations is one to many, there has a field call ... I done this by a SQL statement? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Ukrainian character change to question mark when insert to table

I have a file saved as Unicode text containing Ukrainian characters, and it got loaded successfully to staging table ... I rectify this error? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - how to delete duplicates from a database table based on a certain field

i have a table that somehow got duplicated. i basically want to delete all records that are duplicates, which is ... one record per Sourceid ? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

sql server - Alternative to STRING_AGG in with SQL

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

0 votes

1.5k views

1 answer

sql server - SSIS 2012: Trim trailing commas from a CSV output

I have a file, I cannot control the output, that has a trailing comma on each data row and not the ... are removed the file processes fine. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Get rid from one column duplicate values in two column select

So, I`ve got two columns t1.NAME and t2.ITEMS, for each neme there can be more than one item assigned to ... connected by t1.id = t2.names_id See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Select all threads and order by the latest one

Now that I got the Select all forums and get latest post too.. how? question answered, I am trying to write a ... ; How can I solve this one? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Fast update of Access data with Excel data using Excel VBA

By "fast" I mean using the UPDATE SQL query as opposed to looping through every recordset. Here I found this ... Access that I want to update. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

sql - ORA-12728: invalid range in regular expression

I want to check if valid phone number is inserting in table, so my trigger code is here: select start_index into ... ... thank you in advance See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - Remove Accents DB2

Does someone knows how to get rid of accents words in DB2 ? I got that one bellow : select UPPER( 'test ... . DB2 Version 11,1 Sincerly See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Is there a way to load text data to database in PostgreSQL?

I want to extract information from a text file (almost 1GB) and store it in PostgreSQL database. Text file is ... and insert it into the table. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server 2008 - Simple Pivot sample

I need the a report of all masterid's but it may only be one on a row.. I know that's a simple thing to do ... ) values (123, 'Pixi', 'Closed') See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - How to connect a localdb from Visual Studio to the published Azure web app?

So i have a localdb set up for my project in Visual Studio but when I publish it to my Azure web app, ... settings but that didn't do anything See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Convert Date Range to Individual Days

A table called VolumeRequest stores the volume requests by accounts for a date range. AccountId StartDate EndDate ... didn't help me. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - SSIS Pass Datasource Between Control Flow Tasks

I'm having troubles solving this little problem, hopefully someone can help me. In my SSIS package I have a ... and ensure they're correct. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Combining INSERT statements in a data-modifying CTE with a CASE expression

My question is some kind of extension to Erwin Brandstetter's excellent answer in this thread on the correct use ... on the device types. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags