nenu_devudni Posted May 9, 2016 Report Share Posted May 9, 2016 ASVC SM GS NO_MESH EL NO_MESH WT NO_MESH Edi na cursor nundi oche records, rendu values n compare chesi oka value assign cheyali ..,.. ela cheste better oo sepandi kasta Quote Link to comment Share on other sites More sharing options...
ronitreddy Posted May 9, 2016 Report Share Posted May 9, 2016 Help Quote Link to comment Share on other sites More sharing options...
mastercheif Posted May 9, 2016 Report Share Posted May 9, 2016 question lo clarity ledu Quote Link to comment Share on other sites More sharing options...
nenu_devudni Posted May 9, 2016 Author Report Share Posted May 9, 2016 Just now, mastercheif said: question lo clarity ledu oka function undi uncle .. aa function lo oka param value pass chestuna na select ki ... aa slect run chesina prati sari ..same ade structure lo 3 records ostay .. asvc, sm columns .. ipudu endi ante .. aa result set nundi ..prati sari .. i need to check .. if EL = MESH or NO_MESH, if GS = MESH or NO_MESH or WT = MESH or NO_MESH .. Quote Link to comment Share on other sites More sharing options...
nenu_devudni Posted May 9, 2016 Author Report Share Posted May 9, 2016 So i need to store these result sets in such a way that i can compare them and do my stuff ani .. Quote Link to comment Share on other sites More sharing options...
mtkr Posted May 9, 2016 Report Share Posted May 9, 2016 ea values comparing?? Quote Link to comment Share on other sites More sharing options...
mastercheif Posted May 9, 2016 Report Share Posted May 9, 2016 case statements 1 minute ago, nenu_devudni said: oka function undi uncle .. aa function lo oka param value pass chestuna na select ki ... aa slect run chesina prati sari ..same ade structure lo 3 records ostay .. asvc, sm columns .. ipudu endi ante .. aa result set nundi ..prati sari .. i need to check .. if EL = MESH or NO_MESH, if GS = MESH or NO_MESH or WT = MESH or NO_MESH .. case statements rayacchu kada bujji Quote Link to comment Share on other sites More sharing options...
nenu_devudni Posted May 9, 2016 Author Report Share Posted May 9, 2016 1 minute ago, mtkr said: ea values comparing?? result set lo ochina column values ni compare cheyali .. so m hoping to use a 2d array or something .. but ela cheyalo ardam katledu .. for comparison .. select ni cursor lo petukuna .. but result set comparision ela how ani ?? Quote Link to comment Share on other sites More sharing options...
nenu_devudni Posted May 9, 2016 Author Report Share Posted May 9, 2016 7 minutes ago, mastercheif said: case statements case statements rayacchu kada bujji single row check aithe okay vuncle ... but I have a condition to check when all 3 exists like .. IF asvc = EL and GS and WT then I NEED TO DO SOME STUFF TOO ... Quote Link to comment Share on other sites More sharing options...
mastercheif Posted May 9, 2016 Report Share Posted May 9, 2016 4 minutes ago, nenu_devudni said: single row check aithe okay vuncle ... but I have a condition to check when all 3 exists like .. IF asvc = EL and GS and WT then I NEED TO DO SOME STUFF TOO ... procedures sangathi i don't know man... but simple SQLs lo aythey I would use staging tables or volatile tables Quote Link to comment Share on other sites More sharing options...
Peach Posted May 9, 2016 Report Share Posted May 9, 2016 use boolian comparisons as ': ?' or '&&' in logic with for loop or while loop and then inner loop for result. otherwise use switch & case statements as other member said. Quote Link to comment Share on other sites More sharing options...
mastercheif Posted May 9, 2016 Report Share Posted May 9, 2016 @TS question chala clear ga post cheyyi so that people can give clear solution. thu thu matram laga post chesthey people can give only suggestions that may or may not apply. Quote Link to comment Share on other sites More sharing options...
nenu_devudni Posted May 9, 2016 Author Report Share Posted May 9, 2016 2 minutes ago, Peach said: use boolian comparisons as ': ?' or '&&' in logic with for loop or while loop and then inner loop for result. otherwise use switch & case statements as other member said. case use cheyalenu vuncle .. becasue i need to check for all the 3 asvc like EL,GS and WT at once .. So i am thinking to use a 2d array for comaparison or a record type .. but avi ela use cheyalo ardam katledu .. Quote Link to comment Share on other sites More sharing options...
CheGuevara Posted May 9, 2016 Report Share Posted May 9, 2016 Use loop Quote Link to comment Share on other sites More sharing options...
Imperial Posted May 9, 2016 Report Share Posted May 9, 2016 20 minutes ago, nenu_devudni said: single row check aithe okay vuncle ... but I have a condition to check when all 3 exists like .. IF asvc = EL and GS and WT then I NEED TO DO SOME STUFF TOO ... denormalize the table...make rows inro columns...assign flags.../ use coalesce, to eliminate nulls, that come with case statement.... basically you need to explode the table to write case statement Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.