SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Parse SQL XML column into dynamic temp tables

  Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alterna…

  Lord Slaagh

  2 replies

  3 months, 1 week ago

  By: Lord Slaagh

• ERROR: The requested OLE DB Provider Microsoft.ACE.OLEDB.16.0 is not registered

  Using VS2019 editor -- developing SSIS Pkg to ingest an Excel XLSX v16.03 file and LOAD into a SQL …

  Express12

  5 replies

  3 months, 2 weeks ago

  By: Jeff Moden

• Internationalisation

  Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a pr…

  julian.fletcher

  6 replies

  3 months, 2 weeks ago

  By: EdVassie

• 2022 SSIS PackageFormatVersion?

  Recently I upgraded my ssis package from 2016 to 2022, but package format version is showing 8. Is …

  TG

  2 replies

  3 months, 2 weeks ago

  By: micherve

• Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

  SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Proc…

  SKEITA

  5 replies

  3 months, 2 weeks ago

  By: SKEITA

• Parse XML data from SQL table using temp tables and variables

  Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL to parse XML data. This…

  Lord Slaagh

  3 replies

  3 months, 3 weeks ago

  By: Eddie Wuerch

• XML data import with poor stored procedure performance (needs optimization)

  Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL t…

  Lord Slaagh

  3 replies

  3 months, 4 weeks ago

  By: Lord Slaagh

• Refactoring a DELETE query using NOT EXISTS — need expert feedback

  Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup process, and I’d like …

  abdalah.mehdoini

  1 replies

  4 months ago

  By: abdalah.mehdoini

• Need help with Cut off time in SQL

  Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([…

  hollyanneu2

  2 replies

  4 months ago

  By: WirkKarl

• Need help with Cut off time in SQL

  Hi, Need this DAX covert SQL T-SQL. Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitt…

  hollyanneu2

  2 replies

  4 months ago

  By: hollyanneu2

• Find all records in a table whose values when summed up will equal another value

  I have a list of transactions in a table. Each transaction has a unique id which is a Guid, a date,…

  kirkdevilliers

  8 replies

  4 months ago

  By: Jeff Moden

• SSIS XML Source Columns Don't Match XML/XSD

  In my SSIS package I have a Data Flow with a XML Source with the below XSD. The problem I have is w…

  s15199d

  3 replies

  4 months, 1 week ago

  By: Phil Parkin

• Get days between 2 dates excluding weekends.

  Hello all. Trying to measure the time in days between to dates excluding weekends. Currently I have…

  bswhipp

  3 replies

  4 months, 1 week ago

  By: Ken McKelvey

• Select Returning Blank Rows

  I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as S Where…

  JP789

  5 replies

  4 months, 2 weeks ago

  By: JP789

• How to update a history table with changes.

  Good morning to all.  I am a novice when it comes to SQL so my question is TSQL related on how to u…

  bswhipp

  4 replies

  4 months, 2 weeks ago

  By: Phil Parkin