Pl/sql Help Needed...! Experts Please Help..urgent

[iTeachSAP]

[quote name='GatisKandis' timestamp='1363967133' post='1303469258']
problem solved apudo....bhayya epudu lunch ki poyintadu....but GP nadi same logic but with fewer steps
[/quote]

nuvvu keka annaya one who can write code with lesser lines is a master LOC takkuva unte.. errors takkuva untayi kada ?

[iTeachSAP]

gatiskandis mithram .. ni code ikkada paste cheyi .. discuss chedham

[netflix]

Thanks baa....for your help....!
ma manager ki code ichesa..inka ayana ishtam.

[ChampakDas]

nee modesty thagaletta...nuvu racha ahey....logic wise its same mama you bet and neede bagundhi 1 or 2 lines thakuva undintayi ante...and you used for loop I used while, though they do 1 and the same while is slight less costlier than for...this might save few micron seconds no bug deal though...and insert chesetapudu dbo ani petadam which is faster than jsut putting table name
[quote name='iTeachSAP' timestamp='1363967929' post='1303469357']

nuvvu keka annaya one who can write code with lesser lines is a master LOC takkuva unte.. errors takkuva untayi kada ?
[/quote]

[ChampakDas]

at least you dint use casting so you win in that setting statement...
DECLARE @xvalue INT, @yvalue INT,@finalvalue VARCHAR(MAX)
set @yvalue =100
set @xvalue =1
WHILE 1=1
BEGIN
WHILE @xvalue<>1000000
BEGIN
SET @finalvalue = cAST(2 AS VARCHAR) + '+' +Cast(@yvalue as varchar(10)) +'+' +Cast(@xvalue as varchar(10));
SET @xvalue = @xvalue +1
SELECT @finalvalue AS finalvalue

Insert into dbo.<tablename> (row_id) values (@finalvalue)
END
SET @yvalue = @yvalue +1
END
[quote name='iTeachSAP' timestamp='1363967985' post='1303469365']
gatiskandis mithram .. ni code ikkada paste cheyi .. discuss chedham
[/quote]

[karna11]

requirement seppandi vayyaaa

[iTeachSAP]

[quote name='GatisKandis' timestamp='1363976130' post='1303470288']
nee modesty thagaletta...nuvu racha ahey....logic wise its same mama you bet and neede bagundhi 1 or 2 lines thakuva undintayi ante...and you used for loop I used while, though they do 1 and the same while is slight less costlier than for...this might save few micron seconds no bug deal though...and insert chesetapudu dbo ani petadam which is faster than jsut putting table name
[/quote]


hahahha.. mama ni code kuda kathi .. nenu oracle looo raasa ... .I was under assumption that he is looking for a oracle proc....

but nuvvu sql server code raasavemo .... DBO. sql server lo untundhi ..

[ChampakDas]

- Edit

[iTeachSAP]

[quote name='karna11' timestamp='1363976369' post='1303470343']
requirement seppandi vayyaaa
[/quote]


thread starter permission isthe ikkada paste chestha bayya.. !!

[ChampakDas]

sql server, oracle same same fuel fuel it will work
[quote name='iTeachSAP' timestamp='1363976418' post='1303470358']


hahahha.. mama ni code kuda kathi .. nenu oracle looo raasa ... .I was under assumption that he is looking for a oracle proc....

but nuvvu sql server code raasavemo .... DBO. sql server lo untundhi ..
[/quote]

[iTeachSAP]

[quote name='GatisKandis' timestamp='1363976536' post='1303470383']
sql server, oracle same same fuel fuel it will work
[/quote]


ROFL ... thread starter velli adhe cheppali manager ki .... code ..code... it will work ani ...

[ChampakDas]

sir I dont knwo sir I ran it in prod if you dont like return it back
[quote name='iTeachSAP' timestamp='1363976875' post='1303470473']


ROFL ... thread starter velli adhe cheppali manager ki .... code ..code... it will work ani ...
[/quote]

[iTeachSAP]

[quote name='GatisKandis' timestamp='1363977294' post='1303470569']
sir I dont knwo sir I ran it in prod if you dont like return it back
[/quote]


what sort of project manager you are ? you should tell first know ....

[netflix]

[quote name='iTeachSAP' timestamp='1363977509' post='1303470616']


what sort of project manager you are ? you should tell first know ....
[/quote]


inka prod daka vellaledhu baa...!

[ChampakDas]

vammmoooooooooo
sent it back sir we will refill it

[quote name='iTeachSAP' timestamp='1363977509' post='1303470616']
what sort of project manager you are ? you should tell first know ....
[/quote]