SQL: mutiple rows one column to multiple columns one rowIn InfoMaker SQL can you take a table with multiple
rows for the same key and take a column from the
rows and create mutiple columns with one
report line with the key(no duplicate keys) on a report? For example
Table books
(key) (book title)
123 misery
123 titanic
123 roots
456 war
456 1984
456 giant
The report I need would look like this
Key title1 title2 title 3
123 misery titanic roots
456 war 1984 giant
Thanks in advance.
--
Kaye Hendry
HealthInsight
email:kaye.hendry@healthinsight.org
...
SQL Data displayed row by row
Hi,
I was wondering if it was possible to get some help, what I am trying to do is create a ASP webpage that will display Data from an sql database row by row and if there is no data in one row then it will display a message saying "No Data in row"
Any help would be appreciated
Thanks,
Michael
mstoten: I was wondering if it was possible to get some help, what I am
trying to do is create a ASP webpage that will display Data from an sql
database row by row and if there is no data in one row then it will
display a message saying "No Data i...
First Row, Next Row, Prior Row, Last RowI have a SQL Anywhere 7.0 Database, have a table
Product_detail which contains
Column Name Datatype width Null
Default
batch_id char(10) No None
prod_id Integer No None
employee_id Integer No None
quantity Integer No None
price Numeric (14, 2) No None
Its primary key is batch_id
I have a Freeform Datawindow with this table
I want to provide the first row, next row, prior row and
last row
Ho...
How do I display data from an sql query row by row?
I have the following code (at bottom of msg) in a page I'm trying to write. It works ok with a datagrid but I don't want a datagrid on the page as they look ugly (by default). Questions ...
1. Can I use a datagrid to display data with a custom layout?
2. How can I access data obtained from an sql server stored procedure row by row? I'm told you do it with a Dataset but I don't know how.
The site is to look like this ... http://www.numbersix.co.nz/temp/intranet.jpg ... that's the existing site in ASP but must be converted to ASP.NET to keep up with things.
Can anyone hel...
Hide column data on a row by row basis. How?
I'm sure there is a way to hide/show data of column on a row by row basis.
I've done the following for the admin users, but it displays the whole column.
GridView1.Columns[1].Visible = true;
Let's say I have the following GridView:
Listing
Address
Sale Price
End Date
Tuscany Village
SW I-29 169 Hwy
12/31/2007
Plaza Corporate Center
800 W 47th St
12/31/2007
Ward Parkway Plaza
1414 W 85th St
03/12/2007
Pinnacle Corporate Centre II
11460 Tomahawk Creek Pky
03/12/2007
Corporate Medical Plaza
10777 Nall Ave
03/26/2007...
convert multiple row values into single row
Hi All,
I have to convert multiple row values into single row with multiple columns, can anybody help me in this regard.
Thanks in advance.
can u provide some information. i didn't get ur requirement properly. Clarity is needed.Thank uBabaPlease remember to click "Mark as Answer" on this post if it helped you.
Hi,
Maybe a Pivot Query is what you're looking for?
Greg...
Multiple rows of data into 1 row results?
Is there a way to get multiple rows of data to show in 1 row of results?
I have a Data Table (ID, Name, Date, etc), Facility Table (ID, Name) and FacilityKey Table (Data ID and Facility ID). The Data table has a 1 to many relationship with the FacilityKey table.
I want to return the Data ID and each Facility Name associated with that Data ID to display in a DataGrid (preferably each Facility Name in the same cell on the grid too), but am stumped on how to get teh query to work (or where to look in the SQL documentation for something like this).
Thanks!
What you are trying to do is...
How can I display multiple rows w/8 columns (4 columns editable on each row)?
Hello,
Please - Can anyone suggest the best way to display a joined dataset with 4 read-only columns, 4 editable columns and a checkbox column?
The content for this display currently has < 100 rows - but could approach 1000 in the future.
I currently have this setup with a Datagrid (working) - but I would like to be able to edit the 4 columns of ALL rows in the displayed list instead of one row at a time as the Datagrid allows.
After editing, I use an update function to traverse the modified list/table and save all values that have the Checkbox clicked.
Could a list with 10...
is it possible to turn 1 column,many rows into one row,many columns in sql ?
Hi AllI have the following query:Select CategoryName From Category Where CategoryId In(Select SkillId From SpecialitySkills Where CopywriterId = 13) It gives me the correct results but not in the form that i want, i would like it to be in one row, many columns. its in 1 column, many rows.Any ideas?
You must be talking about displaying it on a web page? Just create a loop that runs through the rows of the data that is returned then just make html table:dim tablestring as string = "<table><tr>" for i as integer = 0 to dt.rows.count - 1 tablestring += &...
ADO.net problem: i can not view image data for the rest of my table rows except the image for the first row but i can read all the other non image fields for all rows.
Hi i have a table with the following fields
imgid............int
imgdata........image
imgtitle.........varchar(max)
imgType........varchar(max)
imgLength.....bigint
incident_id.....int
i have no problem with uploading the image but viewing the uploaded image(s) in a gridview has caused me great pain. The probelm is i have two pages. page1 grabs the image to display and page2 has a gridview that displays the grabed image. I wanted to have an sql statement like
SELECT * FROM mytable WHERE incident_id=someValue.
IF i have 5 records in this table and i view page2 ...
Multiple grid rows per Data row in GridView
I have a dataset that is binded to a gridview.
The dataset has 5 fields and a description.
I want to display 1 row for the 5 short fields and 1 row underneath it for the description. (per record)
For example:
ID Name Surname Field3 Field 4
1 John Smith blah blah
This is the long description for John Smith spanning 5 cells
2 Peter Parker blah blah
This is t...
Retrieve data row by row and multiple SELECT statements.
hai to all experts out there,can somebody help me please! I would like to do this sql select statement in vb.net in order to display the output in a gridview.
I have a table name TBL_DOC consist of ID,DOC_NO,PIC_FLAG,MPIC1,MPIC2,MPIC3,MPIC4 ,MPIC5 columns.
My intention is first i want to retrieve PIC_FLAG column data from all rows in TBL_DOC table row by row like this:
SELECT PIC_FLAG FROM TBL_DOC
and then if PIC_FLAG = 'MPIC1' i want to do another select statement like this in the same table:
SELECT ID,DOC_NO,PIC_FLAG,MPIC1 FROM TBL_DOC where PIC_FLAG = 'MPIC1...
How to transform SQL output rows into GridView rows+columns?
This is somewhat tricky to explain. What I am trying to do is link the output from a SQL query that is grouped into rows and turn that into a set of rows and columns.
ex: turn this (from SQL):
sqlcol1sqlcol2sqlcol3
row_1
col_a
1
row_1
col_b
2
row_1
col_c
3
row_2
col_a
4
row_2
col_b
5
into this (in GridView):
col_acol_bcol_c
row_1
1
2
3
row_2
4
5
I am thinking that the best way of doing this is to inherit from GridView and to write a custom metho...
How to go through a datatable row by row and column by column
Hello, I have a dataset with a datatable and I need to insert each row from the datatable on my sql table, anyway there may be errors, so some rows may not be inserted because primary key constraints, So I need to show the rows that are not inserted in a gridview, the hard thing to do is to go through all the datatable, is there an wasy way to do it?MCPD ENTERPRISE APPLICATION DEVELOPER
Start by looking herehttp://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspxPerform an update of your dataset, and if a row fails, you can mark it as invalid.You can ...