SQL tips and coding

Teradata – Using a Date field and Coalesce

This is a simple one, but had me stumped for awhile. For those of you who haven’t used coalesce, it’s a handy bit of code which allows you to replace a NULL value with what ever you wish to use. I have used Coalesce plenty of time before, but normally for an integer, today I […]

SQL – Vertical Concatonation(Merging Rows in single field)

Not something that comes up often, but can be a hassle to workout the logic behind merging multiple rows into a single field. If your not sure what a vertical concatonation is here is an example – Table Item# Description 1 “This ” 2 “is ” 3 “how ” 4 “it ” 5 “works ” […]