Manually Changing Data in a Stored Procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Manually Changing Data in a Stored Procedure

Author

Topic

chad483
Starting Member

5 Posts

Posted - 2011-03-25 : 10:07:40

I have 2 databases which use stored procedures. In one database when I run the SP, I am allowed to edit the data. In my other database with a similar SP, I cannot. I can manually change the data in the tables though. What would cause this?

Alter Procedure [dbo].chad

(@Bench VARCHAR(6),
@Pattern VARCHAR(6)
)
As
SET NOCOUNT ON;
SELECT dbo.HOLE_INFORMATION.TIME_START,
dbo.HOLE_INFORMATION.ACTUAL_PATTERN,
dbo.HOLE_INFORMATION.ACTUAL_BLAST,
dbo.HOLE_INFORMATION.ACTUAL_NAME,
dbo.HOLE_POSITION.COLLAR_ELEVATION,
dbo.HOLE_INFORMATION.DESIGN_PATTERN,
dbo.HOLE_INFORMATION.DESIGN_BLAST,
dbo.HOLE_INFORMATION.DESIGN_NAME
FROM dbo.HOLE_INFORMATION INNER JOIN
dbo.HOLE_POSITION ON dbo.HOLE_INFORMATION.TIME_START = dbo.HOLE_POSITION.TIME_START

chad483
Starting Member

5 Posts

Posted - 2011-03-25 : 10:42:57

So, it appears I cannot edit data when I am joining 2 tables together, or at least the way I did it.

Is it possible to setup a stored procedure to get data from 2 or more tables and then edit the data manually?

Thanks
Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources