Ok, seeing as how I couldn't find a split() function in T-SQL, and I need to import data from a Table that has this concatenated field of ID's, I wrote my own split function: Code: CREATE Function ...

T-SQL Theory questions that only Maxer seems to care about…” If trees could scream, would we be so cavalier about cutting them down? We might, if they screamed all the time, for no good reason. Just ...

Like most databases created in the last few decades, SQL Server allows developers to extend the database by creating functions. But prior to the upcoming 2019 release, SQL Server’s support for scalar ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...