Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into @result
- select
- id id,
- isnull(phone, '<i>Нет телефона</i>') phone,
- '<a href="/human/'+cast(id as nvarchar)+'" class="btn btn-info ">'+ isnull(fio, '') + '</a>' fio,
- iif(freelancer=1, 1, 0) freelancer,
- isnull((select name from hr_statuses where id = statusID), '') statusID
- from hr_humans
- where (@filterItemID is null or @filterItemID=depID) -- если не задан itemID - то берем всех
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement