-- create a stored procedure which:

-- reads & normalizes your data

-- by (create table date, name, value)

-- then...

-- be sure a DateTime field name is in your table

-- be sure the DateTime field name is indexed

-- Begin complex SQL...

Get both your query output and return success with @@error as a parameter output:

SET

QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

CREATE...

Your Solution:

UPDATE

@tblvarClose

  SET Close0PctCnt = COUNT(Quote.quote_num),

    Close0PctGP

Could be like this:

UPDATE

@tblvarClose

SET Close0PctCnt = qCnt,

Close0PctGP...

Please correct me if I'm wrong, but your XML is data specific...

Can you reduce the total record count on XML document, thus reducing your memory requirements? Making XML pages instead...

Darian:

The comments you received, did not come from novice DBA's!

Unless you are considering hiring a DBA, I would suggest hiring a consultant!

Yes, that would be preferred...

By the way, doesn't access create a type_table for you by using this process? Use access in design mode to see this, plus new code created...

Those who know little speak it the loudest!

If I felt someone was ready for combining all their type fields into one table, I would have suggested it.

Great! You can do this:

Create a deployment.asp page for your developer, where he maintains his dsn on test for creating and maintaining your reports, then runs the deployment.asp from your...

Normalize your data, maintain good indexes, and your limitations are going to be within your hardware, backups, number of cpu's, and your available memory.

Beyond those problems, compare Oracle, MySQL,  Informix, MSSQL & what see...

This is perfect example for normalizing data...

You say you have data described "hard coded in your application as a drop-down list"?

Please create a "type" table for your column (example):

CREATE

...

Without knowing the answers to the last post yet, I can still tell your going to need a front end form which will ask the developer for the database required...

Is this text formated for parsing out fields?

If so, use convert or cast for each field type.

ISDATE and other functions can be found at microsoft.com (developers SQL manual)

But you are using objects to access your database...

Please...