I want to use a Case statement to pull a row or rows based on a criteria. If the criteria is not met I want to retrieve all values for the field. This is what i have so far...I am struggling on how to pull all rows in the else statement
Select * from payroll
OFFICEID = 10 THEN BOB101
'I NEED TO PULL IN ALL ROWS
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…