Database

USE [CRM-CMSAlmas]
GO
/****** Object:  StoredProcedure [dbo].[tblVacationDaily_GetAllDetailsSenderReciverbyRecordIdANDJobIdAndStepId]    Script Date: 11/27/2012 13:07:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[tblVacationDaily_GetAllDetailsSenderReciverbyRecordIdANDJobIdAndStepId] 
(@RecordId INT,@JobId INT,@StepId int)
AS
BEGIN

SELECT     WF.Cartable.JobId, Forms.tblVacationDaily.Id,  Forms.tblVacationDaily.IsWorkFlow, Forms.tblVacationDaily.CreateUserID, 
                      Forms.tblVacationDaily.CreateDate, Forms.tblVacationDaily.StepId, Forms.tblVacationDaily.RecordId, Forms.tblVacationDaily.OrderId, Forms.tblVacationDaily.PersonId, 
                      WF.Cartable.ForwardedUserId, WF.Cartable.RecieveUserId, WF.Cartable.IsDeleted, p1.FullName AS RecieveUserName, p2.FullName AS ForwardedUserName, 
                      WF.Cartable.IsBack
FROM         WF.Cartable INNER JOIN
                      WF.JobFormConjuction ON WF.JobFormConjuction.JobId = WF.Cartable.JobId INNER JOIN
                      Forms.tblVacationDaily ON Forms.tblVacationDaily.RecordId = WF.JobFormConjuction.RecordId AND Forms.tblVacationDaily.StepId = WF.Cartable.StepID - 1 INNER JOIN
                      Persons.People AS p1 ON p1.Id = WF.Cartable.RecieveUserId INNER JOIN
                      Persons.People AS p2 ON p2.Id = WF.Cartable.ForwardedUserId
WHERE     (Forms.tblVacationDaily.RecordId = @RecordId) AND (WF.Cartable.JobId = @JobId) AND (Forms.tblVacationDaily.StepId<=@StepId)
END

but when i use <pre lang="SQL">EXEC sp_helptext [dbo.tblVacationDaily_GetAllDetailsSenderReciverbyRecordIdANDJobIdAndStepId]</pre><br />
<br />
the result is :[Note: I have change Create ----> Alert

Alter PROCEDURE [dbo].[tblVacationDaily_GetAllDetailsforSenderAndReciversbyRecordIdANDJobId] 
(@RecordId INT,@JobId INT,@StepId int)
AS
BEGIN

SELECT     WF.Cartable.JobId, Forms.tblVacationDaily.Id,  Forms.tblVacationDaily.IsWorkFlow, Forms.tblVacationDaily.CreateUserID, 
                      Forms.tblVacationDaily.CreateDate, Forms.tblVacationDaily.StepId, Forms.tblVacationDaily.RecordId, Forms.tblVacationDaily.OrderId, Forms.tblVacationDaily.PersonId, 
                      WF.Cartable.ForwardedUserId, WF.Cartable.RecieveUserId, WF.Cartable.IsDeleted, p1.FullName AS RecieveUserName, p2.FullName AS ForwardedUserName, 
                      WF.Cartable.IsBack
FROM         WF.Cartable INNER JOIN
                      WF.JobFormConjuction ON WF.JobFormConjuction.JobId = WF.Cartable.JobId INNER JOIN
                      Forms.tblVacationDaily ON Forms.tblVacationDaily.RecordId = WF.JobFormConjuction.RecordId AND Forms.tblVacationDaily.StepId = WF.Cartable.StepID - 1 INNER JOIN
                      Persons.People AS p1 ON p1.Id = WF.Cartable.RecieveUserId INNER JOIN
                      Persons.People AS p2 ON p2.Id = WF.Cartable.ForwardedUserId
WHERE     (Forms.tblVacationDaily.RecordId = @RecordId) AND (WF.Cartable.JobId = @JobId) AND (Forms.tblVacationDaily.StepId<=@StepId)
END
 Go

Now the BUG/ERROR :
The content is same but the names are diffrent :
[dbo].[tblVacationDaily_GetAllDetailsforSenderAndReciversbyRecordIdANDJobId] 

but the sp is :

[dbo].[tblVacationDaily_GetAllDetailsSenderReciverbyRecordIdANDJobIdAndStepId]

why the names are different ?

select x.ProductName, sum(x.field1+y.field2) as Mysum, y.field2 from tablexxx as x inner join tableyyy as y on x.id =y.id where as Mysum - y.field2 > 0