May 16, 2013 at 4:19 am
i have 2 tables
one call it as dbo.t1 and another dbo.t2
t1:
P1 S1 B1 H1 S2 J1
______________________________
b1 s1 b1 s1 b1 s1 ----> these are the merged columns (like: H1 has b1 & s1, S2 has b1 & s1,
J1 has b1 & s1)
May 16, 2013 at 4:39 am
Hi and welcome to the forum.
Unfortunately it's too unclear requirements and details.
Could you please read "forum etiquette" article in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you provide details as per above I'm sure you will get relevant help here in no time!
May 16, 2013 at 4:49 am
sorry mate... it was by mistake.. i have posted d complete thng again.. please check it n reply me bak
May 16, 2013 at 5:21 am
You don't need to post the same question into three different threads.
i have 2 tables
one call it as dbo.t1 and another dbo.t2
t1:
P1 S1 B1 H1 S2 J1
______________________________
b1 s1 b1 s1 b1 s1 ----these are the merged columns (like: H1 has b1 & s1, S2 has b1 & s1,
----------------------------------- J1 has b1 & s1)
pj1 sk1 bu1 2 4 0 2 1 3 --- these r d values in d table
t2:
P1 S1 B1 Fun Val Loc
___________________________________
pj1 sk1 bu1 H1 2 b1
pj1 sk1 bu1 H1 4 s1
--- --- --- S2 0 b1
--- --- --- S2 2 s1
--- --- --- J1 1 b1
--- --- --- J2 3 s1
t1 is the imported table from excel and t2 is the disired output table i need the column names of t1 as values in t2..
Have you had a chance to read an article I've referred you to?
Can you please provide table DDL and sample data insert script, so we don't need to spend extra time to setup everything in order to help you. The article clearly explains how to do so. Just follow the link at the bottom of my signature.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply