Questions tagged [sql-server-2012]
Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.
sql-server-2012
17,117
questions
0
votes
0
answers
35
views
XML path into temp table creates a nvarchar column, issues when merging it varchar column
I using SQL Server 2012 and need to use FOR XML PATH to get a comma-separated string for like projects. The query runs and works but when I try to alter #T2, I get an error
String or binary data ...
- 31
0
votes
2
answers
64
views
Use XML path in SQL Server 2012 with a temp table?
I am on version 2012 and need to use FOR XML PATH to get a comma separated string for like projects. I have a temp table that I have compiled and would like to combine people based on project numbers....
- 31
0
votes
0
answers
22
views
Delete operation taking time from SQL Agent Job [migrated]
I am running a job which deletes data from 7 tables, 2 of which contains 10-20 lakhs of records. But the job get stuck at a point when deleting data from a particular table web_activity which holds ...
- 1
-2
votes
0
answers
45
views
EF Core Certificate issue by untrusted authority. TrustServerCertificate, Trusted_Connection, Encrypt=False all don't work
I've connected the database in Server Explorer, and I've scaffolded the entire database. My entire context is built, however when running the app and trying to pull information from one of the tables ...
- 116
-2
votes
1
answer
94
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 ...
- 666
0
votes
0
answers
17
views
SSIS Package failing- CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I have this SSIS package with many tasks. While the package sometimes run fine but sometimes it just fails. I have observed one thing that the package fails because of couple of tasks, prominently one,...
- 23
0
votes
1
answer
46
views
Stumped on a complex GROUP BY [duplicate]
Given the following query, how do I group by con_num and retrieve the lead_id with the MAX date_entered? I am using SQL Server 2012.
SELECT leads.id AS lead_id
, leads.date_entered
, so....
- 1,101
0
votes
1
answer
86
views
Object reference not set to an instance of an object: on Publish
When I click a publish button:
on the Database project in Visual Studio I cannot access the publish window and I just get a popup that says Object reference not set to an instance of an object.
...
- 927
0
votes
0
answers
43
views
Shared Memory Provider: No process is on the other end of the pipe. Unable to open a logical session
During the normal use of my program, I received the following error message:
"Shared Memory Provider: No process is on the other end of the pipe. **Unable to open a logical session**"
After ...
- 33
0
votes
0
answers
17
views
Blazor Local Accounts: Add to existing database
As a proof of concept, I wrote a prototype Blazor Server application that uses local accounts for authentication. That all works perfectly.
Now I need to add all the required local account tables ...
- 191
0
votes
1
answer
95
views
How can I optimize a SQL query to efficiently count non-blank column values without using a cursor?
I have written a T-SQL script to count non-blank values in each column across all tables in a database. The script currently uses a cursor to iterate through each column and dynamically generate and ...
- 454
0
votes
1
answer
53
views
Multiple repetitive tables
I'm querying results out of 2 tables, at a time, which has a repetitive pattern.
select
abc, xyz
from
2010_Q1_result
inner join
2010_Q1_run
(next comes 2010_Q2... inner join ...
- 53
-1
votes
3
answers
74
views
Remove duplicate nulls from a SQL Server table
Issue table:
col1 col2 col3 col4
----------------------
1 null a null
1 b null null
1 null null c
2 aa null null
2 null bb null
Output needed
col1 col2 ...
- 1
0
votes
1
answer
55
views
Take data from Lead Record when condition or filter criteria matches and ignore the records between current row and selected record (lead row)
How can I write a CTE in SQL Server to get the date from the preceding row for the person that has Type = NA.
If there are multiple preceding rows with NA then take the first one when sorted by dt_eff ...
- 110
-2
votes
1
answer
56
views
SQL Server 2012 trying to update fill missing bill no sequence continously and count? [closed]
I have this data in a SQL Server 2012 table:
bill_no
datetime
3125
2022-12-26 14:17:21.000
3125
2022-12-26 14:17:21.000
3126
2022-12-26 14:31:48.000
3126
2022-12-26 14:31:48.000
3127
2022-12-26 ...
