Shaneesh Patel is still waiting for you to join Twitter...

Shaneesh Patel is still waiting for you to join Twitter...     Accept invitation           You can stop getting these emails with people you may know (PYMK) suggestions at anytime. Learn more about PYMK suggestions or find other answers at Twitter's Help Center. Twitter, Inc. 1355 Market St., Suite 900 San Francisco, CA 94103

Shaneesh Patel sent you an invitation

Shaneesh Patel has invited you to join Twitter!     Accept invitation           You can stop getting these emails with people you may know (PYMK) suggestions at anytime. Learn more about PYMK suggestions or find other answers at Twitter's Help Center. Twitter, Inc. 1355 Market St., Suite 900 San Francisco, CA 94103

MSP Institute on Facebook

Shaneesh Patel likes

MSP Institute

Create your Like Badge

On Page SEO vs. Off Page SEO Defined

What is On Page SEO?

On Page SEO is the science of optimizing the contents of a website such that it becomes friendlier to the search engines. This technique includes the optimization of texts, images, tags, URL structure, internal links, headers etc. Optimizing anything for search engine that is uploaded to your website’s domain is treated as on page SEO. For example selecting the proper ALT tag keyword for an image on a webpage is such type of SEO. In a simple definition On Page Optimization is what can be done on the pages of a website in order to make it more search engine friendly to achieve good search engine ranking for targeted keywords. 

Important Components of On-Page SEO

Here are some important on page optimization components that take crucial part in the improvement of any website.

1. Proper Post Title (H1 tags)

2. ALT Tags (Must use proper ALT tags with targeted keywords)

3. URL structure (One of the most important part in SEO, must contain your main keyword)     

4. Meta Description Tag

5. Keyword Density

6. XML sitemap

7. Proper Content (Should be unique)

8. Internal Linking Strategy (Related articles must be properly interlinked within the website)

9. Proper HTML and CSS validation

10. Title Tags

On Page search engine optimization is the most important part in the process of SEO. It is said that if on page SEO is perfect 70% job of the SEO is done and rest depends on the off page SEO. 

 

What is Off Page SEO?

Off page SEO is defined as the things you do offline to your website in order to achieve good search engine ranking. In simple definition off page optimization does not involve any optimization with the contents of the webpage instead it is the optimization which is done offsite the web contents. For example building quality links to improve the page rank of your website is such type of optimization. It is basically building reputation of your website in front of search engines like Google. So here you do not do anything with the content of the webpage.

Off page SEO holds almost 30% of the overall SEO process. There are several factors that affect the off page SEO and those are listed below.

Factors Affecting Off Page SEO 

1. Quality Link Building (In order to improve page ranking)

2. Social Media Presence of your website

This means how active is your website among various social media like Digg, Facebook, Google+, Twitter and many other social media. The active presence of your website over popular social media increases the brand value as well as reputation of your website with respect to search engine’s algorithms. This includes social book marking also.      

3. Directory Submission (Especially from DMOZ.org)

4. Forum Postings

Forum posting impacts a lot in offsite optimization. If you participate in forum posting and posts questions or answer to any questions then you are getting a chance to get a good quality link from the forum to your website which improves the page ranking.

So these are the On page and Off page SEO and the factors affecting them. In next article I will publish some important tips for the on page SEO for your blog and website in order to get a good search ranking. 

Head Meage Query in HRMS One Column Amt to Other Column Amount

--exec SPM_HEAD_MEARGE_A00001_TO_A00004

ALTER PROCEDURE [dbo].[SPM_HEAD_MEARGE_A00001_TO_A00004]
   
AS  
BEGIN  
 declare @PAY_REGI_M_MASTER_ID varchar(20);  
 declare @PAY_REGI_M_DTLS_ALLOW_ID char(6);  
 declare @PAY_BASIC_PER numeric(18, 2);  
 declare @PAY_REGI_M_DTLS_AMOUNT float;  
 declare @PAY_REGI_M_DTLS_CHGD_ID char(8);  
 declare @PAY_REGI_M_DTLS_CHGD_DATE datetime;  
 declare @PAY_REGI_M_DTLS_YEARLY_CAL varchar(1);  
 Declare @New_Allowance_Amount numeric(18,2);  
 declare @New_Allowance_Amount_Sum numeric(18,2);  
   
 Declare c1_log cursor for  
 select PAY_REGI_M_MASTER_ID,PAY_REGI_M_DTLS_ALLOW_ID,PAY_BASIC_PER,PAY_REGI_M_DTLS_AMOUNT  
   PAY_REGI_M_DTLS_CHGD_ID,PAY_REGI_M_DTLS_CHGD_ID,PAY_REGI_M_DTLS_CHGD_DATE,PAY_REGI_M_DTLS_YEARLY_CAL  
 from TBL_PAY_REGI_MASTER_DTLS  
   
 open c1_log;  
 fetch next from c1_log  
 into @PAY_REGI_M_MASTER_ID,  
   @PAY_REGI_M_DTLS_ALLOW_ID,  
   @PAY_BASIC_PER,  
   @PAY_REGI_M_DTLS_AMOUNT,  
   @PAY_REGI_M_DTLS_CHGD_ID,  
   @PAY_REGI_M_DTLS_CHGD_DATE,  
   @PAY_REGI_M_DTLS_YEARLY_CAL  
   
 while @@fetch_status = 0  
 BEGIN--while begin  
 
 
   if @PAY_REGI_M_DTLS_ALLOW_ID = 'A00001'  
   BEGIN--main if begin  
    set @New_Allowance_Amount = 2;  
    SELECT @New_Allowance_Amount = PAY_REGI_M_DTLS_AMOUNT from TBL_PAY_REGI_MASTER_DTLS    
    WHERE PAY_REGI_M_DTLS_ALLOW_ID = 'A00004' and PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID  
    print @New_Allowance_Amount;  
    if @New_Allowance_Amount = 2  
    BEGIN    
     print 'If in';  
     INSERT into TBL_PAY_REGI_MASTER_DTLS  
        (PAY_REGI_M_MASTER_ID,  
         PAY_REGI_M_DTLS_ALLOW_ID,  
         PAY_BASIC_PER,  
         PAY_REGI_M_DTLS_AMOUNT,  
         PAY_REGI_M_DTLS_CHGD_ID,  
         PAY_REGI_M_DTLS_CHGD_DATE,  
         PAY_REGI_M_DTLS_YEARLY_CAL)    
     values  (@PAY_REGI_M_MASTER_ID,  
         'A00004',  
         0,  
         @PAY_REGI_M_DTLS_AMOUNT,  
         @PAY_REGI_M_DTLS_CHGD_ID,  
         @PAY_REGI_M_DTLS_CHGD_DATE,  
         @PAY_REGI_M_DTLS_YEARLY_CAL)  
     delete from TBL_PAY_REGI_MASTER_DTLS  
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID and  
       PAY_REGI_M_DTLS_ALLOW_ID = 'A00001'  
         
    END    
    ELSE  
    BEGIN  
     print 'Else in';  
     set @New_Allowance_Amount_Sum = 0;  
     set @New_Allowance_Amount_Sum = @New_Allowance_Amount + @PAY_REGI_M_DTLS_AMOUNT;  
     update TBL_PAY_REGI_MASTER_DTLS    
     set PAY_REGI_M_DTLS_AMOUNT = @New_Allowance_Amount_Sum    
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID AND  
        PAY_REGI_M_DTLS_ALLOW_ID = 'A00004'

delete from TBL_PAY_REGI_MASTER_DTLS  
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID and  
       PAY_REGI_M_DTLS_ALLOW_ID = 'A00001'  
    END  
   END--main if end  
 

 
 fetch next from c1_log  
 into @PAY_REGI_M_MASTER_ID,  
   @PAY_REGI_M_DTLS_ALLOW_ID,  
   @PAY_BASIC_PER,  
   @PAY_REGI_M_DTLS_AMOUNT,  
   @PAY_REGI_M_DTLS_CHGD_ID,  
   @PAY_REGI_M_DTLS_CHGD_DATE,  
   @PAY_REGI_M_DTLS_YEARLY_CAL  
 END--while end  
 close c1_log;  
 deallocate c1_log;  
-----

USE [HRMS_DB_RESTORE]
GO
/****** Object:  StoredProcedure [dbo].[SPM_HEAD_MEARGE_A00011_TO_A00051]    Script Date: 01/20/2014 13:06:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


--exec SPM_HEAD_MEARGE_A00011_TO_A00051

ALTER PROCEDURE [dbo].[SPM_HEAD_MEARGE_A00011_TO_A00051]
   
AS  
BEGIN  
 declare @PAY_REGI_M_MASTER_ID varchar(20);  
 declare @PAY_REGI_M_DTLS_ALLOW_ID char(6);  
 declare @PAY_BASIC_PER numeric(18, 2);  
 declare @PAY_REGI_M_DTLS_AMOUNT float;  
 declare @PAY_REGI_M_DTLS_CHGD_ID char(8);  
 declare @PAY_REGI_M_DTLS_CHGD_DATE datetime;  
 declare @PAY_REGI_M_DTLS_YEARLY_CAL varchar(1);  
 Declare @New_Allowance_Amount numeric(18,2);  
 declare @New_Allowance_Amount_Sum numeric(18,2);  
   
 Declare c1_log cursor for  
 select PAY_REGI_M_MASTER_ID,PAY_REGI_M_DTLS_ALLOW_ID,PAY_BASIC_PER,PAY_REGI_M_DTLS_AMOUNT  
   PAY_REGI_M_DTLS_CHGD_ID,PAY_REGI_M_DTLS_CHGD_ID,PAY_REGI_M_DTLS_CHGD_DATE,PAY_REGI_M_DTLS_YEARLY_CAL  
 from TBL_PAY_REGI_MASTER_DTLS  
   
 open c1_log;  
 fetch next from c1_log  
 into @PAY_REGI_M_MASTER_ID,  
   @PAY_REGI_M_DTLS_ALLOW_ID,  
   @PAY_BASIC_PER,  
   @PAY_REGI_M_DTLS_AMOUNT,  
   @PAY_REGI_M_DTLS_CHGD_ID,  
   @PAY_REGI_M_DTLS_CHGD_DATE,  
   @PAY_REGI_M_DTLS_YEARLY_CAL  
   
 while @@fetch_status = 0  
 BEGIN--while begin  
 
 
   if @PAY_REGI_M_DTLS_ALLOW_ID = 'A00011'  
   BEGIN--main if begin  
    set @New_Allowance_Amount = 1;  
    SELECT @New_Allowance_Amount = PAY_REGI_M_DTLS_AMOUNT from TBL_PAY_REGI_MASTER_DTLS    
    WHERE PAY_REGI_M_DTLS_ALLOW_ID = 'A00051' and PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID  
    print @New_Allowance_Amount;  
    if @New_Allowance_Amount = 1  
    BEGIN    
     print 'If in';  
     INSERT into TBL_PAY_REGI_MASTER_DTLS  
        (PAY_REGI_M_MASTER_ID,  
         PAY_REGI_M_DTLS_ALLOW_ID,  
         PAY_BASIC_PER,  
         PAY_REGI_M_DTLS_AMOUNT,  
         PAY_REGI_M_DTLS_CHGD_ID,  
         PAY_REGI_M_DTLS_CHGD_DATE,  
         PAY_REGI_M_DTLS_YEARLY_CAL)    
     values  (@PAY_REGI_M_MASTER_ID,  
         'A00051',  
         0,  
         @PAY_REGI_M_DTLS_AMOUNT,  
         @PAY_REGI_M_DTLS_CHGD_ID,  
         @PAY_REGI_M_DTLS_CHGD_DATE,  
         @PAY_REGI_M_DTLS_YEARLY_CAL)  
     delete from TBL_PAY_REGI_MASTER_DTLS  
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID and  
       PAY_REGI_M_DTLS_ALLOW_ID = 'A00011'  
         
    END    
    ELSE  
    BEGIN  
     print 'Else in';  
     set @New_Allowance_Amount_Sum = 0;  
     set @New_Allowance_Amount_Sum = @New_Allowance_Amount + @PAY_REGI_M_DTLS_AMOUNT;  
     update TBL_PAY_REGI_MASTER_DTLS    
     set PAY_REGI_M_DTLS_AMOUNT = @New_Allowance_Amount_Sum    
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID AND  
        PAY_REGI_M_DTLS_ALLOW_ID = 'A00051'

delete from TBL_PAY_REGI_MASTER_DTLS  
     where PAY_REGI_M_MASTER_ID = @PAY_REGI_M_MASTER_ID and  
       PAY_REGI_M_DTLS_ALLOW_ID = 'A00011'  
    END  
   END--main if end  
 

 
 fetch next from c1_log  
 into @PAY_REGI_M_MASTER_ID,  
   @PAY_REGI_M_DTLS_ALLOW_ID,  
   @PAY_BASIC_PER,  
   @PAY_REGI_M_DTLS_AMOUNT,  
   @PAY_REGI_M_DTLS_CHGD_ID,  
   @PAY_REGI_M_DTLS_CHGD_DATE,  
   @PAY_REGI_M_DTLS_YEARLY_CAL  
 END--while end  
 close c1_log;  
 deallocate c1_log;  
   
   
   
   
END