Ss'rs , Sq! Srvr Vachina Vallu He!p

[pikki]

[img]http://oi50.tinypic.com/29ux09l.jpg[/img]

prob enti ante naku ss'rs lo query lo grouping chesinappu paina mention chesina output ravali , anta chesanu kani

kani req enti ante naku aa numbers ela ravali ante..first number ochi active number and megitavi kaadu..so display lo first number ravali and then migitavi asc order lo ravali , first number edanna kavochu group lo malli for ex nenu main recrd change cheste ila ravali output

[img]http://oi50.tinypic.com/nwyji0.jpg[/img]

[pikki]

[img]http://lh6.ggpht.com/-ocaK3uCxuCM/UN-wslzshzI/AAAAAAAAIbw/P2s7nway6Ok/s150/NTR-4.gif[/img]

[pikki]

anta ninna ratri par'ty chesi baga s!eep!ng anukunta...malli l't't chesta vachi helf cheyandi

[Josh]

LTT

[pikki]

[img]http://www.desigifs.com/sites/default/files/PK-1.gif?1337149192[/img]

[pandugadu999]

nuvvu aa number active or inactive ani ela differentiate chestavu....there will be some unique number whichdifferentiates them kada.....so nuvvu "order by" aa unique column chey....appudu neeku first inactive numbers and then active numbers orders lo vastay.

[papacha]

konchem engl piece lo cheypava bhaiya asala ardham kaala

[pikki]

[quote name='pandugadu999' timestamp='1364053183' post='1303476208']
nuvvu aa number active or inactive ani ela differentiate chestavu....there will be some unique number whichdifferentiates them kada.....so nuvvu "order by" aa unique column chey....appudu neeku first inactive numbers and then active numbers orders lo vastay.
[/quote]

oka table undi andule active record flag column undi so active record column value 1 and migitavi 0's untayi...query nunchi techukovachu ila...


SELECT main_records,
main_record_flag
FROM records
INNER JOIN sometable
ON records.id= sometable.id
WHERE (where record.activityflag= 0)
AND sometable.Id = @id
GROUP by record.main_records, record.main_record_flag
ORDER BY record.main_records, record.main_record_flag asc

kani ala order by and grouping chese tappudu naku nenu cheepina sequnce lo order avvali records....

fyi - ss'rs vadutunna...

[pikki]

[quote name='papacha' timestamp='1364053341' post='1303476225']
konchem engl piece lo cheypava bhaiya asala ardham kaala
[/quote]

group by and sorting ala ravali pics lo unnatu..see the quer'y

[pandugadu999]

use the column which identifies the "Number" column as either active or inactive in the "Order by" clause..

[chinni005]

[pikki]

[quote name='pandugadu999' timestamp='1364053733' post='1303476265']
use the column which identifies the "Number" column as either active or inactive in the "Order by" clause..
[/quote]

aa field valla raadu..endukante records ila untayi

[b]Main_record [/b] [b][color=#008000]main_record_flag [/color][color=#ff0000]active_flag[/color][/b]

00-001-002-014 1 0
00-001-002-005 0 0
00-001-002-016 0 0

[chinni005]

nuv .net dev kadha.. ivi endhuku

[pikki]

[quote name='RockStarr' timestamp='1364054102' post='1303476305']
nuv .net dev kadha.. ivi endhuku
[/quote]

anni areas cover cheyali dev ante....

[papacha]

eppudu meeku result ela vasthundhi inkonchem elaborate cheyagalara?