Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
¿SELECT DISTINCT Builder, Community,Charts, CASE WHEN WorkByCommunity.workscheduletypeid=3 Or WorkByCommunity.workscheduletypeid=4 Or WorkByCommunity.workscheduletypeid=5 THEN 'Y' ELSE '' END as Flooring, CASE WHEN WorkByCommunity.workscheduletypeid=10 THEN 'Y' ELSE '' END as ArcStone, CASE WHEN WorkByCommunity.workscheduletypeid=11 THEN 'Y' ELSE '' END as BathAccessories, CASE WHEN WorkByCommunity.workscheduletypeid=15 THEN 'Y' ELSE '' END as WindowTreatments, CASE WHEN WorkByCommunity.workscheduletypeid=12 Or WorkByCommunity.workscheduletypeid=13 Or WorkByCommunity.workscheduletypeid=14 THEN 'Y' ELSE '' END as Specialties FROM BuilderCommunity LEFT OUTER JOIN WorkByCommunity ON BuilderCommunity.BuilderCommunityID = WorkByCommunity.BuilderCommunityID WHERE BuilderCommunity.Status = 'Active' ORDER BY Builder, Community
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Server Extended Events: list of deadlocks growing too long - how to cleanup?||23||58|
|Powershell error using sql agent job||24||31|
|mysql workbecn having problems to export tables to cvs||4||20|
|Section based report in SSRS||14||14|
Join the community of 500,000 technology professionals and ask your questions.