Sql Query Help

[Bairagi From Bapatla]

[quote name='Nissan' timestamp='1335373352' post='1301685784']
ee paina columns rendu same datatypes aa?
[/quote]
[quote name='kiraaaak' timestamp='1335373732' post='1301685808']
Avnu ba pl/sql ee ... query annadu kada ani rasesaa
[/quote]okati date and 2nd dhi char baa....

Naku SQL server Query kavali baa...

[NithinKrishna]

select replace(CONVERT( varchar(10) ,'2009-03-05', 111),'-','')

this is SQL server and the previous one as u all know its Oracle.

[dotnetrockz]

@ bairagi
nee scenario ni batti query ila vundachu

1)create a temp table #table1 (date varchar(8),col2,col3)--->define it with same data type as the 3 columnsin table b
2)Insert into #table1 (date,col1,col2) values [color=#ff0000][size=2][color=#0000ff][color=#0000ff][size=2]select[/size][/color][/color][size=2] [color=#ff00ff][color=#ff00ff]Replace[/color][/color][color=#808080][color=#808080]([/color][/color][color=#ff00ff][color=#ff00ff]SUBSTRING[/color][/color][color=#808080][color=#808080]([/color][/color][color=#ff0000][color=#ff0000]'2009-03-05 11:59:30.000'[/color][/color][color=#808080][color=#808080],[/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#000000]10[/color][color=#808080][color=#808080]),[/color][/color][color=#ff0000][color=#ff0000]'-',''),col2,col3 from tableb[/color][/color][/size][/size][/color]

update query
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]UPDATE[/color][/size][/color][/size][size="2"][color="#000000"] A[/color][/size]
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]SET[/color][/size][/color][/size][size="2"] a.col4='some value'[/size]
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]FROM[/color][/size][/color][/size][size="2"] tablea A[/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"] [/color][/size][/color][/size][size="2"][color="#808080"][size="2"][color="#808080"]([/color][/size][/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]NOLOCK[/color][/size][/color][/size][size="2"][color="#808080"][size="2"][color="#808080"])[/color][/size][/color][/size]
[size="2"][color="#808080"][size="2"][color="#808080"]inner join #table1 C[/color][/size][/color][/size]
[size="2"][color="#808080"][size="2"][color="#808080"]on A.col2=C.col2 and A.col3=C.col3[/color][/size][/color][/size]
[size="2"][color="#808080"][size="2"][color="#808080"]inner join [/color][/size][/color][/size][size="2"][color="#808080"][size="2"][color="#808080"],[/color][/size][/color][/size][size="2"]#tableb[/size]
[size="2"]on c.date=b.date[/size]
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]WHERE[/color][/size][/color][/size][size="2"] b.col3='condition here'[/size]

[Bairagi From Bapatla]

[quote name='Nissan' timestamp='1335374610' post='1301685871']
@ bairagi
nee scenario ni batti query ila vundachu

1)create a temp table #table1 (date varchar(8),col2,col3)--->define it with same data type as the 3 columnsin table b
2)Insert into #table1 (date,col1,col2) values [color=#ff0000][size=2][color=#0000ff][color=#0000ff][size=2]select[/size][/color][/color][size=2] [color=#ff00ff][color=#ff00ff]Replace[/color][/color][color=#808080][color=#808080]([/color][/color][color=#ff00ff][color=#ff00ff]SUBSTRING[/color][/color][color=#808080][color=#808080]([/color][/color][color=#ff0000][color=#ff0000]'2009-03-05 11:59:30.000'[/color][/color][color=#808080][color=#808080],[/color][/color][color=#000000]1[/color][color=#808080][color=#808080],[/color][/color][color=#000000]10[/color][color=#808080][color=#808080]),[/color][/color][color=#ff0000][color=#ff0000]'-',''),col2,col3 from tableb[/color][/color][/size][/size][/color]

update query
[size=2][color=#0000ff][size=2][color=#0000ff]UPDATE[/color][/size][/color][/size][size=2][color=#000000] A[/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]SET[/color][/size][/color][/size][size=2] a.col4='some value'[/size]
[size=2][color=#0000ff][size=2][color=#0000ff]FROM[/color][/size][/color][/size][size=2] tablea A[/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]NOLOCK[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size]
[size=2][color=#808080][size=2][color=#808080]inner join #table1 C[/color][/size][/color][/size]
[size=2][color=#808080][size=2][color=#808080]on A.col2=C.col2 and A.col3=C.col3[/color][/size][/color][/size]
[size=2][color=#808080][size=2][color=#808080]inner join [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2]#tableb[/size]
[size=2]on c.date=b.date[/size]
[size=2][color=#0000ff][size=2][color=#0000ff]WHERE[/color][/size][/color][/size][size=2] b.col3='condition here'[/size]
[/quote]
Thnx baa try chestha...

[Bairagi From Bapatla]

baa temp table use cheyakunda direct ga query lo cheyalema.... endhukante millions of records unnai....

[150bryant]

[quote name='Bairagi From Bapatla' timestamp='1335385591' post='1301687274']
baa temp table use cheyakunda direct ga query lo cheyalema.... endhukante millions of records unnai....
[/quote]
temp table lekunda data ni direct cheyi...

[dotnetrockz]

[quote name='Bairagi From Bapatla' timestamp='1335385591' post='1301687274']
baa temp table use cheyakunda direct ga query lo cheyalema.... endhukante millions of records unnai....
[/quote]
rendu tables ki columns diffrent datatypes lo unnai...so naku telsi join aithe fail aithadhi...if u try to do a join using those date columns directly....

temp table lekunta ante telvadhu....oka itertaion lo enni records process chesthundhi.....?

nuvvu em cheyyalna..nee first step...aa date column ee dtae column ni match cheyyadam which i spractically impossible unless u chnage the datatype of either columns which i think is not a solution

inka evarrana edanna cheptharemo chuddam...naku just basic-medium level idea undhi sql anthe...