| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| [ODBC Error] - When backup job runs we are receiving the below error and database connection closes. [Microsoft][ODBC SQL Server Driver]Communication Link Failure |
| SQL Server 2017 - Development |
| REPLACE 2 lines CR+LF by 1 line CR+LF - In a table, I have a field (text format) which contains sometimes 2 or 3 consecutive empty lines of Carriage return + Line feed I would like replace these 2 or 3 lines by only 1 line CR+LF Could you help me to build the sql query? Many thanks |
| SQL Server 2016 - Administration |
| PBM policy to check empty passwords - Dear friends, Please, could you give me some ideas, how to implement SELECT count(*) FROM sys.sql_logins WHERE PWDCOMPARE('', password_hash) = 1 ; As a Policy Based Management to check in our instances, currently the empty value could not be evaluated. I'm using an ExecuteSQL expression, but it looks like there are an error due to […] |
| SQL Server 2016 - Development and T-SQL |
| SQL 2016 - Need help reorganizing the output - Hello Gurus, Looking for some help to manipulate output data. Here is my SQL WITH SampleData (MAINJOB,JOB1,JOB2,JOB3,JOB4,JOB5,JOB6,JOB7,JOB8,JOB9,JOB10,JOB11) AS ( SELECT 'ABC4013','ABC4014','ABC4067','ABC4099','ABC4098','ABC4060','ABC4071','','','','','' UNION ALL SELECT 'DEF4061','DEF4062' ,'','','','','','','','','','' UNION ALL SELECT 'GHI4003','KLM4068','KLM4053','KLM4061','KLM4064','KLM4062','KLM4050','KLM4087','KLM462T','KLM4085','KLM4011','KLM4076' ) SELECT * FROM SampleData ORDER BY 1 Current SQL output MAINJOB JOB1 JOB2 JOB3 JOB4 JOB5 JOB6 JOB7 JOB8 JOB9 JOB10 JOB11 ABC4013 ABC4014 […] |
| need help with T-sql - Hello my dears, Please help with the query to retrieve the data as my mamager want in this format : ID,,cm_id, Date, .NextDate, status , DateDiff("n",Date,NextDate) AS DateDiff_mins, next_status where next_status is linked with next_date and also next_status equal with every changed in Status from pending to add tatachemnt .(for example). Bst Wishes, […] |
| Accessing a RESTORING database for test refresh - I have a requirement whereby testers on ServerA need a copy of the production database from ServerB which is refreshed on a two-day basis. The source database is nearly 400Gb and is in simple recovery mode. Full backup is made on a weekly basis with differential on the remaining days. At the moment I'm doing […] |
| Development - SQL Server 2014 |
| Balance is not calculating correctly,when date get change in transection. - Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date 01/19/2021 transection amount is not getting minus (Credit ) From Balance ,but 01/18/2021 amount is getting Less from balance. Secondly,i want ,Order by trans_date asc, Create table #tbl_COA (Level_Four_ID int,Level_Four_Name varchar(50),Opening decimal(10,2)) Create table #tbl_trans_type (Trans_Type_ID int,trans_type_name varchar(50)) Create table #tbl_transection […] |
| SQL Server 2019 - Administration |
| How to find index usage by stored procedure? - Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can be joined between each other. One shows index usage, and another shows procedures executions statistics. But is there a way to find index usage by procedure? Thanks |
| Reporting Services |
| How to set the value of a parameter that is passed via a URL - I may have had this originally in the wrong forum. I found this category, so I will try here. I have been looking of a good example of how to accept a parameter value in SSRS via a URL but I cant find an example that fits. A URL carries the Parm value. I can […] |
| How to create a gantt chart for event rooms during a day - Hi all, This will be my first ever post in a forum like this. But searching around the web and been spending to many hours allready, I tried finding a great community to join. Scenario - I`m working for a customer that are running some big event properties, they are lacking a good gantt chart […] |
| Error: The size necessary to buffer the XML content exceeds the buffer quota - Hi Guys, I have a report named Master and a report named Child, Child is added to the Master report as a sub report 11 times with a different Location parameter being passed in for each report. This is obviously running 11 queries against the server and causing issues. Each sub report has two tables […] |
| SSRS 2012 |
| Odd things with Report Builder (also tried VS 2019) - This is kinda hard to explain, maybe I can make sense of it. So I had to add an column to the report which meant modifying one of the four data sets for the report. I was getting data and it was correct in the Tablix. But if I changed the date range then the […] |
| SSRS 2014 |
| SSRS passing parameter via a URL - Hello, I have been looking of a good example of how to accept a parameter value via a URL but I cant find an example that fits. The stored Procedure that is used as the dataset into the report needs a parameter. We need the ability to pull the parameter from the URL which is […] |
| Integration Services |
| Issue in using Smartsheet CSharp SDK in SSIS Package - Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below : Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?) Then, I downloaded Smartsheet CSharp SDK and added reference to […] |
| converting smallint to int in ssis - Hi clever guys I have two tables named dbo.jade.store and dbo.stage.Store. The first has a column called store_number, PK smallint, not null and the other storeNumber, PK, INT not null. For some reason I cannot use a derived column or data conversion to change the store_number from smallint to int as the mapping won't […] |
