Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Development |
| Pivot or CROSS APPLY this? - Hi SSC, I'm mentally stuck with this one. Essentially I want 2 rows with all the measures related to the Internal_No but I'm stuck figuring it out. Here's how far I got: USE [Database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ARCHIVE]( [Time_Inv] [datetime] NULL, [Rep_Date] [datetime] NULL, [SalesOrg] [varchar](50) […] |
| SQL Server 2016 - Administration |
| IntelliSense no longer working - I recently got a new laptop at work and now IntelliSense is no longer working in SSMS 2016. It always worked fine before, so I'm assuming it's some kind of local configuration issue or something, not a server-related setting or access issue. I've tried all the usual stuff: making sure IntelliSense is enabled, refreshing the […] |
| Renaming SSRS reports programmatically - Hello experts, I used one of the RS scripting tools to export some reports from on SSRS server in order to import them on another server. The reports were exported with rdl names along the lines of -MyFolder-MyReport.rdl There are hundreds of reports. I ended up manually creating the folders and putting the reports into […] |
| SQL Server 2016 - Development and T-SQL |
| Add a Time column and a Date column together? - Hi, Please can someone help with. I am trying to create a new column containing a combination of two existing columns. Column 1 is datetime and column 2 is smallint Example 2020-11-20 00:00:00.000 900 2020-11-21 00:00:00.000 1700 I want to create a new column which […] |
| Administration - SQL Server 2014 |
| trigger on a Large 5 billion row table - Hello, So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been from seconds to almost minutes apart, wondering if anyone noticed this when handling large tables, and if there is anyway how to get around it? […] |
| SQL 2012 - General |
| How To get different feature values on one row separated stick if it multiple d - I work on SQL server 2012 I face issue : I can't get all different value Feature one one row result separated by sticky if it multiple difference if one different then no need stick. where c have value and x have value but both not equal each other so How can i do that […] |
| SQL Server 2019 - Development |
| I passed the Microsoft Exam 98-364: Database Fundamentals - I recently passed Microsoft Exam 98-364: Database Fundamentals. As it turns out, I did better than I expected and passed the exam quite easily and scored a 98. This means that I am now MTA certified (Microsoft Technology Associate). I would like to thank everybody on this message board who helped me in learning TSQL, […] |
| How To Process JSON Columns, having '.' (dot) in Their Names? - I have a JSON file from Azure's DevOps I need to process. It seems to be straight forward on columns with one word, but how do I process those with dot between them, please? { "count": 56, @value" :[ {"id": 1, "workItemId: 1234, "fields": {"System.Id": {"newValue": 1234} "System.State": {"newValue": "New"}, {"id": 2, "workItemId: 1234, "fields": […] |
| SQL Server 2008 - General |
| "Lock request time out period exceeded" for extended property - For extended property update query "Lock request time out period exceeded" Error comes. It is not solved even after 30 minutes , but solved after exe is closed. We are not using begin/commit transactions in our code but connection is global. Why lock on one particular table is not released(in our case extended property update […] |
| SQL Server Newbies |
| 'sa' impersonation - To give a user the ability to execute a stored procedure (EXECUTE AS) I must first grant him the ability to impersonate the 'sa'. (that procedure creates new login and adds to role which a normal user can not execute) Am I right ? But when I give him the ability to impersonate 'sa' […] |
| CLR Integration and Programming. |
| Issue with MSSQL 2017 CLR referencing IBM.MQ (amqmdnetstd.dll) - All, I've been going at this for a couple of days now and hoping someone out here has experienced this and knows how to solve it. I am migrating a SQL Server 2008 R2 database running on Windows Server '08 to a new SQL 2017 Enterprise installation running on Windows Server '16. In my current […] |
| Analysis Services |
| DAX Approach to Inventory Problem? - I have data in AAS (Tabular) that looks like the following table. I need to create two calculated columns for the Date that the Inventory Changed and the Amount of the Inventory Change. I think and IF function can take care of me for the date of the inventory changed. However, I'm stumped regarding how […] |
| Anything that is NOT about SQL! |
| DBA progress/career development/ path - Hi I am an post-grad and mssql server dba with around 5/6 years of experience and currently confused about my carrier progression and with all this cloud automation i am worried that dba (purely administrator role) might get diminished or disappear whole together so i am here for help I would like to know what […] |
| sql server laptops using AMD processor - Hi I have current dell laptop with intel processor .I has become old and wish to purchased new one .i wish to try one with amd processor .Which one would be good amd processor from there current generation ryzen 3/5/or 7 .I am not into gaming much .it mostly going to used for learning and […] |
| SQLServerCentral.com Website Issues |
| Why is the topic I'm trying to start not posting? - I have a very challenging issue with integrating a CLR on a new MSSQL17 server i'm migrating to. I've written a very detailed topic regarding the issue seeking expert advise from the members here, but for some reason my topic never shows up. I was trying to post it in the SQL Server 2017 - […] |
