Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL 2008 R2 to Excel

Posted on 2013-01-28
2
Medium Priority
?
368 Views
Last Modified: 2013-02-22
I have a table in SQl 2008R2 like the following:

USE [IEOPC]
GO

/****** Object:  Table [dbo].[INSPECTION_v2]    Script Date: 01/28/2013 07:50:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[INSPECTION_v2](
      [DATE] [date] NULL,
      [APPLICANT] [varchar](max) NULL,
      [LOCATION] [varchar](max) NULL,
      [REMARKS] [varchar](max) NULL,
      [QUANTITY] [numeric](18, 0) NULL,
      [COUNT] [numeric](18, 0) NULL,
      [CONTAINER] [varchar](max) NULL,
      [GRADE] [varchar](50) NULL,
      [CERTIFICATE NUMBER] [numeric](18, 0) NULL,
      [CAR NUMBER] [numeric](18, 0) NULL,
      [QUANTITY THOUSAND WEIGHT]  AS ([QUANTITY]*[COUNT]),
      [TIME INSPECTION BEGUN] [time](0) NULL,
      [TIME INSPECTION COMPLETED] [time](0) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

And data like the attached spread sheet.

The tab called database is the data that populates the table mentioned above.

I need to be able to input a date range in the tab called Input and then have the tab called LIGP and EOPC add the certificates associated with their company names together for each day in the date range and add them to the correct columns in the tab.

For example:

You will see that LIGP has 12 line items for 10-1-2012 from certificate 73496 totaling 744,372.

I would need all the certificates for 10-1-2012 added together and put the date, Certificate and weight in the appropriate columns.  Also the weight column needs to be divided by 100 as the weight column is hundred weight.

This would need to be done for each certificate and each applicant in the provided date range.

Where would I start with this??

Thanks!!
0
Comment
Question by:HDM
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 38827889
0
 

Author Comment

by:HDM
ID: 38828789
I know how to export the data to excel.

What I dont know is how to set the "Date Range tab" so the query will reflect the date I type in the space there.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question