How to do output as below? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

How to do output as below?

Author

Topic

mnymny
Starting Member

7 Posts

Posted - 2011-11-10 : 02:28:32

Col1 Col2 Col3 Col4 Col5 Col6
Value0 Value1 Value2 Value3 Value4 Value5
Value21 Value31 Value51
Value22 Value21 Value52
Value23 Value53
Value54

Help me.
mnymny

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 03:07:20

how are values stored in table? are they coming from single field?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 03:32:02

format is confusing. can you please post it between [code] tags

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 03:44:36

see how to post a queation

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

mnymny
Starting Member

7 Posts

Posted - 2011-11-10 : 04:04:45

thks
my table:

tbl1(tbl1id,tbl1col1,tbl1col2,tbl1col3)
tbl2(tbl2id,tbl2col1,tbl2col2,tbl2col3,tbl2col4,tbl2col5,tbl1id)
tbl3(tbl3id,tbl3col1,tbl3col2,tbl1id)

help me output :

thks for your help.

mnymny

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 04:07:17

you're not helping us at all. I'm still struggling to understand which value is for which column. also we've no idea how original data resides in your tables.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

mnymny
Starting Member

7 Posts

Posted - 2011-11-10 : 20:01:31

thks
my table:

tbl1(tbl1id,tbl1col1,tbl1col2,tbl1col3)
tbl2(tbl2id,tbl2col1,tbl2col2,tbl2col3,tbl2col4,tbl2col5,tbl1id)
tbl3(tbl3id,tbl3col1,tbl3col2,tbl1id)

http://up.anhso.net

Now I want result as following.
help me output :

thks for your help.

mnymny

mnymny
Starting Member

7 Posts

Posted - 2011-11-11 : 01:36:25

Who help me!!!

mnymny

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-11 : 03:32:41

quote:
Originally posted by mnymny

Who help me!!!

mnymny

If you want help first post data as in below format

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources