Sql Pin Koncham Help Kavali Urgent... To My Friend

[kakatiya]

[quote name='karna11' timestamp='1342724439' post='1302162318']
job support or Eminaa Help? emina help kavalantee seppu or job support ithe i can't
[/quote]

yeah some code vundhi..

adhi paste cheyaleptunna ikkada

[kakatiya]

[quote name='JUJUBI_JULABI' timestamp='1342724759' post='1302162406']
ikkada chepochu ga em kavalo ..
[/quote]


a code lo company peru vnudhi bayya andukani .. i am not posting here

[JUJUBI_JULABI]

[quote name='kakatiya' timestamp='1342724977' post='1302162467']


a code lo company peru vnudhi bayya andukani .. i am not posting here
[/quote]
pm cheyy , nenu sql e

[innovative]

I can try .. replace company name with some name say "abc_company"

[kakatiya]

sure i sent you pm

[karna11]

[quote name='kakatiya' timestamp='1342724953' post='1302162461']

yeah some code vundhi..

adhi paste cheyaleptunna ikkada
[/quote]
pm sesukooo

[gundugadu]

[quote name='kakatiya' timestamp='1342720607' post='1302161832']
please verify..
[/quote]
yem kavali bayya

tell me i say

[kakatiya]

[quote name='gundugadu' timestamp='1342741807' post='1302164101']
yem kavali bayya

tell me i say
[/quote]

bhayya neeku pm chestha

[kakatiya]

this is the problem bhayya.. nenu n/w engineer..

aa ammayi cheppedhi ardam kaadu naaku

[color=#282828][font=arial, sans-serif][size=3]ok this insert table creates two tables..[/size][/font][/color]

[color=#282828][font=arial, sans-serif][size=3]based on this two tables data third table loki query velli table create avvali anta..[/size][/font][/color]

[color=#282828][font=arial, sans-serif][size=3]she is trying using pivot element conversion.... somethign.. that pushes and creates third table.. [/size][/font][/color]

[color=#282828][font=arial, sans-serif][size=3]i need to send you the word document [/size][/font][/color] [color=#282828][font=arial, sans-serif][size=3] but how ??[/size][/font][/color]

[kakatiya]

i finally uploaded document


the new table should be result of query from table 1 and table 2
... as explained below
[url="http://www.scribd.com/doc/100572363/Query-Analyser"]http://www.scribd.com/doc/100572363/Query-Analyser[/url]

[Diras]

lyt

[saritha24]

Did you get what you need?

[saritha24]

CREATE TABLE T1 (ItemNumber bigint, Itemdesc varchar(100))
INSERT INTO T1 VALUES (1010100001, '63.5 x 76.0 x 300 GSM ITC CFBB')
CREATE TABLE T2 (ItemNumber bigint, segmentcode varchar(10), segmentdesc varchar(100), segmentvalue varchar(100))
INSERT INTO T2 VALUES (1010100001, 'UD1','Class Level1','Paper&Board')
INSERT INTO T2 VALUES (1010100001, 'UD2','Class Level2','CFBB')
INSERT INTO T2 VALUES (1010100001, 'UD3','Class Level3','ITC CFBB')
INSERT INTO T2 VALUES (1010100001, 'UD4','Class Level4','DIRECT')
INSERT INTO T2 VALUES (1010100001, 'UD5','Class Level5',NULL)
INSERT INTO T2 VALUES (1010100001, 'UD6','GSM','300')
INSERT INTO T2 VALUES (1010100001, 'UD7','SIZE','63.5 x 76.0')
INSERT INTO T2 VALUES (1010100001, 'UD8','Manufacturer','IT LIMITED-BHADRACHALAM')


SELECT A.ItemNumber, A.ItemDesc, B.ud1, B.ud2, B.ud3 , B.ud4, B.ud5, B.ud6, B.ud7, B.ud8
FROM T1 AS A JOIN (
SELECT itemnumber, [ud1],[ud2],[ud3],[ud4],[ud5],[ud6],[ud7],[ud8]
FROM ( SELECT itemnumber, [segmentcode], segmentvalue
from T2
) P PIVOT ( MAX(segmentvalue) for [segmentcode] IN ([ud1],[ud2],[ud3],[ud4],[ud5],[ud6],[ud7],[ud8])
) AS Pvt
) B ON A.ItemNumber = B.ItemNumber



Try replacing T1, T2 with your table names. Good Luck!!

[ManOnFire]

[karna11]

[quote name='saritha24' timestamp='1342766474' post='1302166352']
CREATE TABLE T1 (ItemNumber bigint, Itemdesc varchar(100))
INSERT INTO T1 VALUES (1010100001, '63.5 x 76.0 x 300 GSM ITC CFBB')
CREATE TABLE T2 (ItemNumber bigint, segmentcode varchar(10), segmentdesc varchar(100), segmentvalue varchar(100))
INSERT INTO T2 VALUES (1010100001, 'UD1','Class Level1','Paper&Board')
INSERT INTO T2 VALUES (1010100001, 'UD2','Class Level2','CFBB')
INSERT INTO T2 VALUES (1010100001, 'UD3','Class Level3','ITC CFBB')
INSERT INTO T2 VALUES (1010100001, 'UD4','Class Level4','DIRECT')
INSERT INTO T2 VALUES (1010100001, 'UD5','Class Level5',NULL)
INSERT INTO T2 VALUES (1010100001, 'UD6','GSM','300')
INSERT INTO T2 VALUES (1010100001, 'UD7','SIZE','63.5 x 76.0')
INSERT INTO T2 VALUES (1010100001, 'UD8','Manufacturer','IT LIMITED-BHADRACHALAM')


SELECT A.ItemNumber, A.ItemDesc, B.ud1, B.ud2, B.ud3 , B.ud4, B.ud5, B.ud6, B.ud7, B.ud8
FROM T1 AS A JOIN (
SELECT itemnumber, [ud1],[ud2],[ud3],[ud4],[ud5],[ud6],[ud7],[ud8]
FROM ( SELECT itemnumber, [segmentcode], segmentvalue
from T2
) P PIVOT ( MAX(segmentvalue) for [segmentcode] IN ([ud1],[ud2],[ud3],[ud4],[ud5],[ud6],[ud7],[ud8])
) AS Pvt
) B ON A.ItemNumber = B.ItemNumber



Try replacing T1, T2 with your table names. Good Luck!!
[/quote]
idhii try sesavaaaa