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…...
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, …...
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…...
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…...
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…...
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. â...