Stack Overflow
Stack Overflow

Questions tagged [multirow]

92 questions
0
votes
0 answers

fromjson with different rows

I am trying to convert a json file with R in one go. Unfortunately this approach gives me an error as described below: > fromJSON(res.clean[,2]) Error: parse error: trailing garbage :{"b64_value":"AAAAAA=="}}}]…
Marco De Virgilis
  • 982
  • 1
  • 9
  • 29
0
votes
1 answer

Oracle multi-row 'insert if not exists' from select joined with table literal

Suppose I have the following table structure: a (a_id number primary key, a_code varchar unique not null) b (b_id number primary key, a_id number foreign key references a(a_id), b_value varchar I need to insert on table b a couple hundred pairs of…
Sofia Paixão
  • 309
  • 2
  • 16
0
votes
2 answers

Insert multiple row with condition checking on other table.. only single query

Table1: usermaster uid uname 1 abc 2 xyz 3 pqr 4 def Table2: transactionmaster tid uid amount type 1 1 100 1 2 2 500 1 2 2 500 2 3 1 350 1 3 1 150 2 type in transaction table: 1 for capital 2 for…
Vinay Vadachhak
  • 11
  • 1
  • 5
0
votes
0 answers

Selecting next record from multiple records :SQL

I want to select the next record of a WHERE condition is met . EG REC DATA 10 Name1 20 Address1 30 Post1 10 Name2 20 Address2 30 Post2 Now my query is select * from table where Data = 'Name1' in the result I want REC20 and rec30…
user3855942
  • 75
  • 3
  • 10
0
votes
2 answers

How to convert multiple rows to one row in SQL Server?

I have a problem with a query. Let's say I have two tables named PersonInfo and PersonEducation. I applied join operation on these tables with StudentId and I have a result like that. StudentIdId Name University Department Status …
engkok
  • 25
  • 1
  • 4
0
votes
1 answer

Asp.net Lock/Freeze Multi Row Gridview Headers

I've been giving the task of freezing the headers on my Gridview. The Gridview must also be scrollable. I have accomplished the scrolling feature. I can't get the lock header feature. I've tried various solutions including css styles and JQuery…
Jmunndi
  • 41
  • 2
  • 5
0
votes
2 answers

Possible recursive query in Oracle (pre-11g) to concatenate nested string values

I have an issue regarding multi-row comments in a table that I need to extract as a single string via SQL. I have two tables: test and comment. Here's some example data for each with the desired result set I'm looking for: I'm honestly not even…
user2664961
  • 43
  • 5
0
votes
1 answer

jQGrid With Multiple Row Data

I have a requirement to display a single jqgrid into several lines (2 or 3). The user does not want to use the grid horizontal scroll bar and would like to see several data at once. Anybody with an idea how to do this?
Nap
  • 8,096
  • 13
  • 74
  • 117
0
votes
2 answers

android - How to show multi words page tile of ViewPager using IconPagerAdapter without getting second word being hidden?

How can I show a page title with more than one word without getting the second one being hidden ? Here is the explanation: The blue tab title is a normal title with one word. The red title label contain 2 words but only 1 is shown. Here comes the…
Link 88
  • 553
  • 8
  • 27
0
votes
1 answer

Multirow Update Query with HTML table form

I have the following problem.I have an HTML form with multiple rows. Every row has 4 columns (ID,NAME,LASTNAME,EMAIL). I cannot figure out in my code which is the specific problem that is returned to me: You have an error in your SQL syntax; check…
user2910800
  • 9
  • 6
0
votes
1 answer

Multi-row action for Instead of trigger SQL Server

Scenario/background: I am trying to create a table of "Tests". For purposes of this question my table will only have 5 columns defined as follows: CREATE TABLE TestTable ( Id UNIQUEIDENTIFIER DEFAULT NEWID() NOT NULL, Name VARCHAR(75)…
Chris Sansone
  • 231
  • 1
  • 4
  • 14
0
votes
2 answers

Multiple rows insert auto insert in edit mode with UITextFields, similar to contacts phone/email

I am trying to recreate functionality of similar to adding/editing phone numbers or emails in the contact editing on the iPhone. I always have an empty row with placeholder text available. In edit mode (push of a button on toolbar) I un-hide…
kos
  • 1,357
  • 9
  • 21
-1
votes
1 answer

How to merge cells of row in table in latex?

enter image description here For example i have this table from excel which i want to add in latex. I am trying but ot able to sucesfully manage to do this. any lead to this will great help to me. I tried using multirow in latex but actually did…
Sanchit Jain
  • 75
  • 6
-1
votes
1 answer

Latex: issue with Multirow

I'm using the multirow package to have multiple elements in the same row. \begin{table}[!h] \centering \resizebox{1.0\textwidth}{!}{% \begin{tabular}{l*{4}{c}|cc|c} & \mathcal{D} & $\rho$ & $N_c$ & $N_C^{inv}$ & $C$ & $C^{inv}$ &…
Dario
  • 271
  • 3
  • 15
-1
votes
1 answer

How to combine two cursors in DB2

I have two cursors as below: EXEC SQL DECLARE C1 CURSOR FOR SELECT DISTINCT FIELD_1 FROM TABLE WHERE FIELD_2 BETWEEN :MAX_DATE …
Sunitha S
  • 1
  • 1
  • 3
1 2 3 4 5
6
7