Attached is an Excel spreadsheet whose data I access within a separate app and through an ODBC connection to the spreadsheet.
I need to build T-SQL syntax (i.e. select * from) to accommodate the fact that the Employee and Employee ID columns have blanks. For instance, for Frank Balsamo, you can tell that he has seven courses. But, how do I get the ODBC connection to "understand" that?
In other words, I guess I need to use PARTITION BY or something like that within the T-SQL syntax in order to "fill in" the Employee and Employee ID fields. That way, the ODBC connection will know not to leave blanks in those columns.
I hope that makes sense.
Anyway, can you all please help me with the T-SQL syntax on this?
Please, also, let me know if you have any questions.
Thanks! Much appreciated!