uniqueidentifier as parameter - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

uniqueidentifier as parameter

Author

Topic

dartoie
Starting Member

2 Posts

Posted - 2009-06-22 : 08:24:50

I try to write the followin stored procedure (adp project access):
ALTER PROCEDURE dbo.sp_FTWEHazards @pFTWID uniqueidentifier,
@taal varchar(2) AS

DECLARE @sql nvarchar(4000)
SELECT @sql = ' SELECT dbo.tblHazards.' + @taal + ', dbo.tblCombination.Yes, dbo.tblCombination.No, dbo.tblCombination.HazardDetail,
dbo.tblCombination.Comment, dbo.tblCombination.PhotoLink, dbo.tblTasks.TaskDescription,
dbo.tblTaskSteps.TaskStepDescription, dbo.tblFunctions.FunctionDescription, dbo.tblCombination.FTWID,
dbo.tblWorkEquipment.WorkEquipmentDescription '
SELECT @sql = @sql + 'FROM dbo.tblTaskSteps INNER JOIN
dbo.tblTasks ON dbo.tblTaskSteps.TaskID = dbo.tblTasks.TaskID INNER JOIN
dbo.tblCombination INNER JOIN
dbo.tblHazards ON dbo.tblCombination.HazardID = dbo.tblHazards.HazardID INNER JOIN
dbo.tblFTW ON dbo.tblCombination.FTWID = dbo.tblFTW.FTWID INNER JOIN
dbo.tblFunctions ON dbo.tblFTW.FunctionID = dbo.tblFunctions.FunctionID ON
dbo.tblTaskSteps.TaskStepID = dbo.tblFTW.TaskStepID INNER JOIN
dbo.tblWorkEquipment ON dbo.tblFTW.WorkEquipmentID = dbo.tblWorkEquipment.WorkEquipmentID '
SELECT @sql = @sql + ' WHERE tblCombination.FTWID = ''' + @pFTWID + ''''
SELECT @SQL = @sql + 'ORDER BY dbo.tblHazards.' + @taal + ''
EXEC(@sql)

I got the message: "ADO error: invalid operator for data type. Operator equals add, type equals uniqueidentifier".
Can anybody help me with this problem ?

SQLRatankalwa
Starting Member

42 Posts

Posted - 2009-06-22 : 08:40:56

Convert the Unique Identifier to a Varchar, That should fix the problem

Ratan Kalwa
SQL Server Professionals User Group

http://www.revalsys.com

raky
Aged Yak Warrior

767 Posts

Posted - 2009-06-22 : 08:43:26

try this

ALTER PROCEDURE dbo.sp_FTWEHazards @pFTWID uniqueidentifier,
@taal varchar(2) AS

DECLARE @sql nvarchar(4000)
SELECT @sql = ' SELECT dbo.tblHazards.' + @taal + ', dbo.tblCombination.Yes, dbo.tblCombination.No, dbo.tblCombination.HazardDetail,
dbo.tblCombination.Comment, dbo.tblCombination.PhotoLink, dbo.tblTasks.TaskDescription,
dbo.tblTaskSteps.TaskStepDescription, dbo.tblFunctions.FunctionDescription, dbo.tblCombination.FTWID,
dbo.tblWorkEquipment.WorkEquipmentDescription '
SELECT @sql = @sql + 'FROM dbo.tblTaskSteps INNER JOIN
dbo.tblTasks ON dbo.tblTaskSteps.TaskID = dbo.tblTasks.TaskID INNER JOIN
dbo.tblCombination INNER JOIN
dbo.tblHazards ON dbo.tblCombination.HazardID = dbo.tblHazards.HazardID INNER JOIN
dbo.tblFTW ON dbo.tblCombination.FTWID = dbo.tblFTW.FTWID INNER JOIN
dbo.tblFunctions ON dbo.tblFTW.FunctionID = dbo.tblFunctions.FunctionID ON
dbo.tblTaskSteps.TaskStepID = dbo.tblFTW.TaskStepID INNER JOIN
dbo.tblWorkEquipment ON dbo.tblFTW.WorkEquipmentID = dbo.tblWorkEquipment.WorkEquipmentID '
SELECT @sql = @sql + ' WHERE tblCombination.FTWID = ''' + CAST(@pFTWID AS VARCHAR(800))+ ''''
SELECT @SQL = @sql + 'ORDER BY dbo.tblHazards.' + @taal + ''
EXEC(@sql)

dartoie
Starting Member

2 Posts

Posted - 2009-06-22 : 08:54:30

Thanks a lot guys, works like heaven

raky
Aged Yak Warrior

767 Posts

Posted - 2009-06-22 : 12:41:09

welcome....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources