YTD & QTD using T-SQL(SQL Server) & PL/SQL(Oracle)
In the Post I’m explaining the way to calculate YTD & QTD against SQL & Oracle environment with Month as the granular level. The source for the queries was fed by using the WITH Clause. The…...
12 Years Ago
Scientific Reason: Why to visit Temples?
I came across this content while surfing, I would like to factor this interesting information in my Blog. Please read and enjoy!!!. There are thousands of temples all over India in different size, …...
12 Years Ago
Pivoting Data using T-SQL and SSIS Pivot Transformation
Pivot Data Using T-SQL Microsoft has introduced the Pivot and Unpivot relational operators in T-SQL with the release of MS SQL Server 2005. The Pivot operator is used to transform and rotate data f…...
13 Years Ago
SAP BO Basics: Changing the name of an existing Universe
The following is the procedure to change the name of an existing universe, 1. It is advisable to take a copy of the original version of the Universe which name needs to be changed. 2. Open the orig…...
13 Years Ago
Good things to lead a good life
Health Drink plenty of water. Eat breakfast like a king, lunch like a prince and dinner like a beggar. Eat more foods that grow on trees and plants, and eat less food that is manufactures in plants…...
14 Years Ago
Enabling SQL Server 2008 database to accept the changes made in a table
The SQL Server 2008 Management Studio will throw the following warning message when we tried to save the modification done in an existing table. It won’t allow us to save the changes in the table. â...
15 Years Ago
