Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

T-SQL

Posted in
  • Excel
  • T-SQL

The T-SQL Merge statement

You have a table A with new data, and a table B with old data. How … The T-SQL Merge statementRead more

by Tomas Lind•2017/07/182025/06/12•5
Posted in
  • T-SQL
  • Tips & Tricks

Identity columns that are about to overflow

Identity columns are widely used as primary key columns in SQL Server tables. They can be … Identity columns that are about to overflowRead more

by Tomas Lind•2016/12/082025/06/12•0
Posted in
  • T-SQL
  • Tips & Tricks

Split strings to columns

A short demo on how to split strings with delimiters into columns.

by Tomas Lind•2016/05/252016/05/25•0
Create XML with T-SQL function FOR XML
Posted in
  • T-SQL
  • XML

Create XML with T-SQL function FOR XML

Some time ago I demonstrated how to use XQuery to map a hierarchical XML document into … Create XML with T-SQL function FOR XMLRead more

by Tomas Lind•2015/09/142016/03/07•4
How to fill in gaps in time series
Posted in
  • T-SQL
  • Tips & Tricks

How to fill in gaps in time series

In some cases it is necessary to have an unbroken time series, for instance to have … How to fill in gaps in time seriesRead more

by Tomas Lind•2015/07/072015/06/29•2
Sending HTML tables in mail from SQL Server
Posted in
  • Database Mail
  • T-SQL
  • Tips & Tricks

Sending HTML tables in mail from SQL Server

This post contains a template for sending HTML tables via mail in T-SQL. A prerequisite is … Sending HTML tables in mail from SQL ServerRead more

by Tomas Lind•2015/06/262015/07/03•20
Mass editing of SQL Server objects
Posted in
  • Dynamic Management Objects
  • T-SQL
  • Tips & Tricks

Mass editing of SQL Server objects

Ever had the need to replace a piece of code in multiple SQL Server objects (Stored … Mass editing of SQL Server objectsRead more

by Tomas Lind•2014/12/102015/05/05•2
A T-SQL WHILE loop demonstration with BREAK and CONTINUE
Posted in
  • T-SQL

A T-SQL WHILE loop demonstration with BREAK and CONTINUE

Just a short blog post to demonstrate the use of a WHILE loop in T-SQL, together … A T-SQL WHILE loop demonstration with BREAK and CONTINUERead more

by Tomas Lind•2014/12/032014/11/28•4
T-SQL Pivot and Unpivot
Posted in
  • T-SQL

T-SQL Pivot and Unpivot

A simple demonstration of the Pivot and Unpivot functions in T-SQL.

by Tomas Lind•2014/11/262014/11/07•1
Max or min value from a set of columns
Posted in
  • T-SQL
  • Tips & Tricks

Max or min value from a set of columns

The min and max aggregates in SQL Server are normally used to work over rows, getting … Max or min value from a set of columnsRead more

by Tomas Lind•2014/08/162014/08/15•0

Posts pagination

1 2 3 Next

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • CDC Capture job
  • How to align columns in Notepad++

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software