sql doubt -- gali n rowdy

[Jeffa]

REGEX dwara only digits ni capture cheyyataniki try cheyyi baa...easy ga ayipotundi

[galigannarao]

[quote author=HS link=topic=245404.msg3072420#msg3072420 date=1317660003]
space annitlo undo ldo kani [b][[/b] matram undi  aa substring edo ela cheyalo chepu
[/quote]1 min

[htnamus]

[quote author=galigannarao link=topic=245404.msg3072443#msg3072443 date=1317660220]
1 min
[/quote]

select            cost.mas_inv_id as 'Vendor #',
                  cost.route_desc as 'Vendor Name',
                  cost.vendor_circuit_number as 'Vendor Circuit Id'
FROM        CIRCUIT_ORDER CO
                  left outer JOIN CIRCUIT_ORDER_DEFERRED_REVENUE cost
                        ON CO.circuit_number = cost.circuit_number
                        AND CO.order_number = cost.order_number
WHERE      co.order_compl_date between '8/1/2011' and '8/30/2011'

idi query
CITI#H@ CITI#H@ CITI#H@ cry@fl cry@fl cry@fl cry@fl

[Ranga_The_Donga]

[quote author=HS link=topic=245404.msg3072436#msg3072436 date=1317660167]
na circuit IDs ila untai

34.LXFU.401274..SB [AT&T]
nu chepinatu aithe aa LXFU dobbuddi ga
[/quote]

mmmm...

oksari nee circuit ID elavutundhoo cheppu...

ela kavalo cheppu.......

[htnamus]

[quote author=Jeedeelu link=topic=245404.msg3072449#msg3072449 date=1317660299]
mmmm...

oksari nee circuit ID elavutundhoo cheppu...

ela kavalo cheppu.......
[/quote]

34.LXFU.401274..SB [AT&T] untadi nakemo
34.LXFU.401274..SB kavali ... and fixed lengths undavu circuit ids

[htnamus]

[quote author=RODEO link=topic=245404.msg3072441#msg3072441 date=1317660210]
REGEX dwara only digits ni capture cheyyataniki try cheyyi baa...easy ga ayipotundi
[/quote][quote author=HS link=topic=245404.msg3072464#msg3072464 date=1317660426]
34.LXFU.401274..SB [AT&T] untadi nakemo
34.LXFU.401274..SB kavali ... and fixed lengths undavu circuit ids
[/quote] sSa_j@il sSa_j@il sSa_j@il

[galigannarao]

[quote author=HS link=topic=245404.msg3072445#msg3072445 date=1317660269]
select            cost.mas_inv_id as 'Vendor #',
                  SUBSTRING(cost.route_desc,0,CHARINDEX('[',cost.route_desc)) as 'Vendor Name',
                  cost.vendor_circuit_number as 'Vendor Circuit Id'
FROM        CIRCUIT_ORDER CO
                  left outer JOIN CIRCUIT_ORDER_DEFERRED_REVENUE cost
                        ON CO.circuit_number = cost.circuit_number
                        AND CO.order_number = cost.order_number
WHERE      co.order_compl_date between '8/1/2011' and '8/30/2011'

idi query
CITI#H@ CITI#H@ CITI#H@ cry@fl cry@fl cry@fl cry@fl
[/quote]modify chesa chusuko

[htnamus]

[quote author=galigannarao link=topic=245404.msg3072479#msg3072479 date=1317660532]
modify chesa chusuko
[/quote]baaaaaaaaaaaaaaaaaaa  CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# you rock you rock you rock you rock you rock you rock
gutta pagala pani chesindi kani nuvvu vendor name ki rasau  @3$% @3$% @3$%
aina sare  CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D#

[htnamus]

@all  thankyou thankyou thankyou thankyou thankyou thankyou thankyou

[galigannarao]

[quote author=HS link=topic=245404.msg3072488#msg3072488 date=1317660615]
baaaaaaaaaaaaaaaaaaa  CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# you rock you rock you rock you rock you rock you rock
gutta pagala pani chesindi kani nuvvu vendor name ki rasau  @3$% @3$% @3$%
aina sare  CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D#
[/quote]field name seppava *7*^ *7*^

[gvkishore.kish]

[quote author=galigannarao link=topic=245404.msg3072479#msg3072479 date=1317660532]
modify chesa chusuko
[/quote]

CHARINDEX vala use yenti mama..... sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[K.A.Paul]

[quote author=HS link=topic=245404.msg3072435#msg3072435 date=1317660133]
cheppu nayinoooooooooooo  cry@fl cry@fl cry@fl
[/quote]thread title lo na name lekunda ela chepta  ^G#W ^G#W

[galigannarao]

[quote author=gopichand-No1 link=topic=245404.msg3072494#msg3072494 date=1317660657]
CHARINDEX vala use yenti mama..... sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]CharIndex will return the position of the chosen value. fo ex neeku name ila undi John ani CHARINDEX('n','John') will return 3 as output

[htnamus]

[quote author=K.A.Paul link=topic=245404.msg3072495#msg3072495 date=1317660657]
thread title lo na name lekunda ela chepta  ^G#W ^G#W
[/quote] *7*^ *7*^ *7*^ *7*^ *7*^ already galigadu chepesindu ..monna galini anna matalu anni venakki teseskuntuna  sSa_j@il sSa_j@il sSa_j@il

[htnamus]

[quote author=galigannarao link=topic=245404.msg3072491#msg3072491 date=1317660635]
field name seppava *7*^ *7*^
[/quote] you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock you rock