G
Guest
I am using this 'tool' to review my sql query, in my select statement I am
using this
CR.ID, CR.CAT, CR.SEV, substr(cr.pr,1,5), CR.AP, USERS.FULLNAME
when get my my result in the MS SQL tool the result shows
"substr(cr.pr,1,5)" as a column header, when I move the query to excel the
column header is "4" which makes sense as it representing the 4th query.
My problem is I want to rename the column header in my result something that
I cannot seem to do even using the MS SQL query tool which says I should use
this
substr(cr.pr,1,5) AS 'PR Number',"
Can someone help me with a workaround, I can't seem to use that syntax at
all to change the column header in excel when my results are brought back.
using this
CR.ID, CR.CAT, CR.SEV, substr(cr.pr,1,5), CR.AP, USERS.FULLNAME
when get my my result in the MS SQL tool the result shows
"substr(cr.pr,1,5)" as a column header, when I move the query to excel the
column header is "4" which makes sense as it representing the 4th query.
My problem is I want to rename the column header in my result something that
I cannot seem to do even using the MS SQL query tool which says I should use
this
substr(cr.pr,1,5) AS 'PR Number',"
Can someone help me with a workaround, I can't seem to use that syntax at
all to change the column header in excel when my results are brought back.