Search results for query: *

how do i change it to vbscript?

getting an "expected end of statement error. line 4. char 12" not sure what to do. this vbscript is supposed to loop through word files in a path and save them as PDF. please help thanks in advance 'Option Explicit Dim DRCTRY As String DRCTRY = "U:\Test" Dim fso, newFile, folder...

Would it be max(grade status) instead of count(grade status)?

What if the grades are letters instead of numbers?

hi. i have the following: SELECT distinct top 30 studentid,[101], [102], [103],[104] FROM tbl_TEST s PIVOT (count(grade_status) FOR semester IN ([101], [102], [103],[104]))p How can I actually list the grade_status value instead of the count? Or how can i group by grade_status? Thanks

is anyone able to help with this question? thanks

buckets will be 50-59, 60-79, 80-99 and 100+. For example purposes, lets say that there will be a list of students. and each student will have one record per month. for JAN, the bucket may be 60-79 and for 2 months later in MAR it might be 100+. I hope this helps. I just want to be able to...

i hope this makes sense, but i want to write a query which tracks the movement of student status for a 4 month period. the status would be 4 possibilities/buckets. passing, very good, needs improvement and failing, with a range of scores to be used to determine each. i want to get the count of...

hi. i have something like Declare @today2 date Set @today2 = MSPRunDate Declare @datadate2 date Set @datadate2 = (Select max(DateId) From tablename (nolock) Where BusinessDay = 'Y' and DateId = @today2) Declare @EOM2 date set @EOM2 = (SELECT...