13 questions from the last 7 days
Advice
0
votes
3
replies
64
views
Procedure to show percentage of nulls in TERADATA SQL ASSISTANT
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 ...
- 67
-5
votes
1
answer
129
views
Excluding NULL from a comparison [duplicate]
I've got a query which I will simplify it to be:
SELECT *
FROM BLAH
WHERE PPO_DISC_ID NOT IN ('009-003')
AND PPO_DISC_ID NOT LIKE '20%'
AND MyNum = '30788'
My problem arises when PPO_DISC_ID is ...
- 8,492
-3
votes
0
answers
70
views
How to automate the daily import of TXT files into SQL Server? [closed]
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 ...
- 11
0
votes
0
answers
68
views
EF Core 9 migration fails on production database copy with "Cannot release the application lock" error
I'm using EF Core 9 and I'm trying to run a migration against a copy of our production database.
On our local development databases everything works, but on the production copy the migration fails ...
- 633
-1
votes
1
answer
61
views
Publish VS project fails on System.Net.Http 4.2.0.0 not found in SQL Server even though other projects use it
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 ...
- 129
0
votes
0
answers
47
views
Best practice for backing up large SQL Server databases to S3 [closed]
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 ...
-1
votes
0
answers
22
views
SQL Server Express Master database corrupted tables [migrated]
I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around ...
- 75