FromOperator FromFrequency ToOperator TOFrquency
<= 2 >= 2
<= 4 >= 3
<= 2 >= 5
------------------
No i am concatinating all the columns
WHEN MetricType = 'O' THEN NU.FromOperator + '' + NU.FromFrequency + 'TO' + NU.ToOperator +ToFrequency
NU.FromOperator +''+ NU.FromFrequency IS NULL THEN ''
WHEN NU.ToOperator + NU.ToFrequency) IS NULL THEN NU.FromOperator +''+ NU.FromFrequency
output is coming Fine
here my problem is when i pass FromOperator and FromFrequency values like >=,2 and ToOperator , ToFrequency is null then it show values like >=2
again
when i pass ToOperator and ToFrequency values like >=,2 and FromOperator , FromFrequency is null then it show values like NULL value....can u suggest me
WHEN MetricType = 'O' THEN NU.FromOperator + '' + NU.FromFrequency + 'TO' + NU.ToOperator +ToFrequency
NU.FromOperator +''+ NU.FromFrequency IS NULL THEN ''
WHEN NU.ToOperator + NU.ToFrequency) IS NULL THEN NU.FromOperator +''+ NU.FromFrequency
Hi,
When NU.FromOperator +''+ NU.FromFrequency IS NULL , it will return empty, if you need to show the NU.ToOperator +''+ NU.ToFrequency when NU.FromOperator +''+ NU.FromFrequency IS NULL, please modify your query like this:
WHEN MetricType = 'O' THEN NU.FromOperator + '' + NU.FromFrequency + 'TO' + NU.ToOperator +ToFrequency
-- If all the operater is null
WHEN MetricType = 'N' THEN ''
WHEN (NU.FromOperator +''+ NU.FromFrequency) IS NULL THEN NU.ToOperator +''+ NU.ToFrequency
WHEN NU.ToOperator + NU.ToFrequency) IS NULL THEN NU.FromOperator +''+ NU.FromFrequency
END
Thanks.
Please mark the replies as answers if they help or unmark if not.
Feedback to us
mohan111
Member
46 Points
132 Posts
When Cojoining all the columns issue is coming
Nov 28, 2012 09:12 AM|LINK
Hello all,
i had a table Frequency have columns like :
FromOperator FromFrequency ToOperator TOFrquency
<= 2 >= 2
<= 4 >= 3
<= 2 >= 5
------------------
No i am concatinating all the columns
WHEN MetricType = 'O' THEN NU.FromOperator + '' + NU.FromFrequency + 'TO' + NU.ToOperator +ToFrequency
NU.FromOperator +''+ NU.FromFrequency IS NULL THEN ''
WHEN NU.ToOperator + NU.ToFrequency) IS NULL THEN NU.FromOperator +''+ NU.FromFrequency
output is coming Fine
here my problem is when i pass FromOperator and FromFrequency values like >=,2 and ToOperator , ToFrequency is null then it show values like >=2
again
when i pass ToOperator and ToFrequency values like >=,2 and FromOperator , FromFrequency is null then it show values like NULL value....can u suggest me
Chen Yu - MS...
All-Star
21829 Points
2513 Posts
Microsoft
Re: When Cojoining all the columns issue is coming
Nov 29, 2012 09:39 AM|LINK
Hi,
When NU.FromOperator +''+ NU.FromFrequency IS NULL , it will return empty, if you need to show the NU.ToOperator +''+ NU.ToFrequency when NU.FromOperator +''+ NU.FromFrequency IS NULL, please modify your query like this:
Thanks.
Feedback to us
Develop and promote your apps in Windows Store