thanks for these - I wonder if there's a cursorless way to do this - certainly I can see how Cross Apply could be used for EXECs over a dataset.
Search found 2 matches
Search found 2 matches • Page 1 of 1
- Tue May 16, 2017 9:00 am
- Forum: SSRS/SQL Code Snippits
- Topic: Calculating QCA Points and Generating ALPS Target Grades Using SQL
- Replies: 4
- Views: 1162
- Wed Apr 26, 2017 1:21 pm
- Forum: Bugs and Issues
- Topic: Business Rule or Default?
- Replies: 1
- Views: 1003
Hi, I'm trying to work out whether it's possible to default the Session and the academic year when creating a StudentPeriodicILR record... I've looked at business rules, Defaults etc, but these seem to relate to 'copying' information from one place to another. Has anyone done this with the SPI class...