June 22, 2007 at 4:09 pm
hi,
I have a stored procedure which i have broken down to this:
@userid uniqueIdentifier
AS
BEGIN
SET NOCOUNT ON;
SELECT
UserID,
ProjectID
FROM ProjectPermissions
WHERE UserID = @userid
however, when i attempt to execute the sp in Management Studio, i copy paste the UserID from another table to the parameter, only to incur an error:
Msg 168, Level 15, State 1, Line 5
The floating point value '9e39177' is out of the range of computer representation (8 bytes).
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'a'.
I tried another userID to incur another error:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'a1c36e8'.
Any suggestions?
Lee
June 23, 2007 at 6:38 pm
Are you enclosing the GUID in quotes when you pass it to the sp?
June 24, 2007 at 4:35 am
no, but i just tried and it works, thanks Dale
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply