Search Jobs Contact Us Register/Apply

RN - Registered Nurse/RN-ICU - Intensive Care Unit

Reference

7714

Contract Type

Part time

Specialty

ICU, Nursing (RN)

Town/City

Halifax

Salary

Competitive

Duration

1 Day(s)

Shift

Shift Type: 1st 8h;

Closing Date

11/11/21

Shift Type: 1st 8h;
The multi-part identifier "d_vacancies.k_id" could not be bound.

SELECT DISTINCT TOP 5 d_searchableVacs.l_vacID as k_id, (SELECT tx_altText FROM d_vacancies WHERE k_id = d_searchableVacs.l_vacID) as tx_altText, d_searchableVacs.tx_benefits,d_searchableVacs.d_date,d_searchableVacs.yn_featured, d_searchableVacs.yn_branded, d_searchableVacs.yn_urgentVac, d_searchableVacs.tx_ref, d_searchableVacs.tx_jobTitle, d_searchableVacs.l_clientID, d_searchableVacs.l_currencyID, d_searchableVacs.f_salMin, d_searchableVacs.f_salMax, d_searchableVacs.b_salaryType, d_searchableVacs.l_ote, d_searchableVacs.tx_duration, d_searchableVacs.yn_showClient, d_searchableVacs.tx_city, d_searchableVacs.yn_negotiable, d_searchableVacs.tx_locations,d_searchableVacs.tx_logoImage, d_searchableVacs.tx_sectors, d_searchableVacs.tx_listItems, d_searchableVacs.tx_duration, (SELECT COUNT(k_id) as appCount FROM d_applicationItems WHERE l_itemID = d_searchableVacs.k_id) as vacAppCount, d_searchableVacs.yn_passportReq ,'' as distance, d_searchableVacs.l_agencyEmployerID FROM d_searchableVacs INNER JOIN x_vacLocations ON d_searchableVacs.l_vacID = x_vacLocations.l_vacID INNER JOIN x_vacSectors ON d_searchableVacs.l_vacID = x_vacSectors.l_vacID INNER JOIN l_durations ON d_searchableVacs.l_durationID = l_durations.k_id WHERE d_searchableVacs.l_vacID <> 11956 AND (x_vacLocations.l_locationID IN (select x_vacLocations.l_locationID FROM x_vacLocations WHERE l_vacID = 11956) ) AND (l_sectorID IN (select x_vacSectors.l_sectorID FROM x_vacSectors WHERE l_vacID = 11956) ) AND (l_durationID = (SELECT l_durationID FROM d_vacancies WHERE k_id = 11956)) ORDER BY yn_branded DESC, yn_featured DESC, d_vacancies.k_id DESC