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
Bewarse Talk Discussion Board * Archives - 2009 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through May 05, 2009 * SQL Experts.. < Previous Next >

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

Codes
Bewarse Legend
Username: Codes

Post Number: 18534
Registered: 05-2006
Posted From: 80.162.7.50

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

Posted on Tuesday, May 05, 2009 - 11:06 am:    Edit Post Delete Post View Post/Check IP
yoo gosi indake dorikindi idi.. work out ayinate vundi..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 61026
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Tuesday, May 05, 2009 - 10:17 am:    Edit Post Delete Post View Post/Check IP
Blazewada:

Table lo edanna primary/unique column meeda distinct operator edite vattadi kada N...



ante unnavi lekkettaalani kaadhu issue,futurelo emanna adding sesina vautomatigaaa raavali

Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Yavvanam Kaatesina Bewarse
Username: Blazewada

Post Number: 1986
Registered: 08-2008
Posted From: 218.186.12.246

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

Posted on Tuesday, May 05, 2009 - 9:50 am:    Edit Post Delete Post View Post/Check IP
Codes:

aa N eni anedi naku teliyaka pote eda nunchi include chesedi..



Table lo edanna primary/unique column meeda distinct operator edite vattadi kada N...
New politics for a New Generation -
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 61022
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Tuesday, May 05, 2009 - 9:40 am:    Edit Post Delete Post View Post/Check IP
http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

eee link choosaava codesh...
Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 61021
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Tuesday, May 05, 2009 - 9:36 am:    Edit Post Delete Post View Post/Check IP
'N' gurinchi theliyakapothe Cognos lo aithe crosstab report gaa cheseyyochu codesh,enni values unte anni columns esukuntaa pothundi linelo...mari SQL lo ante thelavadi

Bewarse Legend Of The Year 2008 Award winner
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Celebrity Bewarse
Username: 420

Post Number: 6134
Registered: 12-2006
Posted From: 194.151.209.207

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

Posted on Tuesday, May 05, 2009 - 9:18 am:    Edit Post Delete Post View Post/Check IP
<<
papam gangu gadinki idee last tournament emo..
>>

SRK is making money by throwing away his matchs .. he is the most intelligent fellow in IPL
DeRailed!
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18532
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 9:15 am:    Edit Post Delete Post View Post/Check IP
knight riders tappute andharu race loo vunnaru..

papam gangu gadinki idee last tournament emo.. :-(
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 36864
Registered: 03-2004
Posted From: 203.200.218.58

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

Posted on Tuesday, May 05, 2009 - 9:13 am:    Edit Post Delete Post View Post/Check IP
//annai patience etannai, evadu test chesadu

dubai lo full bowling pitches...nuvvu entha niladokkukunte antha safe annattu....chusaanu kada 2-3 matches
kanapade nijam: mata maripidi, kanapadanidhi: bhasha marpidi
Top of pagePrevious messageNext messageBottom of page Link to this message

Maanas
Bewarse Legend
Username: Maanas

Post Number: 12026
Registered: 08-2006
Posted From: 125.16.230.192

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

Posted on Tuesday, May 05, 2009 - 9:11 am:    Edit Post Delete Post View Post/Check IP
Prasanth:

patience n aggression baga chupinchaadu





annai patience etannai, evadu test chesadu
Dont ever be stupid again. nobody is going to change!!!
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 36863
Registered: 03-2004
Posted From: 203.200.218.58

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

Posted on Tuesday, May 05, 2009 - 9:11 am:    Edit Post Delete Post View Post/Check IP
//VBIT park mama

ohh ok...nenu 2 years back varaku aa road lone undedhi office..ipudu manikonda lo maa office
kanapade nijam: mata maripidi, kanapadanidhi: bhasha marpidi
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 66178
Registered: 03-2004
Posted From: 86.56.142.18

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

Posted on Tuesday, May 05, 2009 - 9:10 am:    Edit Post Delete Post View Post/Check IP
kothi mama pilaka vundha cuttingsaa...
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 36862
Registered: 03-2004
Posted From: 203.200.218.58

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

Posted on Tuesday, May 05, 2009 - 9:10 am:    Edit Post Delete Post View Post/Check IP
//next week ki shane watson kooda vastadu. sarigga saripotundi combo teamki.

vaadu pak to one day series ku opener ga vachi patience n aggression baga chupinchaadu....form lo unnaadu
kanapade nijam: mata maripidi, kanapadanidhi: bhasha marpidi
Top of pagePrevious messageNext messageBottom of page Link to this message

Maanas
Bewarse Legend
Username: Maanas

Post Number: 12025
Registered: 08-2006
Posted From: 125.16.230.192

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

Posted on Tuesday, May 05, 2009 - 9:10 am:    Edit Post Delete Post View Post/Check IP
Final rajstan vs mumbai anukuntunna
Dont ever be stupid again. nobody is going to change!!!
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Yavvanam Kaatesina Bewarse
Username: Kothi

Post Number: 2397
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Tuesday, May 05, 2009 - 9:10 am:    Edit Post Delete Post View Post/Check IP
VBIT park mama
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1789
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 9:08 am:    Edit Post Delete Post View Post/Check IP
>>>Rthan vollu malli strong avutunaru kadha ,

next week ki shane watson kooda vastadu. sarigga saripotundi combo teamki.

>>> Deccan volla parstiti ayipoyi natu vundi inka.

yep symonds vachi emananna cheyyalsinde. as usual gilly first lo rechipoyadu. ippudu malli tuss.

evadu next match geliste vadu top2 loki vastunnadu. super undi. next match delhi gelavakapothe vaalla paristithi kooda cheppalemu. repu mumbai deccan ni kodithe vaallu number 1 ayipotaru or vice versa
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 36861
Registered: 03-2004
Posted From: 203.200.218.58

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

Posted on Tuesday, May 05, 2009 - 9:08 am:    Edit Post Delete Post View Post/Check IP
avunaa.....ekkada office gacchibowli or madhapur?
kanapade nijam: mata maripidi, kanapadanidhi: bhasha marpidi
Top of pagePrevious messageNext messageBottom of page Link to this message

Maanas
Bewarse Legend
Username: Maanas

Post Number: 12023
Registered: 08-2006
Posted From: 125.16.230.192

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

Posted on Tuesday, May 05, 2009 - 9:08 am:    Edit Post Delete Post View Post/Check IP
Kothi:

Kothi



Dont ever be stupid again. nobody is going to change!!!
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Yavvanam Kaatesina Bewarse
Username: Kothi

Post Number: 2396
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Tuesday, May 05, 2009 - 9:06 am:    Edit Post Delete Post View Post/Check IP
Hi Prasanth Mama

Mass Mama me in HYD.

GF mama Distinct(Attr_Name) from Prod_attributes kottu mama aa N enno vastayyi kada
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1788
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 9:06 am:    Edit Post Delete Post View Post/Check IP
>>>aa N eni anedi naku teliyaka pote eda nunchi include chesedi.

oh ok. ippudu ekkindi. N telidu antavu. is it possible in SQL? i am not sure.
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18531
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 9:04 am:    Edit Post Delete Post View Post/Check IP
adi gaa..

Rthan vollu malli strong avutunaru kadha , Deccan volla parstiti ayipoyi natu vundi inka..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18530
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 9:03 am:    Edit Post Delete Post View Post/Check IP
// veti places lo neeku kavalisina N rows ni include cheseyyi mama

aa N eni anedi naku teliyaka pote eda nunchi include chesedi..

ivala maa net endo problem gaa vundi.. google chesse chance kooda lekunda poyindi..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1787
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 9:02 am:    Edit Post Delete Post View Post/Check IP
>>>atta aite DB loo threaduu enduku vestam


Height, width, Weight - veti places lo neeku kavalisina N rows ni include cheseyyi mama
Top of pagePrevious messageNext messageBottom of page Link to this message

Andhramass
Bewarse Legend
Username: Andhramass

Post Number: 26029
Registered: 07-2006
Posted From: 219.90.188.196

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

Posted on Tuesday, May 05, 2009 - 9:02 am:    Edit Post Delete Post View Post/Check IP
Kothi:



who are you?
మాస్ అంటే ఇష్టం, బెజవాడ అంటే ప్రాణం
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 36859
Registered: 03-2004
Posted From: 203.200.218.58

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

Posted on Tuesday, May 05, 2009 - 9:02 am:    Edit Post Delete Post View Post/Check IP
kothi mama...nuvvenaa..emaipoyaavu..
kanapade nijam: mata maripidi, kanapadanidhi: bhasha marpidi
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Yavvanam Kaatesina Bewarse
Username: Kothi

Post Number: 2395
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Tuesday, May 05, 2009 - 9:01 am:    Edit Post Delete Post View Post/Check IP
PD mama

Welcome GF mama

Height, width, Weight - veti places lo neeku kavalisina N rows ni include cheseyyi mama


inka simple way vundi emo naku teliyadu, naku anta varaku telusu mama
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18529
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 9:00 am:    Edit Post Delete Post View Post/Check IP
//anni ivvalsindega?

atta aite DB loo threaduu enduku vestam..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1785
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 8:58 am:    Edit Post Delete Post View Post/Check IP
>>>nekenduku

Masters chesamga. one year back easyga tattevi. interest is still there
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1784
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 8:57 am:    Edit Post Delete Post View Post/Check IP
>>>those rows can be N rows.. can be 3 or 20.

enni rows unte, anni ivvalsindega?
Top of pagePrevious messageNext messageBottom of page Link to this message

Andhramass
Bewarse Legend
Username: Andhramass

Post Number: 26025
Registered: 07-2006
Posted From: 219.90.188.196

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

Posted on Tuesday, May 05, 2009 - 8:56 am:    Edit Post Delete Post View Post/Check IP
Puli:



nekenduku
మాస్ అంటే ఇష్టం, బెజవాడ అంటే ప్రాణం
Top of pagePrevious messageNext messageBottom of page Link to this message

Puli
Yavvanam Kaatesina Bewarse
Username: Puli

Post Number: 1783
Registered: 05-2007
Posted From: 211.27.67.118

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

Posted on Tuesday, May 05, 2009 - 8:55 am:    Edit Post Delete Post View Post/Check IP
PIVOT ante emi chestundi?
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18526
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 8:53 am:    Edit Post Delete Post View Post/Check IP
kothi mama chala rojula taruvata vochavu.. thnx mama..

kani height , weight , width anedi just example kosam ichanu.. those rows can be N rows.. can be 3 or 20..

emana cheyocha ?
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 66173
Registered: 03-2004
Posted From: 86.56.142.18

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

Posted on Tuesday, May 05, 2009 - 8:50 am:    Edit Post Delete Post View Post/Check IP
kothi mama...
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Kurra Bewarse
Username: Kothi

Post Number: 2394
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Tuesday, May 05, 2009 - 8:49 am:    Edit Post Delete Post View Post/Check IP
SET NOCOUNT ON;
DECLARE @t TABLE (Prod_Name VARCHAR(15), ATTR_name Varchar(15), Attr_Value Int )
INSERT INTO @t (Prod_Name,ATTR_name,Attr_Value) SELECT 'Dell', 'height', 100
INSERT INTO @t (Prod_Name,ATTR_name,Attr_Value) SELECT 'Dell','Width', 200
INSERT INTO @t (Prod_Name,ATTR_name,Attr_Value) SELECT 'Dell', 'Weight', 10

Select * from @t

SELECT Prod_Name, height, Width, Weight
FROM (
SELECT Prod_Name,ATTR_name,Attr_Value
FROM @t) up
PIVOT (SUM(Attr_Value) FOR ATTR_name IN (height, Width, Weight)) AS pvt
ORDER BY Prod_Name
GO
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18523
Registered: 05-2006
Posted From: 217.157.224.42

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

Posted on Tuesday, May 05, 2009 - 8:37 am:    Edit Post Delete Post View Post/Check IP
yea .net lo easy gaa cheya vochu mama.. using LINQ chala simple kani.. database loo chedam ani..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 66171
Registered: 03-2004
Posted From: 86.56.142.18

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

Posted on Tuesday, May 05, 2009 - 8:15 am:    Edit Post Delete Post View Post/Check IP
>>kani what if i dont know how many columns ?

idendhuku mama... .Net loo data componenets vaduthuntee size vachesthadi gaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18522
Registered: 05-2006
Posted From: 212.99.225.2

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

Posted on Tuesday, May 05, 2009 - 8:13 am:    Edit Post Delete Post View Post/Check IP
penks..

-- Pivot table with one row and five columns
SELECT 'AverageCost' AS Cost_Sorted_By_Production_Days,
[0], [1], [2], [3], [4]
FROM
(SELECT DaysToManufacture, StandardCost
FROM Production.Product) AS SourceTable
PIVOT
(
AVG(StandardCost)
FOR DaysToManufacture IN ([0], [1], [2], [3], [4])
) AS PivotTable;


i found something on net.. kani what if i dont know how many columns ?
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Celebrity Bewarse
Username: 420

Post Number: 6132
Registered: 12-2006
Posted From: 194.151.209.207

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

Posted on Tuesday, May 05, 2009 - 8:13 am:    Edit Post Delete Post View Post/Check IP
search PIVOT query example sql server in google ..

DeRailed!
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18521
Registered: 05-2006
Posted From: 212.99.225.2

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

Posted on Tuesday, May 05, 2009 - 8:11 am:    Edit Post Delete Post View Post/Check IP
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 66169
Registered: 03-2004
Posted From: 86.56.142.18

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

Posted on Tuesday, May 05, 2009 - 8:10 am:    Edit Post Delete Post View Post/Check IP
yedhanna web devlopmentaa codes mayya...
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18520
Registered: 05-2006
Posted From: 212.99.225.2

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

Posted on Tuesday, May 05, 2009 - 8:08 am:    Edit Post Delete Post View Post/Check IP
SQL server..
Our Country Will Get the Government It Deserves!
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Celebrity Bewarse
Username: 420

Post Number: 6130
Registered: 12-2006
Posted From: 194.151.209.207

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

Posted on Tuesday, May 05, 2009 - 7:48 am:    Edit Post Delete Post View Post/Check IP
GF mamma .. its possible .. what database are we talking here ?

you want the results Pivoted .. in Oracle its easy peasy ..
DeRailed!
Top of pagePrevious messageNext messageBottom of page Link to this message

Green_nature
Yavvanam Kaatesina Bewarse
Username: Green_nature

Post Number: 2369
Registered: 03-2009
Posted From: 62.12.14.28

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

Posted on Tuesday, May 05, 2009 - 7:43 am:    Edit Post Delete Post View Post/Check IP
GF gaa ....
Top of pagePrevious messageNext messageBottom of page Link to this message

Andhramass
Bewarse Legend
Username: Andhramass

Post Number: 26001
Registered: 07-2006
Posted From: 219.90.188.196

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

Posted on Tuesday, May 05, 2009 - 7:43 am:    Edit Post Delete Post View Post/Check IP
మాస్ అంటే ఇష్టం, బెజవాడ అంటే ప్రాణం
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 18518
Registered: 05-2006
Posted From: 212.99.225.2

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

Posted on Tuesday, May 05, 2009 - 7:42 am:    Edit Post Delete Post View Post/Check IP
Table : Prod_Attributes

Prod_name Attr_Name Attr_Value
Dell height 100
Dell width 200
Dell Weight 10


ippudu nenu ohh query rayali which returns the data something like this..

dell , heigh , width , weight


etta cheyali ? asala possible aa ? grouping , sub query lativi use cheyali emo..
Our Country Will Get the Government It Deserves!

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