SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,982 questions
0 answers
SQL Stored Procedure BULK INSERT wont execute when called from Kubernetes Cluster
Hi There, I have a Python Program that calls a Stored Procedure on a SQL Managed Instance in Azure. This stored procedure, deletes data from a staging table and carries out a BULK INSERT of Data from CSV files that are stored in a Storage Account…
asked 2024-10-30T08:21:27.5466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Chris Courtney
20
Reputation points
commented 2024-10-30T22:37:59.94+00:00
Erland Sommarskog
112.7K
Reputation points MVP
1 answer
Correct SQL query to not repit articles
Hello, good afternoon, I have the following query in SQL and it is returning duplicate items. I managed to decipher that the items that are duplicated in the "On Orders" column in one row appear with one quantity and in the next row (Same item,…
asked 2024-10-24T18:39:13.1333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 20%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Javier Prieto
1
Reputation point
commented 2024-10-24T23:26:16.4633333+00:00
Javier Prieto
1
Reputation point
1 answer
One of the answers was accepted by the question author.
CURSOR for column in WHERE that gives dynamic columns in SELECT
Hello, I need help to make my query more simple Depends how many rows for column Code (now I have 53 rows) then it will be 53 sub selects and 53 more columns. How to make it simple to add variable in select and in sub select instead of writing 53 times…
asked 2024-10-20T20:25:46.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 21%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Alan5896
26
Reputation points
commented 2024-10-21T21:20:32.78+00:00
Erland Sommarskog
112.7K
Reputation points MVP
2 answers
How to get the non null row before the row with null value
Hi I want to see the non null row before the row with NULL value in the result set. I have data in below in format I want to see ID 2 row in the result set like below Help with this would be appreciated.
asked 2024-10-14T19:48:43.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Learner DAX
41
Reputation points
commented 2024-10-15T18:08:31.11+00:00
Erland Sommarskog
112.7K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Runing SSAS Tabular Processing Script (TMSL) from SSAS Database Engine
Hello Experts, In continuation of my previous question https://learn.microsoft.com/en-us/answers/questions/2076521/processing-monthly-partition-from-sql-job-using-st?source=docs We have SSAS Tabular model database and SSAS Database engine. When trying to…
asked 2024-09-24T11:15:03.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PANDEY Prashant
145
Reputation points
accepted 2024-10-14T06:50:21.2266667+00:00
PANDEY Prashant
145
Reputation points
1 answer
How to get a date of day in current week
Hi, I have table that stores configurations like In my sql code, I need to take currentDateTime and get current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024. Get following week wednesday date. Here it…
asked 2024-10-02T17:24:40.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 43%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Spunny
326
Reputation points
commented 2024-10-07T08:30:06.45+00:00
LiHongMSFT-4306
27,961
Reputation points
1 answer
One of the answers was accepted by the question author.
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
asked 2024-09-30T19:03:37.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
420
Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto
420
Reputation points
0 answers
Like to review records incorrectly entered in the database
We have a database where we enter a record with a number with an alphanumeric suffix. But the software entered it incorrectly due to an algorithm issue which we are trying to fix now but past transactions need to be fixed in the database. If I know the…
asked 2024-09-24T16:38:23.5633333+00:00
Jonathan Brotto
420
Reputation points
commented 2024-09-25T21:56:13.35+00:00
Erland Sommarskog
112.7K
Reputation points MVP
1 answer
date function in Sql
I have a timestamp where I want to query only based on the date and exclude time.
asked 2024-09-24T18:11:46.69+00:00
Jonathan Brotto
420
Reputation points
commented 2024-09-25T01:20:51.7166667+00:00
LiHongMSFT-4306
27,961
Reputation points
3 answers
Way to optimize query where no union needed
I had to use union on two very similar queries where one is just a copy of the other but the having clause is equal with an additional condition in the where clause. Is there a way to clean up the code? DECLARE @PO_DATE_FROM date = '2024-09-08',…
asked 2024-09-10T19:56:39.0933333+00:00
Jonathan Brotto
420
Reputation points
commented 2024-09-17T08:53:22.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 33%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rodger Kong
360
Reputation points
3 answers
One of the answers was accepted by the question author.
Queries in the same window for multiple databases, servers, and tables
I was wondering in SSMS in the query window could I write multiple queries that use different servers, databases, and tables? A compounded question and answer I am expecting for this.
asked 2024-09-16T13:02:52.5733333+00:00
Jonathan Brotto
420
Reputation points
answered 2024-09-16T21:45:55.07+00:00
Erland Sommarskog
112.7K
Reputation points MVP
1 answer
SET FMTONLY ON/OFF is deprecated according to the docs and should be replaced by sp_describe_first_result_set. But sp_describe_first_result_set returns 'incorrect syntax' message on correct queries. How to correctly migrate?
Using this simple table structure: CREATE TABLE Persoon_ ( ID INT, Adres NVARCHAR(50) ) CREATE TABLE Factuur_ ( ID INT, Debiteur INT, Persoon INT, Bedrijf INT, Derde INT ) CREATE TABLE Bedrijf_ ( ID INT, FactuurAdres NVARCHAR(50), …
asked 2024-09-13T08:32:03.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Carta Online | Hans Wijntjes
0
Reputation points
answered 2024-09-13T22:09:54.04+00:00
Erland Sommarskog
112.7K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Purpose of Schema
What is the purpose of schema? I am a BA like to be more technically knowledgeable.
asked 2024-09-11T15:07:16.7566667+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-09-12T13:11:16.5966667+00:00
Jonathan Brotto
420
Reputation points
3 answers
One of the answers was accepted by the question author.
How to write/read comma-separated data from an SQL table and load them into a datagridview column?
I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,917 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,982 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,735 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
101 questions
asked 2024-09-07T16:06:21.0566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 86%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Priyantha Niroshan
41
Reputation points
commented 2024-09-10T03:02:23.4266667+00:00
Priyantha Niroshan
41
Reputation points
2 answers
One of the answers was accepted by the question author.
Icons in SQL management studio
Like to know what the icons mean SQL management studio. Some are the basics like for the database and some are bit more unique.
asked 2024-08-30T13:31:40.5733333+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-09-06T13:47:31.77+00:00
Jonathan Brotto
420
Reputation points
1 answer
One of the answers was accepted by the question author.
How to extract all email addresses from column XML data - 2008 R2 compatibility mode
Re: How to extract all names from column XML data - 2008 R2 compatibility mode - out of my control There is a column that contains names that are formatted like this - <item xsi:type="bus:custName">willow</item> There can be names.…
asked 2024-08-23T21:22:19.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
brenda grossnickle
206
Reputation points
commented 2024-08-30T10:49:48.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Grossnickle, Brenda
60
Reputation points
1 answer
An error in the editor for Ignore Nulls
Hi All, I have a query that retrieve the previous row info for the specific column. The attached image query can be successfully executed. However there is a syntax error line on the editor. The execution engine of the database understand and processes…
asked 2024-08-30T07:18:38.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 77%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JAV
0
Reputation points
answered 2024-08-30T08:24:39.8+00:00
LiHongMSFT-4306
27,961
Reputation points
2 answers
One of the answers was accepted by the question author.
Join to return default job information if step information is not present
I have a job 1111 with three steps : 11111, 11112, 11113. Steps 11111 and 11112 have a specific delivery method. Step 11113 does not have a specific delivery method so it will use the job default delivery. I have tried to code it my self but the code is…
asked 2024-08-26T20:03:57.4633333+00:00
Grossnickle, Brenda
60
Reputation points
edited an answer 2024-08-29T01:56:34.78+00:00
Rodger Kong
360
Reputation points
2 answers
Database Mail Stopping
Currently having issues on two separate SQL 2022 servers with Database Mail. The service won't auto start up as it should do - I can manually start it and it seems to run for just less than an hour or so and then shuts down and won't restart itself…
asked 2024-08-26T11:16:49.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 6%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rabia Kurnaz
386
Reputation points
commented 2024-08-28T05:52:18.7333333+00:00
CathyJi-MSFT
22,306
Reputation points Microsoft Vendor
2 answers
Query to return all users permissions on SQL Server
Hi everyone, Please how can I use TSQL to get the list of all users detailed permissions and privileges on each database. I want the query to return critieria like: Username Database name Login Type (SQL, Windows user or group, etc) Permission Type…
asked 2024-08-27T17:35:11.3233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 82%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tobz
161
Reputation points
answered 2024-08-28T02:50:34.6933333+00:00
LiHongMSFT-4306
27,961
Reputation points