Skip to main content
44 questions from the last 30 days
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Advice
2 votes
8 replies
118 views

I developed a simple Android app (A driver app for taxi booking). App sends its location (lat/lng) every 5 seconds to server using TCP/IP. and server stores the driver location in SQL SEVER database. ...
hamid's user avatar
  • 860
-4 votes
1 answer
176 views

I found examples online using a recursive CTE to find all combinations of values that equal one target amount. The database column ledger_amount is DECIMAL(26,6). DECLARE @TARGET_AMOUNT DECIMAL(26, 6) ...
DoctorKennyG's user avatar
  • 499
Advice
0 votes
3 replies
64 views

I'm working in Teradata SQL Assistant and I need to create a stored procedure that, given a table name, returns the percentage of NULL values for each column in that table. Right now, I generate the ...
danny's user avatar
  • 67
Advice
1 vote
12 replies
154 views

We have some tables in an on-premises SQL Server database that we archive data every day. Currently, we have a schedule task that runs a C# program, that write old data into a .CSV file. Each batch ...
SyndRain's user avatar
  • 3,907
0 votes
1 answer
107 views

In SQL Server 2022, is there an aggregate function for doing a bit-wise OR against a particular column? -- Example table, data and output to show the different flags DECLARE @TEST TABLE (FLAGS TINYINT)...
freefaller's user avatar
  • 20k
2 votes
2 answers
186 views

I need some help handling null columns in joins. I have three tables (below are just examples) Map, Employee and Region. Primary table is Map where I join Employee table on the MapID column to get ...
unicorn's user avatar
  • 590
2 votes
3 answers
136 views

I have created a recursive SQL Server scalar-valued function that converts XML data to a JSON string. The function works well for most cases, including nested elements and handling of arrays (using a ...
Ragavendra GJ's user avatar
  • 55
0 votes
1 answer
135 views

I have a generic ASP.NET Core Web API that uses EF Core to connect to a SQL Server instance that uses Microsoft Entra MFA account. The connectivity prompt for the SQL Server looks like this: I have ...
James's user avatar
  • 1,345
-1 votes
0 answers
160 views

I am seeding a database by copying over data from another database on the same server. In one of the tables, I am doing an INSERT INTO SELECT statement to bring over a few columns. While existing and ...
Robert Sievers's user avatar
  • 1,361
0 votes
1 answer
126 views

Is there any way to compare the results of Boolean expressions as in the following query? This expression gives the error Incorrect syntax near '='. at the first '='. select * from Transfers where (...
Jonathan Wood's user avatar
  • 68.1k
0 votes
1 answer
107 views

I have a stored procedure in Microsoft SQL Server. I want to combine multiple results into 1 row like this: ID Period Income 202501_a 202501 50528.55 NOT LIKE THIS ID Period Income 202501_a NULL NULL ...
Jeff Meacham's user avatar
  • 3
1 vote
3 answers
78 views

I have an employee Manager table where you can see for every deptID, there are multiple rows. A few rows have null employeename and a few rows have null managername for same DeptID. i would like to ...
unicorn's user avatar
  • 590
-3 votes
0 answers
70 views

In the company where I work we receive daily TXT files exported from SAP via batch jobs. Until now I’ve been transforming and loading some files into SQL Server manually using Python scripts, but I’d ...
Ni04's user avatar
  • 11
-1 votes
0 answers
101 views

How to enable full-text search feature in SQL Server for .NET Aspire? var sqlServer = builder.AddSqlServer("sqlServer", builder.AddParameter("password123!!!", true)) .WithLifetime(...
Joseph Wambura's user avatar
  • 3,542
Advice
0 votes
2 replies
83 views

Goal The company wants to grow and take advantage of the AI revolution. But there is no roadmap and the current process limits their growth capability. The current process is about 20% automation and ...
Draco's user avatar
  • 67
-8 votes
1 answer
123 views

Note that it's saved in time datatype. So if I have someone that started work at let's say 5:30 am and ended their shift at 10:00 am Is there faster way than: declare @Shiftstart time; declare @...
asri Allaham's user avatar
  • 1
1 vote
2 answers
109 views

Recent versions of Microsoft SQL Server allow creating a clustered columnstore index on a table that has computed columns, as long as they are not persisted computed columns. [1] I would like to get ...
Ed Avis's user avatar
  • 1,622
-3 votes
1 answer
51 views

I am trying to connect the DB for testing web elements that have dependencies on data, and in general to add some reliable BE testing. Currently I have cypress.config.js: // cypress.config.js const { ...
Rimon Sade's user avatar
  • 25
-1 votes
1 answer
61 views

I have several Visual Studio projects (Stored Procedures) that have been published to SQL Server 2014 (yes old I know - legacy software) that use System.Net.Http v4.2.0.0 so I know that the assembly ...
A. Guattery's user avatar
  • 129
0 votes
0 answers
47 views

We are currently backing up all of our databases to a series S3-Compatibable storageGRID buckets hosted by our data center provider. Some of our larger databases backups run quite long (upwards of 8 ...
Ben Adams's user avatar
  • 9
-2 votes
0 answers
42 views

I'm having intermittent connectivity problems when trying to connect to an azure based SQL database when using SSMS. I've done the following troubleshooting: The exact same version of SSMS has been ...
hozer95's user avatar
  • 81
0 votes
0 answers
24 views

On Windows Server 2016 and with SQL Server 2019 (v15.0), the tempdb file size is huge at about 80GB and it is divided into many files such as: tempdb.mdf, tempdb_mssql_2.ndf tempdb_mssql_3.ndf ... ...
Orgil's user avatar
  • 317