Viewing 13 posts - 31 through 43 (of 43 total)
no afraid not the null columns are still returned
December 18, 2006 at 7:31 am
this is the sql im workin with at the moment but if i include the or statement the results will include tests that are not on the specified date
Select IsNull(p.firstName+...
December 18, 2006 at 6:56 am
unfortunately that wont work because if any of the columns for a single row are null then the entire row is excluded from the results but the other columns in that...
December 18, 2006 at 5:45 am
thanks alot thats better than what i have but i need the final result to be the matchid of one match and the max average of that match
this query returns...
June 14, 2006 at 10:25 am
sorry about this but i cant seem to find the problem with this statement
...............Incorrect syntax near the keyword 'Where'.
May 2, 2006 at 4:33 am
yes indeed thats exactly what i needed thanks alot man i appreciate it
January 10, 2006 at 5:17 am
Excellent work my good man ha ha… thanks very much tho I really appreciate it
January 3, 2006 at 9:37 am
the second option def sems to be the more appropriate one for my problem but when i try to cast it as a date i get this error it seems...
January 3, 2006 at 6:17 am
Viewing 13 posts - 31 through 43 (of 43 total)