Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Availability Group - Trying to understand the pros and cons. So I have SQL Server default instances and I am planning to configure as AOAG. However, the best practice I have heard is add the nodes to cluster first and then install SQL Server and configure AOAG? But I have situation where all the nodes are not available […] |
| SQL Server 2017 - Development |
| SQLCMD.exe get installed with SSMS? - Is the SQLCMD.exe supposed to be installed when SSMS is installed on a workstation? I've been told it is, but I cannot seem to locate it after SSMS was installed. I've looked where I typically find this exe , run a DIR search. I do not find this exe. |
| T-SQL code help - Hello! I am designing one query where I have to convert the value from one currency to another. The problem is for I have to calculate a value with following conditions: In that transaction row, if the current row currency (A) is not equal to the posting currency (B) then I will have to go […] |
| SQL Server 2016 - Administration |
| fn_dump_dblog - Hi All I have been trying to figure out what has caused a spike in the size of a particular log backup. ' I am seeing entries for LOP_MODIFY_COLUMNS & LOP_MODIFY_ROW I found this in attempt to get an understanding... LOP_MODIFY_COLUMNS: Designates that a row was modified as the result of an Update command. LOP_MODIFY_ROW: […] |
| SQL Server 2016 - Development and T-SQL |
| Log Updates To Table - I've a user table that has four fields that need to be manually verified (as a daily batch) by an administrator any time they're changed. The four fields may be changed over the course of a couple of different web pages. The table does have a 'modified' column that records the date the last change […] |
| Transaction log and updates on large tables - I’ve inherited a query that on first glance should be re-written. The main part of which is performing an update on a table (200m+ rows) in a while and using nested selects in a not exists. I realise this is quite vague so can provide more detail. The query has a tendency to fill my […] |
| Complex .Json Data Parsing with multiples Array elements into SQL (MS-SQL 2016) - DECLARE @JSON NVARCHAR(MAX) =N'{ "code": 200, "msg": "success", "data": [{ "ITEM": "SP", "FACTORY_NO": [{ "FACTORY_NO": "1", "ORDERQTY": 10 }, { "FACTORY_NO": "1", "ORDERQTY": 20 } ], "DETAILS": [{ "LINE_INFO": "INLNE", "CARD_NUMBER": 13 }, { "LINE_INFO": "OUTLINE", "CARD_NUMBER": 14 } ] } ] }' Expected OUTPUT IN MS-SQL 2016 ITEM FACTORY_NO ORDERQTY LINE_INFO CARD_NUMBER SP 1 […] |
| SSRS Report doesn't refresh data - Hi all, I have SSRS Report that uses SP as a source. I have one filter - Activation Date and use such script for it: select distinct [Activation Date] from TableTest. Every month data in the TableTest updates. But in the SSRS filter I didn't see updated value. When I execute a query in the […] |
| How to change schema of all tables, views and stored procedures in MSSQL - Hello Community, I trying to use the following sql code to change the Schema for all my tables from dbo to Config SELECT 'ALTER SCHEMA Config TRANSFER [' + SysSchemas.Name + '].[' + DbObjects.Name + '];' FROM sys.Objects DbObjects INNER JOIN sys.Schemas SysSchemas ON DbObjects.schema_id = SysSchemas.schema_id WHERE SysSchemas.Name = 'dbo' AND (DbObjects.Type IN ('U', […] |
| SQL 2012 - General |
| How to Display FeatureName of Comptitor First then Npx Feature Name second Based - How to Display Feature Name of Comptitor First then NXP Feature Name second Based On Display Order? I work on SQL SERVER 2012 I face issue I can't arrange feature on same display order to start by comptitor feature name then nxp no issue on display order 1 and 2 because it is correct issue […] |
| SQL Server 2019 - Development |
| Debugger permission issue - We have a dev that used to use SSMS in order to debug code that was related to SQL. I guess MS has taken that piece out of SSMS and now they are supposed to do this with Visual Studio. Problem is, now we can't seem to get that to work right. Each time they […] |
| Reporting Services |
| SSRS inserting blank page - I have a main report calling three subreports. The subreports are being grouped together by the CourseID field. Page 1 shows course 1 for the first two reports. The third subpreport is for comments. If course 1 has comments, they will show up on page 2. If there were no comments, page 2 will be […] |
| Analysis Services |
| Changing SSAS TCP port directly in config file - Goodday, I have a problem with changing the TCP port for SQL Server Analysis Services by using the "msmdredir.ini" file I know how to change it by using Microsoft SQL Server Management Studio, but I want to change it directly in the "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini" file, so that I can automate the installation/configuration. […] |
| Integration Services |
| SSIS Package to load contents of CSVs to SQL Table - I have 14 .csv files from which I need to extract 1) a date found only in the file name itself e.g. "ConvoEVQ2021-03-22" (i.e. I need to harvest the date part of the file name and place it in all the date fields of each SQL record associated with that .csv), 2) an individual's full […] |
| Last day of the previous month - Format MM/DD/YYYY - I use the below to get Last day of Previous Month, but I want the date format to be MM/DD/YYYY. We are sending that in the output file. REPLACE(LEFT((DT_WSTR,20)DATEADD("d",-1,DATEADD("m",DATEDIFF("m",(DT_DATE)"1901-01-01",GETDATE()),(DT_DATE)"1901-01-01")),10),"-","/") Thanks! |
