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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2010-04-09 : 12:02:40
|
| I need to ensure the following conditions are True prior to executing the 2nd sequence containerI have 2 variables @InputCount & @ActiveCount both intThe condition is only if @InputCount !=0 AND @ActiveCount!=0 AND @InputCount == @ActiveCountthen execute the next sequence containerI have no problem if I just have "@InputCount !=0" as part of my expression BUT I need to include it as above.Im getting the following error mssgError at Constraint: Attempt to parse the expression "(@[User::InputCount]!=0) AND (@[User::ActiveCount]!=0 ) AND @[User::InputCount] == @[User::ActiveCount] " failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis. |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-09 : 13:06:58
|
| Solved it, replaced AND with && |
 |
|
|
|
|
|
Precedence Constraint Expression Error