|
my stored procedure is :
USE [CRM-CMSAlmas]
GO
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 ?
|
|
|
|
|
You probably renamed the proc and the sp_help has not refreshed the name.
If one of my devs named a proc like that he would get a first warning, there would be no second.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks in advanced but the sp was renamed before and now its working properly!
but when i right click the sp and click on modify is diffrent from sp_helptext. and event the name of it in sp list is also different from sp_helptext !
But i dont get why this is happing@
|
|
|
|
|
Try updating your statistics, "UPDATE STATISTICS..." This may not do anything but it might help
|
|
|
|
|
|
Try logic; you renamed it?
Drop it, and create it anew?
|
|
|
|
|
HOW TO MAKE ACCESS CHECK THE WHOLE RECORD FORM THE OTHER TABLES
I WANT TO CHECK THREE FIELDS IN TABLE FROM ANOTHER TABLE DURING DATA ENTRY
|
|
|
|
|
DO NOT SHOUT when asking a question. When you use all capital letters it is seen as shouting on the Internet and considered rude. Next time when posting a question please use proper capitalization.
0100000101101110011001000111001011101001
|
|
|
|
|
|
hi everybody I need to do something like that:
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
obviously it doesnt work!, but I'm looking for suggestions
modified 26-Nov-12 10:42am.
|
|
|
|
|
Something like this should do the trick.
Select ProductName, MySum, field2
From (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) as q
Where MySum - field2 > 0
|
|
|
|
|
Add Group By ProductName, Field2
after the where clause
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi everyone! I need to grant permission on a table in a database to a database role in another database.
I have client database containing information about clients. In another database, I have roles for different departments. Now I need to grant permission on specific tables in the client database to roles or departments which are located in another database.
I have been struggling for a solution but have not succeeded. Is there any way to accomplish this task? Please help.
|
|
|
|
|
Dan_K wrote: Now I need to grant permission
Is some kind of permission problem ocurring now that wasn't occuring before? Maybe I'm missing the obvious.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.
|
|
|
|
|
Do some research into "replication" this may meet your needs or you can script the data transfer. There is no simple way to "merge" 2 databases. You may also look into Data Compare from Red Gate but I don't think that is going to be the tool.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
What database server are you using?
|
|
|
|
|
|
|
You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk
|
|
|
|
|
Yeah that's me, I have sql server express installed on my local machine so I can test stuff without polluting the development server. So I have not needed it for ages, not trying anything new on a database level recently.
Well now I want to create a test database and I mislaid the blasted sa password and I don't have enough rights on the dammed thing. Apparently the only was is to re install the database Gggrrrr
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Which is why you dont use SQL Authentication.
I feel your pain. Been there.
|
|
|
|
|
|
Now that I did not know, have 5 for he link, thank you, you have justified the rant...
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi every buddy
i hav e a problem to create new user in sql server 2008 r2
i create a user and my user created.
and i logined with this user succesfully. but when i want to create a new database in sqlserver authentication mode
i facing with this problem
"Create Database permission Denied in DataBase master.[error 262]"
thanks for any help.
|
|
|
|