I have few issues, they are
(1) all the columns are displayed in the first column of the excel sheet..which I don't need, I need to show the report in diff columns.. how to do that..
(2) if I use inner join with the main, how can I get the column names of the other table
Can u please help me out to solve the above issues?
Microsoft SQL Server · TSQL · · ·
1 You can explicitely name the column names (cells in excel) in the query
2 you can use a table alias and use that as a qualifier to get the column names