I am trying to find Students who got all possible different grades. If you receive an 18 you pass the course and the highest number is 30. Thus, if you have received 13 different grades which are higher than 17 you have in turn received all possible passing grades. The first query returns 0 rows and the second one returns
Tag: output
Having trouble wrapping my head around how to write a particular loop
I am querying a SQL database to return open work order operations. My query is producing the Work Order number, operation status and due date. I am trying to figure out how to iterate through the array that is returned and: Gather the sum of operations due within a week Gather the sum of operations due in the second week
Get back the id of each insert in SQL Server
Let’s say we want to insert two users and I want to know the userId of each record I inserted. Example: Db: User.lookup database with these columns: UserId(PK, identity) | Username Setup, insert …