SQL Query - converting the first data set to the desired format

Replies

• 

  ankur8819

  Pasting the Screen shot for more clarification
• 

  PraveenKumar Purushothaman

  Dude, check this out:
  

  select * from ankur;
  +-------+------+---+
  | A     | B    | C |
  +-------+------+---+
  | 18184 | asas | 1 |
  | 18184 | dfdf | 1 |
  | 18185 | qwer | 2 |
  | 18185 | qwio | 2 |
  | 18186 | ank  | 3 |
  | 18187 | ur   | 4 |
  +-------+------+---+
   
  select A, group_concat(b) as B, C from ankur group by c;
  +-------+-----------+---+
  | A     | B         | C |
  +-------+-----------+---+
  | 18184 | asas,dfdf | 1 |
  | 18185 | qwer,qwio | 2 |
  | 18186 | ank       | 3 |
  | 18187 | ur        | 4 |
  +-------+-----------+---+

  Hope this helps you... 😀 All the best!!! 😁
• 

  PraveenKumar Purushothaman

  I used this query!
  

  CREATE TABLE `ankur` (
    `A` int(11) NOT NULL,
    `B` varchar(255) NOT NULL,
    `C` int(11) NOT NULL,
    PRIMARY KEY (`B`,`C`)
  ) ENGINE=InnoDB ;
   
   
  INSERT INTO `ankur` (`A`, `B`, `C`) VALUES
  (
    '18184', 'asas', '1'
  ), (
    '18184', 'dfdf', '1'
  ), (
    '18185', 'qwer', '2'
  ), (
    '18185', 'qwio', '2'
  ), (
    '18186', 'ank', '3'
  ), (
    '18187', 'ur', '4'
  );

  Hope this helps! 😀
• 

  ankur8819

  Thanks Praveen
  I did it using the below query.
  Select a,stragg(b),c from ankur group by a,c
• 

  PraveenKumar Purushothaman

  ankur8819

  Thanks Praveen
  I did it using the below query.
  Select a,stragg(b),c from ankur group by a,c

  Awesome! 😀
• 

  RAANA

  can anybody plz help me to write the query for copying data from one table into another in C#?
• 

  PraveenKumar Purushothaman

  RAANA

  can anybody plz help me to write the query for copying data from one table into another in C#?

  Bulk Copy feature of ADO.NET might help you take a look at that: #-Link-Snipped-#
• 

  PraveenKumar Purushothaman

  This is the simplest way to copy a table into another (new) table in the same SQL Server database. This way of copying does not copy constraints and indexes.

  select * into  from 
   
   
  Example:
  Select * into employee_backup from employee

  We can also select only a few columns into the destination table like below

  select col1, col2, col3 into 
  from 
   
  Example:
  Select empId, empFirstName, empLastName, emgAge into employee_backup
  from employee

  Use this to copy only the structure of the source table.

  select * into  from  where 1 = 2
   
  Example:
  select * into employee_backup from employee where 1=2

  Use this to copy a table across two database in the same Sql Server.

  select * into 
  from 
   
  Example:
  select * into Mydatabase2.dbo.employee_backup
  from mydatabase1.dbo.employee

  Any one of the following methods can be employed to copy a table into a destination database on a different SQL Server.

  1. Data Transformation Service (DTS) – SQL Server 2000.
  2. SQL Server Integration Service (SSIS) – SQL Server 2005
  3. SQL Server “Export Data” task. – SQL Server 2000/2005
  4. Create a linked Server of the destination SQL Server on the source SQL Server and then copy the table. – SQL Server 2000/ 2005.
  5. We can also use My code library (SQL Server T-SQL code samples, snippets, examples, tips, tricks, stored procedures, user defined functions, VB programs): Narayana Vyas Kondreddi's home page to generate data insertion scripts and then run the insert scripts.
  6. I almost forgot this 😉 you can open the source table , select the row(s), copy (ctrl + C) the row(s), open the destination table and then paste (ctrl + V) the row(s).