With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
/* Type Codes Account - 1 Appointmenet - 4201 Opportunity - 3 */ SELECT Subject, RegardingObjectIdName, Description, CreatedByName, ScheduledEnd, ActualEnd, CreatedOn, RegardingObjectTypeCode, [Regarding]=CASE WHEN RegardingObjectTypeCode='1' THEN 'Account' WHEN RegardingObjectTypeCode='4201' THEN 'Appointment' WHEN RegardingObjectTypeCode='3' THEN 'Opportunity' ELSE 'n/a' END, [Opportunity Count]= SELECT COUNT(*) FROM dbo.Opportunity o WHERE StateCode='0' AND o.AccountId=RegardingObjectId FROM dbo.Appointment ORDER BY ScheduledEnd desc
|SQL Select JOIN table||2||23|
|SQL Server Question||5||28|
|T-SQL: What won't it just collapse? It would be the logical thing to do!||20||46|
|SQL Server memory sizing - reallocation||16||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!