Re: How to synch up values from multiple tables into a single row

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 11:07:00 +0200

On Sun, 26 Sep 2004 14:43:02 -0700, kfrost wrote:

>I have a database that users enter in their the job name's and locations of
>projects they are working on. THey enter in revenue and expenses on the job
>until finished.
(snip)

Hi kfrost,

I'm sorry, but your explanation is insufficient to understand what your
problem is. The best way to get help in these newsgroups is to post
detailed information in a form that is as much fit for copying and pasting
as possible. So, please post the following:

1. The structure of your tables, as DDL (CREATE TABLE statements). Columns
that are irrelevant should be excluded, but do include all keys and other
constraints. See http://www.aspfaq.com/etiquette.asp?id=5006.

2. Some sample data, as INSERT statements. Before posting, create an empty
test database, run your CREATE TABLE and INSERT statements against it and
correct all errors. See http://vyaskn.tripod.com/code.htm#inserts.

3. The expected output, based on the sample data provided. If you provide
this utput in tabular format, use a non-proportional font and use spaces
instead of tab characters to ensure that everyone can see it the way you
intended it.

4. If applicable: any SQL code you are already using, the output you are
getting from it (if it's an error message: don't paraphrase but use copy
and paste and don't leave anything out) and the reason why you are not
satisfied with this code.

5. A short and concise description of the business problem you're trying
to solve. Don't expect us to be familiar with your field of work, as we
probably aren't.

If you follow the above guidelines, you have a much better chance of
receiving useful answers!

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: Extremely complicated problem :(
    ... >their associated charges, payments and adjustments + the payer name ... If you do want help writing the query, ... Sample data that is illustrative of your problem. ... Expected output, based on the sample data given; ...
    (microsoft.public.sqlserver.programming)
  • Re: Order By - Conditional
    ... I must reproduce your situation on my system. ... Enough sample data to show what you want to achieve, ... are getting from it - if it's an error message, ... A short and concise description of the business problem you're trying ...
    (microsoft.public.sqlserver.mseq)
  • Re: UDF and SQL2000 - Why doesnt this work?
    ... Basically This is what I want to do - I have created a query ... as DDL (i.e. CREATE TABLE statements; ... Sample data that illustrates the problem, ... Expected output from the sample data supplied; ...
    (microsoft.public.sqlserver.programming)
  • Re: Please Help with SQL Query Problem
    ... Since you did not post any sample data, ... it - make yourself a favour and post the error message next time. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Calculation problem
    ... >However, for some reason, I am coming up with some wacky values when I try ... Expected output from the sample data. ...
    (microsoft.public.sqlserver.server)