Comments by Member 13518187

Member 13518187 17-Jul-18 3:02am View

Not getting that's why I came here to ask

Member 13518187 11-Jul-18 8:36am View

But Publishing reports for all the users with secure way is costly with microsoft side

Member 13518187 14-May-18 13:44pm View

This is giving an Error as my Order_date Column Is in varchar format and date is getting stored like this in my order_date column '14/05/2018 10:26:15'

Member 13518187 30-Jan-18 10:03am View

@Luca Astolfi where should i write this CLR...only have sql server database

Member 13518187 27-Jan-18 6:17am View

Question is clear enough

Member 13518187 9-Jan-18 7:59am View

GIVING DIFFERENT RESULTS

SubCategoryName SubCategoryName site sasitename symn dqty
NULL 560-Tea 10201362 AL SARIB CAFE. November 1
NULL 560-Tea 10201653 Sherman restaurent December 0.0278
NULL 140-Dairy 10610489 GALAH FS October 0.25
NULL 140-Dairy 10610497 FLWER CITY December 1
NULL 140-Dairy 10610513 TAHA FS July 0.5
NULL 140-Dairy 10610516 EJAZA GRO January 0.25
NULL 140-Dairy 10610565 AL DOHA GRO November 1
NULL 140-Dairy 10610592 AL TAHIRE F/S August 2
NULL 140-Dairy 10610592 AL TAHIRE F/S September 2
140-Dairy 140-Dairy 10610602 MARWAN CAFTERIA February 20
NULL 140-Dairy 10610602 MARWAN CAFTERIA June 4
NULL 140-Dairy 10610602 MARWAN CAFTERIA May 8
NULL 140-Dairy 10610638 SARAYA FOODSTUFF January 0.25
NULL 140-Dairy 10610681 SHAIMA CAFÉ January 2
NULL 140-Dairy 10610714 JARIAH FOODSTUFF September 1

Member 13518187 9-Jan-18 4:26am View

SELECT
CASE WHEN op.dqty > '20' AND ti.SubCategoryName ='CHAIR' THEN ti.SubCategoryName
WHEN op.dqty > '9' AND ti.SubCategoryName ='BASKET' THEN ti.SubCategoryName ELSE NULL END AS SubCategoryName ,

TI.SubCategoryName,op.site,op.sasitename,op.symn,op.dqty,count(distinct(orna)) as orna
from ABCD op
inner join item ti

WHERE TI.SubCategoryName in ('CHAIR' ,'BASKET')
GROUP BY TI.SubCategoryName,op.site,op.sasitename,op.symn,op.dqty;

Member 13518187 9-Jan-18 3:19am View

but output is not coming correct as per my question

Member 13518187 9-Jan-18 3:19am View

@debasish mishra ......it is already integer and i have written > 20 only ..by mistake i wrote here

Member 13518187 30-Dec-17 0:26am View

SQL SERVER ,,on The same machine where i have installed ANdroid Studio

Member 13518187 13-Nov-17 9:56am View

Is this bat file script is correct,if it would happen correct i would have find the data through my bat spoon file,,this .bat script is not running correctly i think so

Comments by Member 13518187 (Top 11 by date)