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 |
|
sadbjp
INNER JOIN
41 Posts |
 Posted - 2007-05-15 : 10:36:13
|
| Hi,I tried coding the following step:Set the values of GoalMet comparing the LocalPerf value and SppTarget.Target value with the CompareMethod. If CompareMethod = 1, then LocalPerf >= Target means GoalMet = 1; othwerwise, LocalPerf <= Target means GoalMet = 1.This is what I have, got error as Incorrect syntax near "=". Can anyone help me with this? ThanksF (CompareMethod = 1) AND (LocalPerf >= Target)BEGINSET GoalMet = 1ENDELSEIF (LocalPerf <= Target)SET GoalMet = 1 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
hi