Loading ...
Sorry, an error occurred while loading the content.
 

RE: [SQLQueriesNoCode]

Expand Messages
  • Necdet Çetinkaya
    Hi Again In addition I forget Add the error message My Sql Sentence retun this error message Like this Insert Error: Column name or number of supplied
    Message 1 of 3 , Jul 27, 2004
      Message

      Hi Again

      In addition

      I forget Add the error message   My Sql Sentence  retun this error message

      Like this

      Insert Error: Column name or number of supplied values does not match table definition.

       

      I know compute by return different recordsets. How can I  Concanete this results ?

       

       

       

       

      Necdet Çetinkaya

      Genotıp Hasta Bilgi Sistemleri

      necdet@...

       

      -----Original Message-----
      From: John Warner [mailto:john@...]
      Sent: Tuesday, July 27, 2004 3:42 PM
      To: SQLQueriesNoCode@yahoogroups.com
      Subject: RE: [SQLQueriesNoCode]

       

      Is there a question here?

       

       

      John Warner
      mailto:john@...

      -----Original Message-----
      From: Necdet Çetinkaya [mailto:necdet@...]
      Sent: Tuesday, July 27, 2004 5:36 AM
      To: transact-sql@yahoogroups.com; SQL_beginners@yahoogroups. com; sqlknowledge@yahoogroups.com; SQLQueriesNoCode@yahoogroups.com
      Subject: [SQLQueriesNoCode]

      Hi Everybody

      I have got a problem  I want to make a recordset like this

       

      Orderno         Code     Description        Quantity 

      1                   s.01      pencil               10

      2                   s.01      pencil               5

                                                              15

      1                   s.02      blackboard        3

      4                   s.02      blackboard        5

                                                              8

                                                              23

       

      I use  compute and compute by 

       

      CREATE TABLE #TEMP

      OrderNo                    VARCHAR(100) NULL,

      Code                         VARCHAR(100) NULL,

      Descrip          VARCHAR(100) NULL,

      Quantity         VARCHAR(100) NULL

      )

      INSERT INTO #TEMP  

      select OrderNo, Code, Descrip, Quantity  FROM StockInputOutput 

      WHERE OrderNo < 40 

      ORDER BY  Code 

      COMPUTE COUNT (OrderNo), COUNT(Code),COUNT(Descrip),SUM(Quantity)

      COMPUTE COUNT(OrderNo),COUNT(Code) ,COUNT(Descrip),SUM(Quantity) BY   Code 

       

       

       

       

      SELECT * FROM #TEMP

      DROP TABLE #TEMP

       

       

       

      Necdet Çetinkaya

      Genotıp Hasta Bilgi Sistemleri

      necdet@...

       




    Your message has been successfully submitted and would be delivered to recipients shortly.