19,704 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report

So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports. The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 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.
14,213 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 questions
asked 2024-11-07T13:49:08.8166667+00:00
Bobby P 231 Reputation points
answered 2024-12-24T03:34:42.0033333+00:00
Naveen Kumar M 75 Reputation points
1 answer

Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report

So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports. The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 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.
14,213 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 questions
asked 2024-11-07T13:49:08.8166667+00:00
Bobby P 231 Reputation points
answered 2024-12-24T03:34:42.0033333+00:00
Naveen Kumar M 75 Reputation points
1 answer

COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma

We are trying to COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma "," from potentially two data sources. So like...123 Main St., Apt. 101 The first part is easy enough... CONCAT ( COALESCE ( LTRIM (RTRIM…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 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.
107 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 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.
14,213 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.
107 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 questions
asked 2024-05-09T18:55:45.0266667+00:00
Bobby P 231 Reputation points
answered 2024-12-24T03:25:12.4866667+00:00
Naveen Kumar M 75 Reputation points
1 answer

COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma

We are trying to COALESCE and CONCAT Address Line 1 and Address Line 2 separated by a comma "," from potentially two data sources. So like...123 Main St., Apt. 101 The first part is easy enough... CONCAT ( COALESCE ( LTRIM (RTRIM…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 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.
107 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 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.
14,213 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.
107 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 questions
asked 2024-05-09T18:55:45.0266667+00:00
Bobby P 231 Reputation points
answered 2024-12-24T03:25:12.4866667+00:00
Naveen Kumar M 75 Reputation points
1 answer

Reba Cash Customer's Care Number . 09516192422//8926277268 call

Bhai ye sab kuche you are not to the trrrrtrv y thodaa todha piyar hua hain ki hai sahnai

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,301 questions
asked 2024-12-24T03:19:21.57+00:00
hodocoy585@seqerc.com 0 Reputation points
answered 2024-12-24T03:19:35.32+00:00
hodocoy585@seqerc.com 0 Reputation points
0 answers

Sqlagent job to shrink tempdb datafile

Checkpoint; DBCC DROPCLEANBUFFERS; DBCC FREEPROCCACHE DBCC FREESYSTEMCACHE('ALL'); DBCC FREESESSIONCACHE Job created with this code works. DECLARE @size NVARCHAR(10) = 10000 DECLARE @info nvarchar(max) DECLARE @file nvarchar(max) DECLARE @q1…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-11-26T23:05:20.79+00:00
Avyayah 1,291 Reputation points
commented 2024-12-24T03:14:15.01+00:00
Naveen Kumar M 75 Reputation points
1 answer

Changing the x-axis properties in a SSRS chart does not work when there are negative values.

I want to emphasize the x-axis of a chart in SSRS by increasing its point size. When there are negative values, the axis that shows the emphasis is not the zero value as shown in the picture. The zero line is the one I want to be dark. The labels at the…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
asked 2024-12-23T20:57:26.7166667+00:00
Khanna 0 Reputation points
answered 2024-12-24T03:12:24.4633333+00:00
ZoeHui-MSFT 38,871 Reputation points
1 answer

Credit Go Customer's Care Number . 09172420532//9172420532 Call

Mcm and nails done with meeting tonight but I'm going through the process

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-12-24T02:40:39.4+00:00
Credit Go 0 Reputation points
answered 2024-12-24T02:40:54.1233333+00:00
Credit Go 0 Reputation points
0 answers

how to slove this problem??

what is this problem? How to slove this problem. so i can't unistall this pogram .give me solution.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-12-01T01:21:08.15+00:00
Arosha mahagedara 0 Reputation points
commented 2024-12-24T02:37:00.1966667+00:00
Naveen Kumar M 75 Reputation points
1 answer

Unable to install SQL Server 2022 Express. Error code : 2068052294

I tried several times to download and install SQL Server 2022 Express from the official web (https://www.microsoft.com/en-us/sql-server/sql-server-downloads) and every time I got an error message that caused the installation to stop. I deleted all…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-12-23T10:06:27.9566667+00:00
Naimer 0 Reputation points
commented 2024-12-24T01:58:28.7466667+00:00
LiHongMSFT-4306 29,441 Reputation points
1 answer

SCOPE_IDENTITY() is Returning NULL instead of IDENTITY Value

Hello, I'm using dynamic SQL to insert a default value into a table and want to return the SCOPE_IDENTITY() value for my surrogate key. However, SCOPE_IDENTITY() is returning NULL for some reason. Am I missing something? Thanks for your…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,669 questions
asked 2024-12-23T20:23:37.25+00:00
libpekin 166 Reputation points
commented 2024-12-24T01:53:01.4833333+00:00
LiHongMSFT-4306 29,441 Reputation points
0 answers

How to query System generated columns on Developer Edition

We are using EF 8.0 to manage data, one of the recent challenges is that the query on SQL Server Developer Edition and Enterpise Edition returns different results. i.e., two columns StartTime/EndTime are generated like entity.Property(e =>…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
767 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.
14,213 questions
asked 2024-12-23T22:26:13.1633333+00:00
Zhang, Li 0 Reputation points
commented 2024-12-24T01:45:03.9266667+00:00
LiHongMSFT-4306 29,441 Reputation points
1 answer

Reba Cash Customer's Care Number . 07008241332//7008241332 Call

Do sar pe ek din se hata dijiye ga to wo to discuss my best friend

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,172 questions
Outlook
Outlook
A family of Microsoft email and calendar products.
4,215 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,646 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
asked 2024-12-24T01:41:06.7533333+00:00
Bokky Gokkyu 0 Reputation points
answered 2024-12-24T01:41:30.6133333+00:00
Bokky Gokkyu 0 Reputation points
2 answers

Azure SQL Import/Export

We have multiple databases within a single server sizing way above 100GB of data hosted in Azure. Normally we tend to restore the same production copy to our non-prod environments using SSMS .backpac method of export and import, however in bigger data…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-12-21T14:24:28.0433333+00:00
Chetan Prakash Saraswat 26 Reputation points
commented 2024-12-24T01:40:10.6233333+00:00
Vijayalaxmi Kattimani 740 Reputation points Microsoft Vendor
2 answers

I have lost SQL password. What are my options to reset, or add an account?

Hello, I am running SQL Server Management Studio: 15.0.18131.0 but I can't make any changes because I don't know the password. I can access it and see the databases and everything is working but I need to make some changes, like upgrading SolarWinds…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,473 questions
asked 2024-12-23T20:20:55.61+00:00
Willie, Joe 0 Reputation points
answered 2024-12-24T01:40:08.3633333+00:00
ZoeHui-MSFT 38,871 Reputation points
0 answers

Unable to Enable Microsoft Entra ID to SQL Server using Azure Arc

I was trying to enable the Microsoft Entra ID to an SQL Server in EC2 using the Azure Arc. I was able to successfully set it up to 5 servers but there is one server which gives me pain. I am able to setup the azure arc connections to that one server and…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
456 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.
14,213 questions
asked 2024-10-24T12:18:25.4433333+00:00
Jowlin Simon 0 Reputation points
commented 2024-12-24T01:17:23.65+00:00
Rahul Podila 800 Reputation points Microsoft Vendor
1 answer

Reba Cash Customer's Care Number . 07008241332//7008241332 Call

Ya to discuss with you and your t o m my qua lificati ons to the text of err

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,370 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.
14,213 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,773 questions
asked 2024-12-24T01:13:58.35+00:00
Cyrhf 0 Reputation points
answered 2024-12-24T01:14:20.72+00:00
Cyrhf 0 Reputation points
2 answers One of the answers was accepted by the question author.

MSSQL Cluster using Local disks of the Servers as Cluster Storage?

Dear Colleagues, Good day! We are setting up 2 Node MSSQL cluster. Unfortunately, we don't have shared storage. Only available local disks in each node. Is it possible to proceed with this setup of the MSSQL cluster? The goal is to have HA for our DB…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-12-21T11:33:49.32+00:00
JR Murillo 60 Reputation points
edited the question 2024-12-23T22:12:09.39+00:00
Erland Sommarskog 114.4K Reputation points MVP
1 answer

SQL Server 2022 Kurulum Hatası

SQL Server 2022 Detail.txt Summary_DESKTOP-UN0800B_20240602_203435.txt Summary.txt Exit Code (Decimal): -2068052377 Error Description: Geçersiz komut satırı bağımsız değişkeni (Invalid command line argumant)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
asked 2024-06-02T17:55:45.07+00:00
Kadir Veysel SAYAR 25 Reputation points
commented 2024-12-23T20:32:40.1966667+00:00
Erdem 0 Reputation points
1 answer

SSRS 2019 Custom Form Based Authentication: An error occurred when invoking the authorization extension

Hi, I am upgrading SSRS 2014 to 2019 and custom form based authentication is implemented with SSRS 2014. I followed the steps https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample and implemented same for SSRS 2019. While Web…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,960 questions
asked 2023-08-26T09:12:45.4966667+00:00
31297832 20 Reputation points
edited the question 2024-12-23T20:28:16.1566667+00:00
TP 100.9K Reputation points