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.
select donor_id, donation_procedure, CASE donation_procedure WHEN donation_procedure IN ('PL', 'PE', 'PR', 'PP', 'RP','DR', 'LV', 'WB', 'HH', 'AU', 'CU', 'SM', 'Q0', 'TH' THEN 'REDCELL' WHEN (donation_procedure IN ('PL', 'PE', 'PR', 'PP', 'PR')) AND (donation_procedure) NOT IN ('DR', 'LV', 'WB', 'HH', 'AU', 'CU', 'SM', 'Q0', 'TH')) THEN 'APHERESIS' ELSE 'UNKNOWN' END from TABLE_INFO where (collection_date >= DATEADD(day, - 365, GETDATE())) group by donor_id, donation_procedure order by donor_id
|How to identify differences between 2 backup files?||7||31|
|T-SQL: Why can you not SUM on a CASE statement, for crying out loud?||2||29|
|Updating a table from a temp table||4||28|
|SQL Field Length for Email Address||3||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!