Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
CREATE PROCEDURE [dbo].[Office_stats] @searchString varchar( 38 ) as IF @searchString IS NULL SET @searchString = '%' IF @searchString = 'LIKE ''%'' ' SET @searchString = '%' IF @searchString IS NOT NULL SET @searchString = SUBSTRING (@searchString , CHARINDEX ( ' ', @searchString ) + 1, LEN (@searchString )) SELECT * from employee left outer join OfficeEmps on employeeid = acempid and ( acchannelstatus = 'complete' or acchannelstatus = 'WaitForComplete') left outer join EmpsHistory on chempid = employeeid and chid is not null and chdistrict = '' left outer join officeNames history on chid= history .cnuid and chid is not null and chdistrict = '' where worklocation in( 'Blue Room Services' , 'Green States town' , 'Estats service' , 'Valley union' , 'pringles Office' , 'Eddies Office' , 'Bluntsville Center' , 'Palisdale Center' , 'Union Station Center' ) and deptid in( '523' ,'521' , '525', '529' ,'524' , '631') and worklocation LIKE @searchString Go PRINT @searchString Go
|Query Peformance + mulitple query plans||9||48|
|SQL Query resolving a string conversion issue||26||39|
|SQL Query stumper||3||37|
|Business Intelligence Software recommended for high level non-IT staff with non-update privileges on SQL Server||5||7|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!