So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no ...

I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...

Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server Your email has been sent Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...