关于试图创建了但调用老是有红线的问题

[充满荆棘的路]

------------------------------------------------------------------              
--目的：为了报表制作需要，去除房间的分区，产品类型，户型等              
--author:hejun                 
--createdon:2010-7-4         
------------------------------------------------------------------              
CREATE VIEW [dbo].[es_roominfo]              
AS              
SELECT               
p_project.buguid,              
p_project.projguid,              
p_project.projname,              
p_building.bldguid,              
p_room.roomguid,              
p_room.Room,              
p_Room.BldArea,              
p_Room.Price,              
p_room.Total,              
p_room.HuXing,              
p_building.BldFullName,              
p_building.BldName,              
( CASE WHEN REPLACE(p_building.bldfullname, p_project.projname + '-', '') = p_building.bldname              
               THEN '无分区'              
               ELSE REPLACE(REPLACE(p_building.bldfullname, p_project.projname + '-', ''),              
                            '-' + p_building.bldname, '')              
          END ) AS yname,              
p_BuildProductType.BProductTypeName,              
p_BuildProductType.BProductTypeShortName,              
p_BuildProductType.FirstLevelName,              
p_room.FloorNo,              
p_room.[Floor],              
p_room.unit,              
p_room.UnitNo,              
p_room.Status,              
p_room.SLControlDate ,             
(CASE WHEN dbo.p_Room.MainRoomGUID IS NOT NULL THEN '是' ELSE '否' END) AS isattachroom ,        
BldFullName+(CASE WHEN Unit<>'' THEN '-'+Unit+'-'+Room ELSE +'-'+Room END ) as RoomInfo  ,      
p_Room.RoomStru, p_room.No     
FROM p_room              
LEFT JOIN p_BuildProductType ON p_BuildProductType.BProductTypeCode = p_room.BProductTypeCode              
INNER JOIN p_building ON p_building.bldguid = p_room.bldguid              
INNER JOIN p_project ON p_Project.ProjGUID = p_Room.ProjGUID 

创建语法，但调用的时候老是报红线，但能执行，但我把语句放到报表里面就不行了，求大神来解决一下

[Mr_Nice]

SELECT  p_project.buguid ,
        p_project.projguid ,
        p_project.projname ,
        p_building.bldguid ,
        p_room.roomguid ,
        p_room.Room ,
        p_Room.BldArea ,
        p_Room.Price ,
        p_room.Total ,
        p_room.HuXing ,
        p_building.BldFullName ,
        p_building.BldName ,
        ( CASE WHEN REPLACE(p_building.bldfullname, p_project.projname + '-',
                            '') = p_building.bldname THEN '无分区'
               ELSE REPLACE(REPLACE(p_building.bldfullname,
                                    p_project.projname + '-', ''),
                            '-' + p_building.bldname, '')
          END ) AS yname ,
        p_BuildProductType.BProductTypeName ,
        p_BuildProductType.BProductTypeShortName ,
        p_BuildProductType.FirstLevelName ,
        p_room.FloorNo ,
        p_room.[Floor] ,
        p_room.unit ,
        p_room.UnitNo ,
        p_room.Status ,
        p_room.SLControlDate ,
        ( CASE WHEN dbo.p_Room.MainRoomGUID IS NOT NULL THEN '是'
               ELSE '否'
          END ) AS isattachroom ,
        BldFullName + ( CASE WHEN Unit <> '' THEN '-' + Unit + '-' + Room
                             ELSE '-' + Room   -- 这个地方的第一个 + 去掉看看
                        END ) AS RoomInfo ,
        p_Room.RoomStru ,
        p_room.No
FROM    p_room
        LEFT JOIN p_BuildProductType ON p_BuildProductType.BProductTypeCode = p_room.BProductTypeCode
        INNER JOIN p_building ON p_building.bldguid = p_room.bldguid
        INNER JOIN p_project ON p_Project.ProjGUID = p_Room.ProjGUID

[以学习为目的]

把你调用的语句贴出来看看，哪个地方报红线

[發糞塗牆]

点一下这个，你那个应该是缓存问题而已