Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
Backup progress - We have started the full backup job that uses Veritas netbackup. The server has about 10 databases. 4-5 of them are large databases. There are no transactions showing that relates to backup from the dmv sys.dm_exec_requests but the job is running. I didn’t see any blocking. How to find what the backup job is doing? […] |
SQL Server 2017 - Development |
Sql table join help - I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101, maths, 76 101, science, 89 tblStudentMarksCopy1 - studID, English, maths, science 101, 91, 76, 89 I need to write sql query to join both tables to check if marks match or not for each student subjectwise. If match then display matching […] |
SQL Server 2016 - Development and T-SQL |
Error: Column names in each view or function must be unique - I am getting the error: Column names in each view or function must be unique. Column name 'Id' in view or function 'myview' is specified more than once. CREATE VIEW myview AS SELECT * FROM dbo.appointment LEFT OUTER JOIN dbo.ts_engagement ON appointment.regardingobjectid = ts_engagement.ts_engagementid WHERE ts_engagement.ts_engagementtype = 'CORE' I appreciate column 'Id' appears in both […] |
Exporting from SQL to XML issue - Hi everyone, So I have a table which consists of different IDs of a person. Like for example their national id card no, and passport and NTN no etc I have to convert this table into XML format so it would look like this: But I am getting the result like this in […] |
DateTime Format Conversion AM/PM - Hi, I have a field showing select field from table ; 2022-11-28 16:19:38 I would like to convert to 11-28-2022 4:19 PM |
SQL Server 2019 - Development |
How to apply rates in a time column - Hello all I have this selected column : convert(TT.horas, Time) AS TimeTT, this column can have values like 08:00:00, 04:30:00, 05:50;00 etc, and I need to apply an hourly rate for each row, for example 40€. My question is what is the best format for that column to accomplish this. Before the convert, this column […] |
Designing Database from a piece of paper - Greetings experts, Hopefully, this is the forum for my question. I am trying to create a fully normalized database design from the attached screenshot. Below is my draft of what I think is normalized relational database. Can one of you experts please assist with any additional changes I need to make to this db design? […] |
Sum up different dates - Hi guys To the table below - I want to sum up the amount from each Flexi Account No. + each Posting Date where you have to consider the historical amount. For example: For the Flexi Account No. 50112235 and Posting Date 2021-11-29 I want to sum up the amount of this day and the […] |
Why do Sql Server In operator behaves differently and return nothing? - I am using sql server 2017. I am trying to use the in operator, but it behaves me so differently. What I am trying to do is I created a cte and split the comma separated string into array and use this cte in my end query through in operator. But In operator should return […] |
Join query with many tables - Hi guys, I hope everyone's ok I have a query in MySql (I'm using Workbench for it) where I'm joining several tables. FROM hoursworks TR ... My 5th join is like this: LEFT JOIN pag5_users US ON TR.id_ang_user = US.id Now I need also to join to the same table and to the same field […] |
should atemp table be used from looping even when single table is used in a loop - hi, We have a master table, single table which I loop thought, to do some task, the master table is very rarely changed. So while looping through , I put some records in a temp table and do the looping ? Will it help in any case, or can worsen it in any case? (pls […] |
SQL Azure - Development |
Mass update on Clustered Columnstore indexes - Hi, we have a FACT table with 35 billion rows, partitioned on daily level. In a test environment we put a clustered colmnstore index on this table. Storage reduced with 300%, reading data became much faster and inserting became a little faster. No updates are doen on this table. Now we have a second FACT […] |
Amazon AWS and other cloud vendors |
I need a user from non-prod-rds.amazonaws.com instance replicated to Prod RDS - Hi Team, I need a user from non-prod-rds.amazonaws.com MSSQL instance replicated with the same permissions to Prod RDS MSSQL instance. The user is a DB user 'xxxxxxxxxxx'. It has a role of 'usr_xxxxxxxx'. |
SSRS 2016 |
SSRS Data-driven subscription errors - There are lots of SSRS Data-driven subscription which regularly fail with different amount of errors showing each day for the same subscription. For one subscription, its should produce 382 files, 43 errored today, and 63 errors day before. The only way to get 100% success is to keep manually executing until all the files are […] |
Integration Services |
Parameter error message - Has anyone experienced this error message: There is no appropriate variable in the current environment to map to the parameter "ParamName" When running the package from the catalog directly, it works fine. However when running the parent package which calls it, I get this error message. The erroring package has been configured in the catalog […] |