Click here to Skip to main content
12,404,178 members (74,988 online)
   

Database

 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 8:43
memberjschell28-Nov-12 8:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 1:03
memberDeepak Kumar1128-Nov-12 1:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 3:59
memberAmbiguousName27-Nov-12 3:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 13:13
memberjschell27-Nov-12 13:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 13:14
memberMycroft Holmes27-Nov-12 13:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 13:23
memberEddy Vluggen27-Nov-12 13:23 
AnswerRe: Best Approach For Designing Database Pin
Krishna Kumar Soni3-Dec-12 1:04
memberKrishna Kumar Soni3-Dec-12 1:04 
QuestionEXEC sp_helptext Pin
jojoba201126-Nov-12 22:43
memberjojoba201126-Nov-12 22:43 
my stored procedure is :

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
EXEC sp_helptext [dbo.tblVacationDaily_GetAllDetailsSenderReciverbyRecordIdANDJobIdAndStepId]

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 ?

AnswerRe: EXEC sp_helptext Pin
Mycroft Holmes26-Nov-12 23:30
memberMycroft Holmes26-Nov-12 23:30 
QuestionRe: EXEC sp_helptext Pin
jojoba201126-Nov-12 23:38
memberjojoba201126-Nov-12 23:38 
AnswerRe: EXEC sp_helptext Pin
djj5527-Nov-12 0:59
memberdjj5527-Nov-12 0:59 
QuestionRe: EXEC sp_helptext Pin
jojoba201127-Nov-12 3:09
memberjojoba201127-Nov-12 3:09 
AnswerRe: EXEC sp_helptext Pin
Eddy Vluggen27-Nov-12 13:33
memberEddy Vluggen27-Nov-12 13:33 
QuestionRECORD VALIDATION IN ACCESS Pin
teto26-Nov-12 5:19
memberteto26-Nov-12 5:19 
SuggestionRe: RECORD VALIDATION IN ACCESS Pin
André Kraak26-Nov-12 5:56
memberAndré Kraak26-Nov-12 5:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pin
djj5526-Nov-12 6:05
memberdjj5526-Nov-12 6:05 
Questionhow to compare an operation in where expression In sql Pin
GREG_DORIANcod26-Nov-12 4:29
memberGREG_DORIANcod26-Nov-12 4:29 
AnswerRe: how to compare an operation in where expression In sql Pin
s_magus26-Nov-12 5:20
members_magus26-Nov-12 5:20 
AnswerRe: how to compare an operation in where expression In sql Pin
Mycroft Holmes26-Nov-12 11:56
memberMycroft Holmes26-Nov-12 11:56 
Questiongrant permission on table in another database Pin
Dan_K26-Nov-12 3:55
memberDan_K26-Nov-12 3:55 
QuestionRe: grant permission on table in another database Pin
Chris Meech26-Nov-12 8:25
memberChris Meech26-Nov-12 8:25 
QuestionHow to mearge local database with server database Pin
Jitendra Parida198723-Nov-12 22:00
memberJitendra Parida198723-Nov-12 22:00 
AnswerRe: How to mearge local database with server database Pin
Mycroft Holmes23-Nov-12 22:17
memberMycroft Holmes23-Nov-12 22:17 
AnswerRe: How to mearge local database with server database Pin
djj5525-Nov-12 2:48
memberdjj5525-Nov-12 2:48 
GeneralRe: How to mearge local database with server database Pin
Jitendra Parida198725-Nov-12 18:13
memberJitendra Parida198725-Nov-12 18:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 28 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid