I need to find - given student has reached the CurrentQulificationStandard or not ?
* Current Qualification standard is B-3006 . Since the date is <=GETDATE() AND MAX(Sequencenumber)=3 and STATUS=Y
In this above list three of them reached the current qualification standard
118 , 188 , 125
For achieving this I am using following query. Is this correct ? How do I optimize this ?
SELECT count(*) FROM StudentList WHERE StudentId =125 AND Qualified_Standard
SELECT CurrentQulificationStandard FROM student WHERE status='Y' AND date<=GETDATE() AND SequenceNumber
IN (SELECT MAX(SequenceNumber) FROM student WHERE status='Y' AND date<=GETDATE() ))
Above query returns the count value to 1 so he is qualified
But student 123 is not qualified . so it will return 0
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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Two types of users will appreciate AOMEI Backupper Pro:
1 - Those with PCIe drives (and haven't found cloning software that works on them).
2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email
Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…