Part of SQL query is deleted when saving a View

Asked Jan 23 '17 at 13:58

Active Jan 23 '17 at 13:58

Viewed 55 times

I have an SQL View I am adding these two lines :

AND (NOT((Segment = 7) AND (Type= 'Reserved')))
AND (NOT((Segment>= 6) AND (Type= 'NotReserved')))

The query works, but when I save the View, NOT((Segment = 7) and NOT((Segment>= 6) parts are deleted. When I change order of AND clauses, I mean change query to this :

AND (NOT((Type= 'Reserved') AND (Segment = 7)))
AND (NOT((Type= 'NotReserved') AND (Segment>= 6)))

then (Type= 'Reserved') and (Type= 'NotReserved') are deleted. Why is that? What am I doing wrong? Thanks.

asked Jan 23 '17 at 13:58

jason

6,962
36
117
198

You probably have a semicolon at the end of the existing view definition. – Gordon Linoff Jan 23 '17 at 13:59
@GordonLinoff there is no semicolon in the query. – jason Jan 23 '17 at 14:00
Can you maybe provide a minimal example of the entire view that reproduces the problem? – Onkel Toob Jan 23 '17 at 14:03
1

What do you mean by "save the View"? from where? – David דודו Markovitz Jan 23 '17 at 14:07
Which tool are you using to edit and "save" the view? – Jan 23 '17 at 14:08
I'm using SQL Management Studio – jason Jan 23 '17 at 14:11
1

Are you "saving" this as a file? You have to run the alter statement for the changes to take effect. – Sean Lange Jan 23 '17 at 14:13
1

Are they getting deleted? [Or are they getting re-written?](http://stackoverflow.com/q/22568604/2697001) – Shaneis Jan 23 '17 at 14:15
@DuduMarkovitz from Design. – jason Jan 23 '17 at 14:24

Part of SQL query is deleted when saving a View

0 Answers0