| Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| what are the software' required for sqlserver dba in laptop to install - HI Team, what are the software's required for sqlserver dba in laptop to install in new company can you list out things where i dont have access need to reach access team to install , i need to provide the list of software's required |
| SQL Server 2016 - Administration |
| log shipping switchover and switchback - I have log shipping in my environment. Could you please let me know steps to switchover and switchback for doing DR drill |
| SQL Server 2019 - Development |
| needing to insert 2 sets of numbers to a table to use as ranges for a query - the ranges (a lot) need to have a preset spacing between each set of numbers. value1, value2 -999999999,-998999999 -998999998,-997999999 -997999998,-996999999 and so on until i reach the limits of +999999999 not a gap/island thing have a query for between those ranges, don't care how long it takes to add the ranges or query the ranges. |
| UPSERT question for performance and efficiency - Hello SSC! First, I would like to thank everyone for responding to my posts. It is greatly appreciated! I have a question about an UPSERT proc that I am in the process of writing. I have a table with over 200 columns that I basically need to perform a MERGE on. The DELETEs are already […] |
| Reporting Services |
| Is this format of reporting possible in SSRS - Hi All, I am trying to mimic an excel report in SSRS using VS. Please see the below screen shot. Can I exactly mimic this in SSRS? Will it be a tabular or matrix and how can I get the Qtr1 Qtr2 Qtr3 and Qtr4 fields. I have a date field in the dataset. Your […] |
| Calculated Field expression is not showing - Hi All, I have created few calculated fields like Quarter, month and few others. I have saved the report. This I created using VB Studio. When I logged back in I can see the calculated fields but I do not see the "fx" expression editor. Any idea what might have happened? Thanks |
| General |
| Add custom toolbar to SSMS - Hi all I'm fairly certain I've done this before but can't figure it out..... 99% certain of our work is in SSMS. We do, however, use a couple of PowerShell scripts and it's getting annoying to have to go to the scripts and run them outside of SSMS. I want to add a […] |
| Add custom toolbar to SSMS - Hi all I'm fairly certain I've done this before but can't figure it out..... 99% of our work is in SSMS. We do, however, use a couple of PowerShell scripts and it's getting annoying to have to go to the scripts and run them outside of SSMS. I want to add a custom […] |
| Powershell |
| Pase keywords in text string - I've been trying to find an example to parse a record that looks for a Beginning keyword then based on that finds another keyword on the same line then pulls the next x values that are quoted. example: $data = @" this is a sample cstsums record with Values('xxxx','ppppp','45gheeet','pperere') $data = @" this is a […] |
| Integration Services |
| Buffer failed - I am fairly new to SSIS and working on executing the existing package which is very complex. The last step of this package executes a child package, which reads the data from the source, adds some logic, and gets the data into the staging. All the steps are running fine except when the last step […] |
| SQL Saturday and User Group Organizers |
| SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details - Please see the following link. https://sqlsaturday.com/2024-10-12-sqlsaturday1094/ Note that the "Call for Speakers" is in-progress and ends on 31 July 2024. (See the clickable link on the page above. With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh! |
| Events |
| SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details - Please see the following link. https://sqlsaturday.com/2024-10-12-sqlsaturday1094/ Note that the "Call for Speakers" is in-progress and ends on 31 July 2024. (See the clickable link on the page above. With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh! |
| SQL Server 2022 - Development |
| Updated Table Not Displaying Data - I have a table that contains data only to Financial Year/FY 2024: CREATE TABLE [Prod].[IMETA - Calendar Days Data_Table_Temp]([Date] [datetime] NULL,[FY] [nvarchar](255) NULL,[Period] [nvarchar](255) NULL,[Quarter] [nvarchar](255) NULL,[Day] [float] NULL,[Month] [float] NULL,[Year] [float] NULL,[Loaddate] [datetime] NULL) ON [PRIMARY]GO New table: CREATE TABLE [Prod].[IMETA - Calendar Days Data_Table_Other]( [Date] [datetime] NULL, [FY] [nvarchar](255) NULL, [Period] [nvarchar](255) […] |
| TSQL Help, Possible a recursive CTE - Hi I have 2 tables Table A JoiningID, MainID 1010619, 646703 991840, 238649 991840, 577578 991840, 222063 991840, 564824 991840, 223543 Table B MainID, JoiningID 646703, 991840 675515, 1010619 These tables are obviously a lot bigger with lots of sets of IDs, this is just one example of where there is a relationship and the […] |
| Calendar & Fiscal Year Table - I have a Calendar table that need to be displaying Fiscal Start and End Date as in below: The Calendar is currently have data for years 2023 - 2028: -- Calculate the number of days per year in the IMETA_Calendar table SELECT YEAR([Date]) AS [Year], COUNT(*) AS [NumberOfDays] FROM [Prod].[IMETA_Calendar] GROUP BY YEAR([Date]) ORDER BY […] |
