Topics
Started by
Posts
Last post
I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id] [sm…
10 replies
Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alterna…
2 replies
Have a table with varbinary(8000) column. When carrying out a select and including this column the …
10 replies
Using VS2019 editor -- developing SSIS Pkg to ingest an Excel XLSX v16.03 file and LOAD into a SQL …
5 replies
By: Jeff Moden
Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a pr…
6 replies
By: EdVassie
Recently I upgraded my ssis package from 2016 to 2022, but package format version is showing 8. Is …
2 replies
I have a query that is performing poorly It has a left join to a table with 2 conditions, the query…
5 replies
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Proc…
5 replies
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL to parse XML data. This…
3 replies
Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL t…
3 replies
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup process, and I’d lik…
1 replies
Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([…
2 replies
Hi, Need this DAX covert SQL T-SQL. Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitt…
2 replies
I have a list of transactions in a table. Each transaction has a unique id which is a Guid, a date,…
8 replies
In my SSIS package I have a Data Flow with a XML Source with the below XSD. The problem I have is w…
3 replies
Viewing 15 topics - 1 through 15 (of 358 total)
You must be logged in to create new topics.