Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
select [Shop ID] = H.ID, [Shop Name] = H.Name, CASE WHEN HFXC.LID = 1 THEN convert(NVARCHAR,HFXC.Comment) END AS [Facilities in English], CASE WHEN HFXC.LID = 2 THEN convert(NVARCHAR,HFXC.Comment) END AS [Facilities in French], CASE WHEN HFXC.LID = 3 THEN convert(NVARCHAR,HFXC.Comment) END AS [Facilities in Spanish], CASE WHEN HFXC.LID = 4 THEN convert(NVARCHAR,HFXC.Comment) END AS [Facilities in German] from lrs.Shop H with ( nolock ) left Join lrs.ShopFacility HFX With ( nolock ) on HFX.ShopID = H.ID left Join lrs.ShopFacilityComment HFXC With ( nolock ) on HFXC.ID = HFX.FacilityID left Join lrs.ShopStatus HS WITH ( NOLOCK ) ON HS.ID = H.StatusID where HS.ID = 2 and h.ID = 105 order by 3,4,5,6 desc
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Selecting only the rows where duplicates exist in specified columns within those rows||3||39|
|Display field if column exists||7||56|
|Better way to filter date - Query||5||44|
|T-SQL: Need a database plan to mine a pretty big Log table||4||47|
Join the community of 500,000 technology professionals and ask your questions.