SQL Query - Row_Number - Invalid Column Name
Hi..
select * from
(select ROW_NUMBER() over (order by MyTable.VName) as ROW,
MyTable.RCMS_ID as
'V ID', MyTable.VName as 'V Name', (SELECT TableUser.FName +' '+
TableUser.LName FROM TableUser where TableUser.Flag = 1 and
TableUser.EmpCode=convert(numeric(25,0), MyTable.CreatedBy)) as 'Created By' ,
CONVERT(VARCHAR(10),MyTable.CreatedOn ,103) AS 'Created On'
from MyTable where
MyTable.Flag=1) t1 where t1.V ID = '101'
--------
I am getting error as - Invalid Column Name.
How to get column name in where clause with space