Recent questions tagged sql

0 votes

752 views

1 answer

I've tried so hard to understand how to create a pivot table in SQL, but I can't manage it! I ... @DynamicPivotQuery Thanks for any help, Henry See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

sql - Can we call a stored proc from a function?

Can we call a stored procedure from a function in SQL? What's the reason? See Question&Answers more detail:os...

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

0 votes

737 views

1 answer

sql server - Number of weeks and partial weeks between two days calculated wrong

Why is this returning 4 instead of 6? SET DATEFIRST 1 SELECT DATEDIFF(WEEK, CAST('2017-01-01' AS DATE), CAST ... case above answer should be 6. See Question&Answers more detail:os...

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

0 votes

650 views

1 answer

sql - Import CSV File Error : Column Value containing column delimiter

I am trying to Import a Csv File into SQL SERVER using SSIS Here's an example how data looks like ... are not imported Correctly Any suggestions See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

sql - How to calculate between different group of rows of the same table

Having a table as: Year Month Value 2011 1 500 2011 2 550 2011 3 600 ... ... 2012 1 600 2012 2 750 2012 ... able to create any joins or case :( See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

sql server - Getting the top 6 items in a column to pivot to a row in SQL

I'm having trouble getting a column to pivot in SQL. I'd like to pivot the top 6 results from one column ... 1 and 12 values per GroupID? See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

sql - Using regular expression within a stored procedure

What is the regular expression pattern that enables every input besides characters? So far this is what i have - ... like @alphaChar + '%' See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

sql server - Include monthly counts including months where data doesn't exist

This seems like it should be easy, but I cannot seem to figure it out. I have a table that has ... rather than just using the Modification_Date? See Question&Answers more detail:os...

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

0 votes

644 views

1 answer

sql server - Help with a sql search query using a comma delimitted parameter

I am looking for something like this but can't figure out the best way to write the query: SELECT DISTINCT ... list. Hope this makes sense. See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

sql server - SQL Transform Crosstab Pivot Data

I am using SQL Server 2008 and would like to transform my data such that: Dataset: ID Item Columns Result 1 1 X ... it's a crosstab... Thanks! See Question&Answers more detail:os...

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

0 votes

547 views

1 answer

sql - How do I upload images to the Google Cloud Storage from PHP form?

I'm currently utilizing a php app to upload images to the Google cloud storage platform, however, unlike on my ... the right direction? Thanks! See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

sql - Running Total until specific condition is true

I'm having a table representing the dealers cards and their rank. I'm now trying to make a query (as fast as ... ://sqlfiddle.com/#!6/3855e/1 See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

sql - Displaying Row numbers column at runtime

I have an employee table with has name, age, city as columns. I want to display a column at run-time for my row ... 1. I am using SQL in Access. See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

sql - MySql query to find rooms available given dates 'From' and 'to'

Tables are as follows rooms(RoomId(PK)(int), RoomName(varchar)) bookings(RoomId(FK)(int), From_D(date), To_D( ... free in that range of dates See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

sql - Repeating values in a column

I have the following values in a column which are separated by comma. BHOP23,BHOP23,BHOP24 I would like to know whether ... . How can I do this? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql - Is this normalization correct? (two many-to-manys connected by a many-to-one)

I have a schema for a scorekeeping database with Game, Team, Player tables. One team has many players, each ... matters, I'm using SQLAlchemy. See Question&Answers more detail:os...

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

0 votes

713 views

1 answer

sql - Select Varchar as Date

I want to select a varchar field as a date field For example a field has this value "30.12.2011 21:15:03" and ... '30.12.2011' i get no result. See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

sql - Problems with createdb in postgres

I have to run a simulation with several postgresql databases spread on different machines which all of them are ... work? Thanks, -Giulio See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

sql server - SQL Query continues running for a very long time if search term not found

In my Azure hosted ASP.NET Core site I have a table of users and I implemented search as follows: var ... Login Name When Showing sys.processes See Question&Answers more detail:os...

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

0 votes

969 views

1 answer

sql server - error converting varchar to float

Getting an error converting varchar to float. Have a table (not of my making) with column result, having varchar ... Using SQL-SERVER 2008 RC2. See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

sql server - How to create text file using sql script with text "|"

if i run below script without char "|" it working but when i am adding char "|" it is not ... EXECUTE Master.dbo.xp_CmdShell @Cmd thanks See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

sql - Is it possible to do a 3 table join in MS-Access?

I try to do a 3-table join in Access and it will not work. Is it possible? See Question&Answers more detail:os...

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

0 votes

693 views

1 answer

sql - Split string oracle into a single column and insert into a table

I have a table with column data in below format(Row# just to indicate row number). Row#1 :test.doc#delimiter#1234, ... anyone help me do this? See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

sql - Get latest updated records

I have an "Observation" table in SQL Server 2008. This table has a locationId column for a bunch of geographic ... anyone help with any idea? See Question&Answers more detail:os...

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

0 votes

948 views

1 answer

sql - Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths?

I am getting this error when generate Database from Entity Framework Code First. I didn′t see any problem with ... key with on delete cascade. See Question&Answers more detail:os...

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

0 votes

684 views

1 answer

sql - MS Access displaying vba select query in datasheet

Learning to use SQL inside ms access vba. I've gotten how select queries work but they don't immediately ... "NDC_EXPORT_VIEW" MsgBox ("Here6") See Question&Answers more detail:os...

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

0 votes

679 views

1 answer

sql - with activerecord how can I select records based on the highest value of a field?

I have run into something I don't know how to do with active record (actually I couldn't say exactly how ... way to do this with ActiveRecord? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

sql - count number of Null variables per row mysql

We have the following table in Mysql using innoDB: id Var1 Var2 Var 3 1 NULL 1 2 2 2 NULL NULL 3 4 2 ... var2) + ISNULL(var3); any suggestions? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags