Latest Blog Posts for Sujeev's Blog

• YTD & QTD using T-SQL(SQL Server) & PL/SQL(Oracle)
  on Apr 8, 2012 in PL/SQL T-SQL YTD & QTD
  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 Year-to-Date (YTD) and Quarter-to-Date (QTD) kind...
• YTD & QTD using T-SQL(SQL Server) & PL/SQL(Oracle)
  on Apr 8, 2012 in PL/SQL T-SQL YTD & QTD
  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 Year-to-Date (YTD) and Quarter-to-Date (QTD) kind...
• Scientific Reason: Why to visit Temples?
  on Apr 1, 2012 in Information Visiting Temple
  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, shape and locations but not all of them are considere...
• Scientific Reason: Why to visit Temples?
  on Apr 1, 2012 in Information Visiting Temple
  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, shape and locations but not all of them are considere...
• Pivoting Data using T-SQL and SSIS Pivot Transformation
  on May 16, 2011 in SSIS T-SQL Pivot Operator
  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 from a single column in to multiple columns (row to co...
• SAP BO Basics: Changing the name of an existing Universe
  on May 9, 2011 in SAP BO: Universe Designer Changing 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 original version; a. Rename the connection name. b. Renam...
• SAP BO Basics: Changing the name of an existing Universe
  on May 9, 2011 in SAP BO: Universe Designer Changing 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 original version; a. Rename the connection name. b. Renam...
• Good things to lead a good life
  on Jul 23, 2010 in Information Good Things...
  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 (factory). Live with 3 E’s – Energy, Enthusiasm...
• Enabling SQL Server 2008 database to accept the changes made in a table
  on Aug 25, 2009 in SQL Server Saving changes in a SQL Server 2008 database 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. Warning Message: “Saving changes is not permitted...
• Changing the default value of “Edit Top 200 Rows” – SQL Server 2008
  on Jul 2, 2009 in SQL Server Changing "Edit Top 200 Rows"
  The SQL Server 2005 Management Studio allows us to “Edit” and “View” the whole set of records in a table. But in SQL Server 2008 Management Studio, this flexibility was restricted. SQL Server 2008 by default allows us to selec...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment