Calling SQL experts urgent

[The QUEEN]

to_date('2010/'||TO_CHAR(wdrl_mont h)||'/01', 'YYYY/MM/DD')

to_date lo 01 mention chesav, so Jan vastundemo  sCo_^Y naku ipudu db access ledu, check this once

[Gachibowli_Diwakar]

$%^ $%^ $%^

[galigannarao]

[quote author=The QUEEN link=topic=229227.msg2831153#msg2831153 date=1314238313]
to_date('2010/'||TO_CHAR(wdrl_mont h)||'/01', 'YYYY/MM/DD')

to_date lo 01 mention chesav, so Jan vastundemo  sCo_^Y naku ipudu db access ledu, check this once
[/quote]akkada 01 annadi day ranigaru so no probs

[galigannarao]

[quote author=Musugu_Veerudu link=topic=229227.msg2831177#msg2831177 date=1314238559]
$%^ $%^ $%^
[/quote] *7*^ doubt adigite dance ettava

[nenuinthe]

gali baa na daggira SQL ledu kani try cheyyataniki.....

prastutaniki na burra lo unna dani prakaram ithe first oka temp table or table variable create chesi dantlo MONTH ane column petti Jan nundi Dec varuku insert cheyyi.....


tarvata select MONTH, Value as null  from temptable left join ani ne select statement rasukuni mottam leni months data anta techuko

union petti

ne original slect statement rasuko....

[The QUEEN]

[quote author=galigannarao link=topic=229227.msg2831184#msg2831184 date=1314238610]
akkada 01 annadi day ranigaru so no probs
[/quote] F@!n F@!n @gr33d @gr33d  CITI#H@

[galigannarao]

[quote author=BEZAWADA ROWDY link=topic=229227.msg2831191#msg2831191 date=1314238656]
gali baa na daggira SQL ledu kani try cheyyataniki.....

prastutaniki na burra lo unna dani prakaram ithe first oka temp table or table variable create chesi dantlo MONTH ane column petti Jan nundi Dec varuku insert cheyyi.....


tarvata select MONTH, Value as null  from temptable left join ani ne select statement rasukuni mottam leni months data anta techuko

union petti

ne original slect statement rasuko....
[/quote] thankyou baa try chesi chebuta undu

[Gachibowli_Diwakar]

[quote author=galigannarao link=topic=229227.msg2831188#msg2831188 date=1314238627]
*7*^ doubt adigite dance ettava
[/quote]I not developer  sSa_j@il  .. I only Administrator  &D_@@

[galigannarao]

[quote author=Musugu_Veerudu link=topic=229227.msg2831210#msg2831210 date=1314238841]
I not developer  sSa_j@il  .. I only Administrator  &D_@@
[/quote] @3$% @3$%

[K.A.Paul]

[quote author=Musugu_Veerudu link=topic=229227.msg2831210#msg2831210 date=1314238841]
I not developer  sSa_j@il  .. I only Administrator  &D_@@
[/quote]

I am Tea lead  LoL.1q LoL.1q

[Ka NTR i]

[quote author=galigannarao link=topic=229227.msg2830816#msg2830816 date=1314235232]
select
    se q_no,
    wdrl _gpm_amt,
    to_char(to_date('2010/'||TO_CHAR(wdrl_mont h)||'/01', 'YYYY/MM/DD'), 'MONTH') wdrl_mont h_desc
  from
    dg_water_ report_detail
  where
    water_rep ort_seq_no = 12517
  order by
    wdrl_mont h

this is my query to return the no,amt,month. currently its returning only the existing month records. if suppose a record for jan exists it is returning only that record. so iwant to append the other month records with empty data can you give some idea.
[/quote]


Baa... nuvvu "water_rep ort_seq_no = 12517" where condition lo sequence number ichaavu.... So aa seq numberse vasthaai...

and you donn have any restrictions on month... so you will get all all the data....

naaku ... cretae table statements... sample data(insert statements) and desired output...isthe... i will try....


but my doubt... check where condition....

[The QUEEN]

TO_DATE(TO_CHAR(date,format))  try this  sCo_^Y

[Ka NTR i]

[quote author=The QUEEN link=topic=229227.msg2831224#msg2831224 date=1314239095]
TO_DATE(TO_CHAR(date,format))  try this  sCo_^Y
[/quote]

  sCo_^Y sCo_^Y  dhaniki... dataki relation enti?

[nenuinthe]

SELECT TOP 12
DATENAME(MONTH, DATEADD(MONTH,ROW_NUMBER() OVER (ORDER BY object_id) - 1,0))
FROM sys.columns

e result set lo jan,feb,mar anni vachestay dec varuku...dini result set temp table loki insert chesukuni dani mida joins rayi.....

[galigannarao]

[quote author=BEZAWADA ROWDY link=topic=229227.msg2831257#msg2831257 date=1314239337]
SELECT TOP 12
DATENAME(MONTH, DATEADD(MONTH,ROW_NUMBER() OVER (ORDER BY object_id) - 1,0))
FROM sys.columns

e result set lo jan,feb,mar anni vachestay dec varuku...dini result set temp table loki insert chesukuni dani mida joins rayi.....
[/quote]kummavu po. exactly what i am looking for baaaa H&*() H&*() H&*()