Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
folky15
Starting Member
1 Post |
 Posted - 2014-07-10 : 11:22:49
|
| Hello,I’m receiving the following message when attempting to run the SQL statement below. I am very new to SQL so perhaps I am missing something obvious? Thank you in advance for your assistance!Error report:SQL Command: force view "UIP_SOC"."SEG_VIEW_EWO_2"Failed: Warning: execution completed with warning----------------------- CREATE OR REPLACE FORCE VIEW "UIP_SOC"."SEG_VIEW_EWO_2" ("CODE", "NAME", "EWO4", "EWO6") AS SELECT DISTINCT code, nameFROM( SELECT seg_value AS code, seg_desc AS name, SUBSTR(seg_value,5,4) AS EWO4, SUBSTR(seg_value,5,6) AS EWO6 FROM UIP_SEGMENT_VALUES WHERE seg_name = 'EWO' AND seg_value IN (SELECT ewo FROM stage_budget_v) UNION SELECT CODE,NAME FROM SEG_VIEW_PARENTS WHERE SEG_NAME = 'EWO' AND NOT (CODE IS NULL) );----------------Referenced View Columns:"SEG_VIEW_PARENTS" ("SEG_NAME", "CODE", "NAME")Referenced Table Columns:"UIP_SEGMENT_VALUES" "SEG_NAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, "SEG_VALUE" VARCHAR2(20 BYTE) NOT NULL ENABLE, "SEG_DESC" VARCHAR2(200 BYTE), "SEG_TYPE" VARCHAR2(20 BYTE), "SEG_COMPANY" VARCHAR2(20 BYTE) |
|
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2014-07-10 : 11:40:13
|
| Looks like Oracle code. This is MSSQL server forum, so you will most likely get better help on a Oracle forum. |
 |
|
|
|
|
|
|
|
Error when creating View with Union (beginner)