Hi, 

To bulkify and stay in salesforce limit firstly you need to remove all soql queries form the for loop.

To builkifying you need to use data structures like map,set,list etc.

I hope below code snippet will help you in that.

if(Trigger.isUpdate)
{
	Projection_Multi_Year__c testObj = Trigger.new[0];
	List<Projection_Multi_Year__c> checkForDups = new List <Projection_Multi_Year__c>([select id from Projection_Multi_Year__c where
	account__c = :testObj.account__c and ownerID = :testObj.ownerID]);

	if(checkForDups.size() != 0){
		trigger.new[0].addError('Update dupe error');
	}
	else{
		String profileID = UserInfo.getProfileID();
		String profileName = [Select name from Profile where ID = :profileID].name;
		List<Projection_Multi_Year__c> pMutliYearList = Trigger.new;

		//For account
		Map<Projection_Multi_Year__c, String> pMutliYearAccountNameMap = new Map<Projection_Multi_Year__c, String>();
		Map<Projection_Multi_Year__c, Id> pMutliYearAccountIdMap = new Map<Projection_Multi_Year__c, Id>();

		//For User
		Map<Projection_Multi_Year__c, Id> pMutliYearOwnerMap = new Map<Projection_Multi_Year__c, Id>();
		Map<Projection_Multi_Year__c, String> pMutliYearOwnerNameMap = new Map<Projection_Multi_Year__c, String>();

		//For Manager
		Map<Projection_Multi_Year__c, String> pMutliYearManagerNameMap = new Map<Projection_Multi_Year__c, String>();

		// create map for Projection_Multi_Year__c and account Id, Projection_Multi_Year__c and User Id, 
		for(Projection_Multi_Year__c obj : pMutliYearList){
			pMutliYearAccountIdMap.put(obj, obj.Account__c);
			pMutliYearOwnerMap.put(obj,obj.ownerID);
		}


		// fetch all accounts
		Map<Id,Account> accMap = new Map<Id,Account>([select Id, name from Account where ID in :pMutliYearAccountIdMap.values()]);

		// create map for Projection_Multi_Year__c and account Name
		for(Projection_Multi_Year__c obj : pMutliYearAccountIdMap.keySet()){
			Id accId = pMutliYearAccountIdMap.get(obj);
			String accName = accMap.get(accId).Name;
			if(accName.length() > 80){
				accName = accName.substring(0,79);
			}
			pMutliYearAccountNameMap.put(obj, accName);
		}


		// fetch all Users
		Map<Id,User> userMap = new Map<Id,Account>([select ID,name,LHH_Zone__c,Region__c,ManagerID from User where ID in :pMutliYearOwnerMap.values()]);

		// create map for Projection_Multi_Year__c and Owner Name, Projection_Multi_Year__c and Manager Name
		for(Projection_Multi_Year__c obj : pMutliYearOwnerMap.keySet()){
			Id userId = pMutliYearOwnerMap.get(obj);
			String ownerName = userMap.get(userId).Name;
			if(ownerName.length() > 80){
				ownerName = ownerName.substring(0,79);
			}
			pMutliYearOwnerNameMap.put(obj, ownerName);
			pMutliYearManagerNameMap.put(obj,userMap.get(userId).ManagerID.Name);
		}


		//update the values of Projection_Multi_Year__c
		for(Projection_Multi_Year__c obj : pMutliYearList){
			String accountName = pMutliYearAccountNameMap.get(obj);
			String ownerName = pMutliYearOwnerNameMap.get(obj);
			String managerName = pMutliYearManagerNameMap.get(obj);

			obj.Projection_Name__c = accountName + ' - ' + divisionName + ' - ' + ownerName;
			String truncatedName = ownerName + ' - ' + accountName + ' - ' + divisionName;
			if(truncatedName.length() > 80){
				truncatedName = truncatedName.substring(0,79);
			}
			obj.Name = truncatedName;
			obj.Manager__c = managerName;
			obj.LHH_Zone__c = userMap.get(pMutliYearOwnerMap.get(obj)).LHH_Zone__c;
			obj.Country_Region__c = userMap.get(pMutliYearOwnerMap.get(obj)).Region__c;
		}
	}//end of else
}//end of if

Regards,

Purushottam

  
Contact me:  purushottam8688