Viewing 15 posts - 241 through 255 (of 642 total)
and I always thought you were in Australia. Thanks Jeff, I'm kinda (small kinda) glad it stumped you. I'm using the wrong tool for the task, it sounds...
February 18, 2014 at 12:18 am
Jeff, it's not quite there yet. Definitely, the problem is that I need average # of lineItems per distinct Invoice.
So, for Jan 2014, where there are12 lineitems spread over 2...
February 18, 2014 at 12:00 am
Do you mind telling me if I could have added something to my existing query to get avg too?
February 17, 2014 at 8:29 am
Inoland,that's no problem. I suspected that and it wasn't a problem. It's the sanctimonious and beer belly ones that irk me.
June 6, 2013 at 10:16 pm
I just figured it out all by myself:
FINDSTRING(TRIM([Description 01]),"COST POOL",1) == 1 && SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM"? SUBSTRING(TRIM([Business Unit]), 4, 50): " "
That solution was to concatenate. Duh.
Folks...
June 5, 2013 at 9:54 am
The field remains red. The field goes black if it is parsing. Well folks, it appears that, none of the regulars on this forum know how to write SSIS derived...
June 5, 2013 at 7:01 am
Can anyone take a stab at correcting this expression so that it parses? Please?
FINDSTRING([Description 01],"COST POOL", 1)==1? SUBSTRING(TRIM([Business Unit]), 1,3)=="MFM"?SUBSTRING(TRIM([Business Unit]), 4,50)): NULL
There is no good website...
June 4, 2013 at 10:06 pm
This morning FINDSTRING([Description 01],"COST POOL", 1)==1? "Yes": "No" parsed. So back to the original problem.
I need one level of nesting to handle second condition. Following SQLChik's tutorial...
Field == "TrueCondition1" ?...
June 4, 2013 at 7:22 am
Vikash, could you kindly help me with this string here http://www.sqlservercentral.com/Forums/Topic1458631-364-2.aspx#bm1459386
I can't help myself and no one else can either, so far. I think you will know answer.
June 3, 2013 at 10:06 pm
let me step back to one expression and go from there.
FINDSTRING([Description 01],"COST POOL", 1)==1? "Yes": "No"
This is the equivalent of
expression1?(expression2?true2:false2):false1
what is wrong with that????
June 3, 2013 at 9:53 am
According to that site this should work (proper operands and use of parentheses):
FINDSTRING(TRIM([Description 01]), "COST POOL", 1))==1?(SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" )?(SUBSTRING(TRIM([Business Unit]), 4, 50):[Business Unit])))
SSIS rejects. Can...
June 3, 2013 at 9:06 am
good, I took a glance and looks promising.
"This syntax originated in C and C#...." no wonder! It is not unlikely that I will read, try, and fail. But,...
June 3, 2013 at 7:10 am
so this is working
To be sure, you could try something like:
SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" ? SUBSTRING(TRIM([Business Unit]), 4, 50): [Business Unit]
I would like to evaluate one more...
June 2, 2013 at 10:44 am
Hmmm, certainly looks promising, but I don't see COALESCE() available in SSIS transforms. Do you?
June 1, 2013 at 11:38 pm
Viewing 15 posts - 241 through 255 (of 642 total)