I would like to write a procedure to database which will return select all data from database `Tournaments` plus bool parameter. If user is registered, it will return `true`. 

Call:

```
exec TournamentsWithLoggedUser @user = 'asd123'

```

Procedure:

```
CREATE PROCEDURE [dbo].[TournamentsWithLoggedUser]
    @user  nvarchar(128)
AS
    SELECT 
        t.Id, t.Info, BIT(r.Id) 
    FROM  
        Tournaments AS t
    LEFT JOIN 
        Registrations AS r ON  t.Id = r.TournamentId
    WHERE
        r.UserId IS NULL OR r.UserId = @user

    RETURN

```

it mean something like

```
1, 'some info', true //1
2, 'some info2', false //2

```