Most of us play with dates pretty regularly in SQL adding days here, finding how many days between dates. What about if you need to start adding years. […]
Programming / SQL / Teradata
Posted on:
SQL – Table Skew(Teradata)
Ok this one is a Teradata speciality. Skew…. Before I go into any detail on Skew just a quick “how teradata works” to get everyone on the same […]
Programming / SQL / Teradata
Posted on:
Teradata gets Autonumber
Hey all, Just something I found that I thought I would share. Don’t know if anyone else had tried this before apart from myself, but Teradata was previously […]
Programming / SQL / Teradata
Posted on:
SQL – Convert
Need to replace a specific char in a string, say for example remove commas so you can export the file in CSV without hassles later on? Easy fix: […]
Programming / SQL / Teradata
Posted on:
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 […]
SQL
Posted on:
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 […]