Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
This is what I have so far, but,not sure how to produce the results below: SELECT MaintenanceID, MaintenanceWorkOrder, AutoMake, MaintenanceSystem, MaintenanceDescription CASE WHEN MaintenanceDescription IS NOT NULL THEN ''X'' ELSE '''' END AS x FROM dbo.qryMaintDescAnalysis I abbrv. the names to fit in the window. MaintID MaintWorkOrder AutoMake MaintSystem MaintDescription MaintInclude 1 22233 Kia Brake Change Rotors X 2 22223 Dodge Brake Null 3 11123 Mazda Brake Change Brake Pads X 4 1580 Kia 30,000 Mile Checkup Change Brake Pads X 5 23570 Volvo AC Repair AC Controls X
|Multiple Max Statements||11||21|
|mysql copy entire column to a new one||3||33|
|using case when with count and partition by functions in an oracle query||7||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!