4,727 questions
0
votes
1
answer
132
views
How to extract ETL (Jobs) from SQL Server Management Studio
I want to extract the code from my Jobs (ETL) from my SQL Server 2014, which are in SQL Server Agent -> Jobs. I currently have more than 400, is there a faster way than entering each one and saving ...
- 405
1
vote
0
answers
47
views
What separator to use when sending SQL Query results in .CSV via email?
so I could get this query to do what I need:
EXEC msdb.dbo.sp_send_dbmail
@recipients = '[email protected]',
@profile_name = 'my profiles',
@subject='subject',
@body='body',
@query= 'SELECT top 10 * ...
- 217
0
votes
1
answer
47
views
Error attempting to use dynamic columns in SQL Server stored procedure
I saw several posts on Stack Overflow describing how to use dynamic columns in a SQL Server stored procedure, but my attempts result in an error message regarding the dynamic column name I am trying ...
- 53
-2
votes
1
answer
121
views
Use of MERGE reserved keyword in different versions of SQL Server [closed]
I am getting runtime error while calling a stored procedure (as shown below) in SQL Server 2012 but not in SQL Server 2014, it looks very fundamental, but I would like to know exact reason and if ...
- 686
0
votes
0
answers
87
views
SQL Connection Timeout Even though there are less than 100 connections in the POOL
I am using the rest service connecting to the SQL server for data read and write operations. I have this SQL job running to kill sleeping connections when I execute sp_who or sp_who2. I still get into ...
- 1
0
votes
0
answers
21
views
How to return a specific date range in a filtered table in sql server 2014
I am using sql server 2014 report builder.
I have a system that can schedule activity in different date, and I want to return activities that are scheduled in wed and fri only in the report. Then I ...
- 3
0
votes
0
answers
57
views
Dynamic name of column with Year and Month
I need to complete the column names based on the Usage.Doc_WarehouseApprovedDate in such a way that the column name is in the format [Year_month]
I had a lot of tries but I can't figure it out how I ...
- 11
1
vote
3
answers
522
views
Why CURRENT_DATE in SSIS works but not in SQL?
I have a fully functional legacy SSIS system which I have inherited. I am using Visual Studio 2015 to view the packages. I also have a connection to Microsoft SQL using Microsoft SQL Server ...
- 5,928
1
vote
1
answer
76
views
Retriving data row that matches all conditions
"Great Indian Sale Discount" would be applied if all the conditions are satisfied.
context can have multiple context_subCategory values.
Negative grouping means mandatory conditions.
...
- 23
-5
votes
2
answers
130
views
What is the most efficient way of extracting these integers from a string using SQL?
I have a table (in a SQL server 2014 database, accessed via SSMS) of engineering data, and I need to report the bolt lengths that are mentioned in a description field, marked in bold:
STUD BOLT SET, ...
- 24
2
votes
2
answers
113
views
GROUP BY works but I don't think it should
From https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16 it says "However, each table or view column in any nonaggregate expression in the list ...
- 620
0
votes
3
answers
179
views
Get total minutes between 2 date time
I need to get a total minutes between 2 date time with the requirement where the time fall to another date should not count the minutes for the StartDate. Eg data as below
ID Start ...
- 701
1
vote
1
answer
64
views
Connect together different values with splitter that have been grouped by [duplicate]
In picture result is what result of that UNION ALL inner select looks like.
I'm having troubles connecting together values assigned to same ID.
In inner select I can get multiple same ID results, but ...
- 23
1
vote
0
answers
911
views
The incoming TDS protocol stream is incorrect' error requiring IIS restart
I'm working on an ASP.NET Core 2.0.8 application, and it has been running smoothly. However, I'm facing an intermittent issue with all of my APIs. Occasionally, when I call this API, it returns an ...
0
votes
1
answer
47
views
How to get sum of amount from multiple tables?
I have three (3) tables which l want to get the sum total of amount from it.
OrderDetail
Product
Amount
OrderDate
Apple
10
2023-09-01
Orange
5
2023-10-01
LearnerDetail
Name
Amount
OrderDate
Tutor
30
...
- 65