I was tasked to create a query for an accounting journal entry from a transaction table with only amounts indicated, so if it’s a journal entry there should be a credit and debit but most of the other values will be similar, so I thought of extracting 2 rows from a single row through SQL… Read More »
Have you ever wondered how to perform the same query on different servers without going to each of the SQL Servers? Well I was presented this scenario just a while ago because I wanted to know what versions of SQL we are running and first thing I thought of is using the command
Here are some useful information for those who knows TSQL and wants to learn PL/SQL. Lets start with the data types
This week I have a lot of good challenges in SQL as we are building an SSIS package to unify data from different systems like Solomon, Raisers Edge, Goldmine, etc. A part of that SSIS Package is to cleanse the data and the toughest to cleanse is the addresses (which means putting the correct data… Read More »
Have you ever wondered how to clean fields in SQL, usually you have to LTRIM and RTRIM on each Field Object on your select statement which I used to do before when I was starting with SQL years ago, but in case you dont know there is what you call custom function. Heres how it… Read More »