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
Loading
Tusharika TPosted May 6, 2015, 9:11 AM
eliminate space between 'V ID', t1.V ID like 'VID', t1.VID and then execute
or
use t1.[V ID] instead of t1.V ID like below query
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'
Manoj BhoirPosted May 6, 2015, 8:04 AM
select * from
(select ROW_NUMBER() over (order by MyTable.VName) as ROW,
MyTable.RCMS_ID as
'VID', MyTable.VName as 'VName', (SELECT TableUser.FName +' '+
TableUser.LName FROM TableUser where TableUser.Flag = 1 and
TableUser.EmpCode=convert(numeric(25,0), MyTable.CreatedBy)) as 'CreatedBy' ,
CONVERT(VARCHAR(10),MyTable.CreatedOn ,103) AS 'CreatedOn'
from MyTable where
MyTable.Flag=1) t1 where t1.VID = '101'
Pranay RanaPosted May 6, 2015, 7:45 AM
[column name]
Nanhe SiddiquePosted May 6, 2015, 7:21 AM
as per my knowledge
you are using v ID that incorrect alias name in respect to where clause .
please read this links it may help you
http://stackoverflow.com/questions/7662/database-table-and-column-naming-conventions