Lab Sql

I have a table(competency) with 150+ data which can be inserted or updated by user at anytime. I wa… Read more Oracle Sql - Converting Rows Into Columns Dynamically

I have posted a pivot question before and it was answered. However, this particular case requires d… Read more Sql Server 2008 R2 - Dynamic Pivot/unpivot With (moving) Dates

I have a table(competency) with 150+ data which can be inserted or updated by user at anytime. I wa… Read more Oracle SQL - Converting Rows Into Columns Dynamically