Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.
use Nas Select datename(mm,Application_Date) as ApplicationMonth, year(Application_Date) as ApplicationYear, A.Application_ID, --Case When ApplicationApplicant.Applicant_ID 'is null' then 'Indv' else 'joint' end as 'AppInd' ApplicationApplicant.Applicant_ID --ApplicantCompany.Applicant_ID from dbo.Application A left join ApplicationApplicant on ApplicationApplicant.Application_ID = A.Application_ID left join ApplicantCompany on ApplicantCompany.Application_ID = A.Application_ID left join Applicant on Applicant.Applicant_ID = ApplicationApplicant.Applicant_ID left join Applicant Ap on Ap.Applicant_ID = ApplicantCompany.Applicant_ID where Application_Date Between '2010-12-01 00:00:00' and '2010-12-31 23:59:59' order by 3
|Record open by another user||6||74|
|SSRS report parameters set after publishing to report manager||1||73|
|SQL Trigger or Function that updates table with old values||5||54|
|Urgent help needed! Unable to to paste in query designer||29||55|