I have this SQL Statement in an SP:
IF @Users_id = 0
INSERT INTO Users
(Company, LastName, FirstName, Address1, City, StateName,
ZipCode,
UserName, Password, ShowAdmin, Email, Department_ID)
VALUES
(@Company, @LastName, @FirstName, @Address1, @City, @StateName,
@ZipCode, @UserName, @Password, @ShowAdmin, @Email, @Department_ID)
SELECT FirstName, LastName, UserName, Password, Email
FROM Users
WHERE (Users_ID = SCOPE_IDENTITY())
ELSE
UPDATE Users
SET Company = CASE WHEN @Company IS NULL THEN Company ELSE @Company
END,
LastName = CASE WHEN @LastName IS NULL THEN LastName ELSE
@LastName END,
FirstName = CASE WHEN @FirstName IS NULL THEN FirstName ELSE
@FirstName END,
Address1 = CASE WHEN @Address1 IS NULL THEN Address1 ELSE
@Address1 END,
City = CASE WHEN @City IS NULL THEN City ELSE @City END,
StateName = CASE WHEN @StateName IS NULL THEN StateName ELSE
@StateName END,
ZipCode = CASE WHEN @ZipCode IS NULL THEN ZipCode ELSE @ZipCode
END,
UserName = CASE WHEN @UserName IS NULL THEN UserName ELSE
@UserName END,
Password = CASE WHEN @Password IS NULL THEN Password ELSE
@Password END,
LastLogin = CASE WHEN @LastLogin = 0 THEN LastLogin ELSE
@LastLogin END,
ShowAdmin = CASE WHEN @ShowAdmin = 0 THEN ShowAdmin ELSE
@ShowAdmin END,
Email = CASE WHEN @Email IS NULL THEN Email ELSE @Email END,
Department_ID = CASE WHEN @Department_ID = 0 THEN Department_ID
ELSE
@Department_ID END
WHERE Users_id = @Users_id
I am getting an error Incorrect syntax near the keyword else. This SP
worked fine until I introduced the second SELECT statement (SELECT
FirstName, LastName, ect...)
Thanks,
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3003
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
