Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.
CREATE PROCEDURE sprGetUserInfo
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
IF NOT EXISTS(SELECT TOP 1 ID FROM table2 WHERE userid = @UserID)
--Insert first record
INSERT INTO table2 (userid,currentad_id)VALUES (@UserID,1)
UPDATE table2 SET currentad_id = currentad_id+1 WHERE userid = @UserID
SELECT table1.*, table2.currentad_id FROM table1 INNER JOIN table2 ON table1.userid = table2.userid WHERE table1.userid = @UserID
Open in new window
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
INSERT YourTable(UserID, ID2)
SELECT TOP 1
SELECT @UserID, 1 ID2
SELECT TOP 1
@UserID, ID2 + 1
WHERE UserID = @UserID
ID2 DESC) x
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.