Viewing 4 posts - 1 through 4 (of 4 total)
The CASE statement will work and I will look at creating a store procedure for this as well as cleaning up the code with alias.
Thanks I really appreciate the help.
June 1, 2008 at 7:43 pm
#822756
Jeff Moden (6/1/2008) Um... is [DC-Base] the changing part number you're referring to? And, if so, what is the datatype of that column?
Jeff Moden (6/1/2008)
With the following, I'm trying to build the...
June 1, 2008 at 5:02 pm
#822744
I'll give that a try.
Thank you
December 5, 2007 at 6:16 am
#757311
Thanks, it works now. I created a select statement in a script task and assigned it to a user variable and then used the variable in the expression.
Appreciate it.
November 15, 2007 at 6:26 am
#751476