Query for display row as column
-
Hi, Following is my table id name designation --------------------------- 1 Prakash Des1 2 Prakash Des2 3 Prakash Des3 4 Prakash Des4 5 Sathish Des5 6 Sathish Des6 I want the query which should display the data like following format id name Des1 Des2 Des3 Des4 ------------------------------------------ 1 Prakash Des1 Des2 Des3 Des4 Thanks Warm Regards Prakash-B
-
Hi, Following is my table id name designation --------------------------- 1 Prakash Des1 2 Prakash Des2 3 Prakash Des3 4 Prakash Des4 5 Sathish Des5 6 Sathish Des6 I want the query which should display the data like following format id name Des1 Des2 Des3 Des4 ------------------------------------------ 1 Prakash Des1 Des2 Des3 Des4 Thanks Warm Regards Prakash-B
this is a display problem select doesn't return "rows", it returns records. but most of the time, we reprensent them horizontally, because of the ease of the view. if you want to display such a thing, you'll have to make the "decomposition" in the displaying job. [edit] will that timorous anonymous guy who vote this to '1' ever show off one day... i persist thinking what i wrote is what to do, and if anybody counter say this, he'll always stay in the dark side of Codeproject, where people act anonymously. :suss: [/edit]
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0] -- modified at 8:07 Friday 23rd December, 2005 -
this is a display problem select doesn't return "rows", it returns records. but most of the time, we reprensent them horizontally, because of the ease of the view. if you want to display such a thing, you'll have to make the "decomposition" in the displaying job. [edit] will that timorous anonymous guy who vote this to '1' ever show off one day... i persist thinking what i wrote is what to do, and if anybody counter say this, he'll always stay in the dark side of Codeproject, where people act anonymously. :suss: [/edit]
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0] -- modified at 8:07 Friday 23rd December, 2005Hi, Can you guide me how to make a decomposition Thanks Warm Regards Prakash-B
-
Hi, Can you guide me how to make a decomposition Thanks Warm Regards Prakash-B
well, i don't know how you display your data, but here are the hints. when you get the set of records from SELECT, you then know the number of records returned. then you can extend your grid depending on that. but i cannot say more, as i don't know which language you're using, nor your database schema... but i hope you see the job to do...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0]