mtkr Posted July 27, 2015 Report Posted July 27, 2015 Why so curious man..Meeku preferred vendor ship unda man? :police: :5_2_108:
loveindia Posted July 27, 2015 Report Posted July 27, 2015 SELECT [Loan Number] , [Date Recived] FROM Table_Name Group BY [Loan Number] , [Date Recived] ; aggregation em lekunda Group by raastey em vastadi man booodidhaaa.....
mtkr Posted July 27, 2015 Report Posted July 27, 2015 are you working for BCBS TX man???? which location man?? Richardson??? through whom??? S richrdsn... thru compupros
ronitreddy Posted July 27, 2015 Report Posted July 27, 2015 adi andaru chesedi kaadu man.... dhaivechaa man.... no preachings man..job needed man..desperate man..missing tx man
4Vikram Posted July 27, 2015 Author Report Posted July 27, 2015 DISTINCT is a very costly operator. It will do a SORT and TOP on you query in the execution plan behind the scenes. so if you have a distinct in your query, sometimes the result set is delayed because it needs to sort the data (overhead to the application)... ee Loveindia gaadu edo taagesi vaagutunnadu anukuntunnav kada man, kaavalantey select ur query and press CTRL + L (if you have permissions to see execution plan man).... you will see that.... bhaiyya naaku antha antha matrana vastadi sql.. infact chepali ante antha antha kuda radu edo manage chestuna, vadu chepindi ikada post chesna anthe... inka ninnu comment chese antha pedoni aa bhaiyya nenu, nuvu thapu chepina kuda correct anukune type nenu nduku ante naaku asalu em radu kabati... but nuvu thapu chepav anuko that is vere visheyam.. anyways thanks for that bhaiyaa.. DISTINCT use cheyadam tappu ani cheppina mee friend enduku adi tappoooo cheppaledaa man.... no idea why he told that
ronitreddy Posted July 27, 2015 Report Posted July 27, 2015 ikkada no oracle.. FL bcbs lo ora oh okayyy
loveindia Posted July 27, 2015 Report Posted July 27, 2015 S richrdsn... thru compupros lol... Nuvvu use chesey prati database lo nenu definitely oka stored procedure raasuntaa man aitey, unless you are a dba and don't develop anything.... :)
4Vikram Posted July 27, 2015 Author Report Posted July 27, 2015 aggregation em lekunda Group by raastey em vastadi man booodidhaaa..... but did that only kaani Max(DateRecieved) use chesna,, nenu anukuna solution aite ochindi just waiting for confirmation from my colleague
4Vikram Posted July 27, 2015 Author Report Posted July 27, 2015 lol... Nuvvu use chesey prati database lo nenu definitely oka stored procedure raasuntaa man aitey, unless you are a dba and don't develop anything.... :) company database motham ne chetilone unatundi kada vuncle man :)
loveindia Posted July 27, 2015 Report Posted July 27, 2015 bhaiyya naaku antha antha matrana vastadi sql.. infact chepali ante antha antha kuda radu edo manage chestuna, vadu chepindi ikada post chesna anthe... inka ninnu comment chese antha pedoni aa bhaiyya nenu, nuvu thapu chepina kuda correct anukune type nenu nduku ante naaku asalu em radu kabati... but nuvu thapu chepav anuko that is vere visheyam.. anyways thanks for that bhaiyaa.. no idea why he told that poddunney mandu kotti office ki vellavaa man... naakem ardam kaaledu.... I also started career with 0 man... you will learn in future ani comedy touch ichi ala cheppanu man.... tappu ani vuntey manninchu man...
ronitreddy Posted July 27, 2015 Report Posted July 27, 2015 lol... Nuvvu use chesey prati database lo nenu definitely oka stored procedure raasuntaa man aitey, unless you are a dba and don't develop anything.... :) anthena man..naku matram alanti long term contracts ippinchavu kada man
loveindia Posted July 27, 2015 Report Posted July 27, 2015 but did that only kaani Max(DateRecieved) use chesna,, nenu anukuna solution aite ochindi just waiting for confirmation from my colleague MAX anteney aggregation kada man... his query lo MAX ledu if you see....
ronitreddy Posted July 27, 2015 Report Posted July 27, 2015 poddunney mandu kotti office ki vellavaa man... naakem ardam kaaledu.... I also started career with 0 man... you will learn in future ani comedy touch ichi ala cheppanu man.... tappu ani vuntey manninchu man... mari eppudu kshaminchali man?
loveindia Posted July 27, 2015 Report Posted July 27, 2015 anthena man..naku matram alanti long term contracts ippinchavu kada man BCBS was long term long ago man, now its 18 months only.... 5.5 years my tenure, I resigned due to some emergency... now going back to chicago campus soon and will talk to Mtkr via sametime man and then meet in person in dfw man...
Recommended Posts