Please help. How to create Detail table using Summary

lenygold via DBMonster.com

I have a following summary table:

DISP_ID CLAIM_TYPE ERROR_CODE FILE1_TOT FILE2_TOT
-------- ----------------------- ------------------------- -----------------
-- ---------------------
AA HUBC NOERR 379 410
AA HUBC 8018 118
127
AA HUBC 8019 226
235
AA HUBD 8022 15
22
.................................................. ............................
................
ER HUOP 9947 4
4
ER HUOP 51#L 5
5
.................................................. ............................
...............
UR HUBC NOERR 3066 3198
UR HUBC AAAA 144 144
UR HUBC BD01 12
17

I have to create(INSERT) 2 detail tables:

DISP_ID CLAIM_TYPE ERROR_CODE
AA HUBC 8018 <------ 379
ROWS IN TAB1, 410 IN TAB2
AA HUBC 8019 <------ 118
ROWS IN TAB1 , 127 IN TAB2
.................................................. ............................
.................................................. ....
.................................................. ............................
.................................................. ....
UR HUBC AAAA <------144 ROWS
IN TAB1, 144 IN TAB2
UR HUBC BD01 <------ 12
ROWS IN TAB1, 17 IN TAB2

Is this duable in one query or SP?
Need help. Thank's in advance.

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200803/1

Mar 22 '08 #1

Subscribe Post Reply

1034

Similar topics

I want to avoid using a cursor, please!

by: teddysnips | last post by:

Application is a Work Tracking/Timesheet database. The increments of work are stored in the TimesheetItem table. This contains, inter alia, the Work Code, the Start and the Duration that the...

Microsoft SQL Server

Review my architecture please

by: Patrick Allmond | last post by:

I have to write a rather small project quickly, and I am trying to keep every clean and OO. I am fairly new to .NET. I'd like your comments on my proposed solution. Request: Display a list of...

.NET Framework

Please help me read this code

by: Jayjay | last post by:

When it comes to access, I'm pretty good using the built in features and can come up with some pretty complex functions to get what I need. But we have this database I'm doing for work that is...

Microsoft Access / VBA

Forms authentication in a subfolder problem, please help

by: Kris van der Mast | last post by:

Hi, I've created a little site for my sports club. In the root folder there are pages that are viewable by every anonymous user but at a certain subfolder my administration pages should be...

ASP.NET

Help, please: Postback event not firing without ViewState

by: Lisa | last post by:

I have a web app that gets a recordset from the database and fills a grid. You can drilldown from this table to a detail table. Because the tables sometimes get huge, and because I have to go...

ASP.NET

crystal report 9.0 help please

by: RJN | last post by:

Hi, I'm new to crystal report and require a help urgently. My requirement is something like this. I have a main report from where I call 2 subreports, say summary and details. The main...

Visual Basic .NET

CSS/DIV layout help please

by: Mr Brown | last post by:

Hi, I have a div <div class="lrgBG">, followed by a footer div <div class="lrgFooter">. I have an image and a table in the lrgBG div, image is floating left and the table is floating right. the...

HTML / CSS

TextBox Readonly OnPaint wrong font! Please help!

by: H-S | last post by:

Please help. This is a real puzzler! Originally posted on microsoft.public.dotnet.framework.windowsforms but no answer found! I have a read-only textBox which shows the results of a selection...

C# / C Sharp

SQL Server error '80040e31': please help me!

by: Tonio Tanzi | last post by:

I have the following problem in a Win 2000 Server + SQL Server 2000 environment and I hope somewhat can help me to resolve it (after many days of useless attempts I am desperate). In my database...

Microsoft SQL Server

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware