Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2016 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 14, 2016 * Sql qwechanu... < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145635
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:47 pm:    Edit Post Delete Post Print Post

heem ra, PD gaanithoone etakarama...CLIPART--big_fight
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124777
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:43 pm:    Edit Post Delete Post Print Post


Proofdada:

gentaku vandha isthara...20 ku outsrc cheesi bathikestha...


ya vandha pounds mutton isthaaru kottataaniki ....
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145634
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:41 pm:    Edit Post Delete Post Print Post


Nalla_baalu:


gentaku vandha isthara...20 ku outsrc cheesi bathikestha...
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124776
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:38 pm:    Edit Post Delete Post Print Post


Proofdada:


telisinolaladhi halal shop undhi ...mutton kodathaara
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145633
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:36 pm:    Edit Post Delete Post Print Post


Nalla_baalu:


naakkoda dallas lo oka job set cheyichachu kadha uzless...
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124775
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:34 pm:    Edit Post Delete Post Print Post


Proofdada:

atlanta loo karvulochayat ga... monna boob septhunde


ilaanti dialogue kodathaarane inthaka mundhu crrect cheyyaledhu mimmalni ... atl ki ellaledhu asalu virginia lo ne job set ayyindhiMOVIEART--ali.etakaram
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145631
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:33 pm:    Edit Post Delete Post Print Post


Nalla_baalu:


atlanta loo karvulochayat ga... monna boob septhundeMOVIEART--bemmi.ok
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124774
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:32 pm:    Edit Post Delete Post Print Post


Proofdada:

ninnu dallas lo thanthe atlanta lo endhuk paddav....


light weight kabatti MOVIEART--mb.siggu
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145630
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:31 pm:    Edit Post Delete Post Print Post


Nalla_baalu:


ninnu dallas lo thanthe atlanta lo endhuk paddav....ninnu sudan loki kadha thannindhi...
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124773
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:30 pm:    Edit Post Delete Post Print Post


Proofdada:

anthe bhaal ga... okkosaari rayalsi vachudhi... thops ayithe thakkuva lines lo raasestharu gwass lantollu...


asalu mee questions ki intha opika ga enduku answers isthunnaru
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145629
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:29 pm:    Edit Post Delete Post Print Post


Nalla_baalu:


anthe bhaal ga... okkosaari rayalsi vachudhi... thops ayithe thakkuva lines lo raasestharu gwass lantollu...
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124772
Registered: 06-2011
Posted From: 98.169.48.149

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:26 pm:    Edit Post Delete Post Print Post

enti ee joins thika maka gaa unnai
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145628
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:26 pm:    Edit Post Delete Post Print Post


Gochi:


gwass bha neenu pettina whole query lonchi


select x.projectActvitynumber from (select pp.project acttivintynumber, max(maxDate) from all joins group by projectactivitynumber) as x

pedithe poddemoo ga
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145627
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:23 pm:    Edit Post Delete Post Print Post

idantha inko sql lo veesi join cheyyatme anukunta...
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 86939
Registered: 07-2004
Posted From: 8.7.228.252

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:23 pm:    Edit Post Delete Post Print Post


Proofdada:

ikkdi dhaka ayyakaa
i need to left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz

dhaanni elaa rayochu




artham kaalaa....just inkoka left join esesthey aipyindhi kadhaa...indulo question enti?


select count(c.*) from [JobCenter3R2Prod].[dbo].[ProjectProfessionals] as c

left join [JobCenter3R2Prod].[dbo].[Projects] as a
on c.ProjectID = a.ProjectID


left join (select ProjectID,max(MileStoneDate) as MaxDate from [JobCenter3R2Prod].[dbo].[ProjectMilestones] group by projectID) as b
on c.[ProjectID] = b.[ProjectID] and year(b.MaxDate) = 2015


left join [JobCenter3R2Prod].[dbo].[ProjectStatusTypes] as a1
on a1.[ProjectStatusTypeID] = a.[ProjectStatusTypeID]

left join [JobCenter3R2Prod].[dbo].[ProjectProperties] as pp
on pp.ProjectActivityID = c.ProjectActivityID and pp.City in( 'Atlanta', ',Atlanta','atlanta')


left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz on xyz.activityid = .....activityid
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145626
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:15 pm:    Edit Post Delete Post Print Post


Stewie:



Gochi:





ipudu


select count(c.*) from [JobCenter3R2Prod].[dbo].[ProjectProfessionals] as c

left join [JobCenter3R2Prod].[dbo].[Projects] as a
on c.ProjectID = a.ProjectID


left join (select ProjectID,max(MileStoneDate) as MaxDate from [JobCenter3R2Prod].[dbo].[ProjectMilestones] group by projectID) as b
on c.[ProjectID] = b.[ProjectID] and year(b.MaxDate) = 2015


left join [JobCenter3R2Prod].[dbo].[ProjectStatusTypes] as a1
on a1.[ProjectStatusTypeID] = a.[ProjectStatusTypeID]

left join [JobCenter3R2Prod].[dbo].[ProjectProperties] as pp
on pp.ProjectActivityID = c.ProjectActivityID and pp.City in( 'Atlanta', ',Atlanta','atlanta')


ikkdi dhaka ayyakaa

i need to left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz

dhaanni elaa rayochu


CLIPART--uhoh
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145624
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 11:21 am:    Edit Post Delete Post Print Post


Stewie:

not helping..


nuvvu idheega...MOVIEART--bemmi.etakaram
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Kurra Bewarse
Username: Stewie

Post Number: 3843
Registered: 03-2011
Posted From: 104.245.210.36

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 11:19 am:    Edit Post Delete Post Print Post


Proofdada:

okkadki sql radha... vachi.




Annai there is fine line between .. not knowing and not helping.. MOVIEART--bemmi.laugh
A Famous Quote starts with a... and ends with this.
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Celebrity Bewarse
Username: Blazewada

Post Number: 26105
Registered: 08-2008
Posted From: 58.182.87.144

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 8:22 am:    Edit Post Delete Post Print Post


Proofdada:

neekentha jujubi sett bha...




dada nenu yaaverage developer ni, edo nettukostunna.
meeki ganaka tayam unte oka look eyundri samples.
naa valla kaatledu, eellu rojuko rakamga marustunnaru requirements, inka dani paina ee automation.
MOVIEART--bemmi.abba
जिसको ढूंढे बाहर बाहर - वो बैठा है भीतर छुप के
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145620
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 8:17 am:    Edit Post Delete Post Print Post


Blazewada:

REST Webservices, JSON input/output testing automation emanna chesara meeru?


naan seyyala kaani kelekagalanu... neekentha jujubi sett bha...
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Celebrity Bewarse
Username: Blazewada

Post Number: 26103
Registered: 08-2008
Posted From: 58.182.87.144

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 8:15 am:    Edit Post Delete Post Print Post


Proofdada:



Maveric:




REST Webservices, JSON input/output testing automation emanna chesara meeru? ippudu nerchukuni savali adi kooda

selenium kooda pani lo pani nerchukovalani peekutandi. proifle lo add aiddi ani
जिसको ढूंढे बाहर बाहर - वो बैठा है भीतर छुप के
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145619
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 7:38 am:    Edit Post Delete Post Print Post


Maveric:


eeyy naadhi sql kaadhi... BI dash boards prove seyyali ante DWH lokelli sqls raasi idhigoo meerichina data idhe... adhee choopisthunnam qlikview Dashboard loo kooda ani soopiyyali business users ku ...
Top of pagePrevious messageNext messageBottom of page Link to this message

Maveric
Yavvanam Kaatesina Bewarse
Username: Maveric

Post Number: 6211
Registered: 01-2012
Posted From: 165.225.104.60

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:42 am:    Edit Post Delete Post Print Post

ee PD annai anavarsanga ee sql lo vesaru...adi edo
testing lo vesina bagaundu..oka moolana kookuni testcases excute cheskuntu vundevaru..... MOVIEART--bemmi.aggipulla
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 86938
Registered: 07-2004
Posted From: 8.7.228.252

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, March 08, 2016 - 12:13 am:    Edit Post Delete Post Print Post


Proofdada:

not equal to ante <> ee na...




yaa...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145618
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 10:45 pm:    Edit Post Delete Post Print Post

not equal to ante <> ee na...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145617
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:34 pm:    Edit Post Delete Post Print Post


Gochi:


thanks ba...MOVIEART--chalayyachalu
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 86937
Registered: 07-2004
Posted From: 64.121.82.184

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:28 pm:    Edit Post Delete Post Print Post

select * from [JobCenter3R2Prod].[dbo].[Projects] as a
left join (select projectid, max(milestonedate) max_date from [JobCenter3R2Prod].[dbo].[ProjectMilestones] group by projectid) as b
on a.projectid = b.projectid and year(b.max_date) = 2015


ittaa dobbinchukovali..
Top of pagePrevious messageNext messageBottom of page Link to this message

Krishna_jilla
Kurra Bewarse
Username: Krishna_jilla

Post Number: 2280
Registered: 04-2015
Posted From: 50.90.117.162

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:22 pm:    Edit Post Delete Post Print Post


Proofdada:

oohoo ninnu adiganani feel ayithiva.


ledu ni baadha chudaleka ala o dialogue esa...CLIPART--a140
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 86936
Registered: 07-2004
Posted From: 64.121.82.184

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:20 pm:    Edit Post Delete Post Print Post

MOVIEART--bemmi.laugh
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145615
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:19 pm:    Edit Post Delete Post Print Post


Krishna_jilla:


oohoo ninnu adiganani feel ayithiva...MOVIEART--bemmi6... gossi khanoo... leeka tech-beeshma strawi laantollochi septharemo anukunya...
Top of pagePrevious messageNext messageBottom of page Link to this message

Krishna_jilla
Kurra Bewarse
Username: Krishna_jilla

Post Number: 2279
Registered: 04-2015
Posted From: 50.90.117.162

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:17 pm:    Edit Post Delete Post Print Post


Proofdada:

idhi work out ayyindhi... mee mohala manda... okkadki sql radha... vachi...




select * from lantivi unte adugu annai chepta.. CLIPART--5run
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145614
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:17 pm:    Edit Post Delete Post Print Post

inko left join kotti... aa group by pina oka where clause pedithe... result zero vachindhi...MOVIEART--idea
Top of pagePrevious messageNext messageBottom of page Link to this message

Krishna_jilla
Kurra Bewarse
Username: Krishna_jilla

Post Number: 2278
Registered: 04-2015
Posted From: 50.90.117.162

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:16 pm:    Edit Post Delete Post Print Post


Proofdada:

annay lousiville,KY loo krotha job vachindhi thesukunt epoddemoo... ee NY client bending naa vatla kavatla...


da ochey weekend weekend ochi java cheinchknta nitho...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145613
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:06 pm:    Edit Post Delete Post Print Post

elect a.ProjectID from [JobCenter3R2Prod].[dbo].[Projects] as a

left join [JobCenter3R2Prod].[dbo].[ProjectMilestones] as b
on a.[ProjectID] = b.[ProjectID]

group by a.ProjectID having year( max(b.MilestoneDate)) = 2015


idhi work out ayyindhi... mee mohala manda... okkadki sql radha... vachi...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145612
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:03 pm:    Edit Post Delete Post Print Post


Krishna_jilla:


annay lousiville,KY loo krotha job vachindhi thesukunt epoddemoo... ee NY client bending naa vatla kavatla...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145611
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:03 pm:    Edit Post Delete Post Print Post

bongu kooda pani seyyala thupak...
Top of pagePrevious messageNext messageBottom of page Link to this message

Krishna_jilla
Kurra Bewarse
Username: Krishna_jilla

Post Number: 2276
Registered: 04-2015
Posted From: 50.90.117.162

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 9:00 pm:    Edit Post Delete Post Print Post

baaga bending aithunatu unnav ga annai.. peace ga vundhi..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145610
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:52 pm:    Edit Post Delete Post Print Post

execute cheesi thagaldatha choodam etavudhoo...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145609
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:52 pm:    Edit Post Delete Post Print Post

MOVIEART--bemmi.sarle
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145608
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:51 pm:    Edit Post Delete Post Print Post

randi babulu randi naa mohana oka sql line veesi vellandi...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145607
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:50 pm:    Edit Post Delete Post Print Post

*2015
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145606
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:50 pm:    Edit Post Delete Post Print Post

b table loo oka project id ku multple dates vuntayi... so vatillo max date kaavali and dhaani year kaavali, but condition lo aa year 205 set chesina parla... seppandi correctoo kaahdu aa dates rashtunna type work out avudha?
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 145605
Registered: 03-2004
Posted From: 71.170.93.71

Rating: N/A
Votes: 0 (Vote!)

Posted on Monday, March 07, 2016 - 8:48 pm:    Edit Post Delete Post Print Post

select *(idhi emanna kavachu) from [JobCenter3R2Prod].[dbo].[Projects] as a

left join [JobCenter3R2Prod].[dbo].[ProjectMilestones] as b
on b.projectid = a.projectid and year( max(b.milestonedate)) = 2015


ilaa rayacha?

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration