March 30, 2006 at 7:32 am
Hey gang,
Have been noodling this for a couple days. Not matter what variation I use of this && expression it will not parse. MSDN examples show compound expressions using && but I'm missing something, it won't take as my second split contidion, either clause alone is OK but as soon as I add && and a second one it chokes.
(Collage_LatestVersion > BKS_LatestVersion) && (BKS_isDeleted = 0 ) is n/g
Collage_LatestVersion > BKS_LatestVersion && BKS_isDeleted = 0 is n/g
(Collage_LatestVersion > BKS_LatestVersion && BKS_isDeleted = 0 ) is n/g
Can you do this? I'm stuck.
Side note, the BI and SQL manager studios are the SLOWEST tools I've used in years. As much as I'm loving the new server platform, that's been such a surprise and constant source of frustration as I count to 50 waiting for tabs to change and load all the SIIS objects which only show as blank white boxes with a name in them, even the arrows in the column mappings views have gone away. Restarting everything does not help. Hope there's a service pack soon.
thanks all!
Skål - jh
March 31, 2006 at 4:46 am
In expressions "=" is an assignment operator. "==" is used for testing equivalence.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 31, 2006 at 6:40 am
Ah-HA! Thank you.
What language am I thinking in again.... ? Now more than ever.
much appreciated!
Skål - jh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply