select * from tbl_jobs where companycode=15117 and datediff(d,tbl_jobs.jobdate,getdate())<=
Elmo Motion Control
Founded in 1988, Elmo Motion Control is an innovative provider of feature rich motion control products for machine manufacturers. Elmo designs, produces and markets network-based motion controllers, intelligent digital servo drives and highly efficient servo amplifiers for both brush and brushless motors. Elmo's drives offer the highest power density in an extremely compact package. The company's product offering is divided into two major product families: SimplIQ for general purpose motion control applications and ExtrIQ for applications operating under extended environmental conditions. Elmo's innovative SimplIQ Motion Control Technology is incorporated into its digital servo drives and provides a wide range of motor feedback op
SELECT Count(*) FROM tbl_Jobs where jobdate >=getdate()-30 and hotjob=1 select top 4 jobCode,jobName,maincat,categoryCode,Directory, companyName2,CompanyLogo from (select jobdate,tbl_Jobs.jobCode,jobName,maincat,companyName2,CompanyLogo,tbl_JobsToCategories.categoryCode,Directory ,row_number() over (partition by tbl_JobsToCategories.JobCode, Directory order by tbl_JobsToCategories.JobToCategoryCode) num from tbl_Jobs join tbl_Companies on tbl_Jobs.CompanyCode=tbl_Companies.CompanyCode join tbl_JobsToCategories on tbl_Jobs.jobcode=tbl_JobsToCategories.jobcode INNER JOIN dbo.tbl_Categories on tbl_JobsToCategories.categorycode = tbl_Categories.categorycode where jobdate >=getdate()-30 and hotjob=1) a where num=1 order by jobdate descNumJobs=-1NumJobs=14
