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!
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
create spsomthing (@num varchar(20)=NULL ,@LastName varchar(30)=NULL ,@FirstName varchar(25)=NULL ) AS declare @searchint as int SELECT @searchint = case when NOT @num IS NULL then 1 when NOT @name IS NULL then 2 else 0 END SELECT DISTINCT * FROM MYTABLE WHERE CASE @searchint WHEN 1 THEN ( @num = MYTABLE.Num) WHEN 2 THEN ( @LastName = MYTABLE.Last OR @FirstName = MYTABLE.First ) END
|LTrim & Double Space Correction||5||40|
|qry in a qry worked by week ending date! how do I get it to work by weeks (y-t-d) instead of one week at a time?||25||56|
|How to execute a SQL Server Stored Procedure from an Access front-end?||15||31|
|MS SQL Delete Duplicate Rows Only||2||15|