How to get the email address from a table of user

Danish Habib

How to get a cascade value like the below scenirio

I have one table in which there are different users i have just the userid .I want to pass that user id to stored procedure and then get the COuntry Name of that user and then find the other person having the same country as the selected user have.????

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano11y ago
I'm not a SQL expert and I'm sure there's a better way to do this but typically you would likely need to do something like this in your SP:

DECLARE @CountryID INT
SELECT @CounrtyID = CounrtyID FROM Users WHERE UserID = @UserID
SELECT Email, Name FROM Users WHERE CountryID = @CountryID
+1
Danish Habib11y ago
Dear Maverick , I have just one table and in which i have these columns
Users(Userid,Name,Email,CountryID,UserRole)
Now In my asp.net Web form i just have a dropdown having the userid in it I want to pass that user ID to a stored procedure and then get the CountryID as a result and then pass that country ID to get all those users having that country ID and also their email .. did u get , I have a solution in vb.net which is that i have to create two function first will use its own stored procedure which get the userid as input and return the countryid as output and then i have to create another function which takes the COuntryID as paramters and return the users having the same country id and their emails also should be return but calling these two methods makes the process slow so i want DB solution
0
Vincent Maverick Durano11y ago
Is the country name resides within a separate table? Do you want to handle the result in store procedure?
0