We can help... just not enough information in you post to help... Please see, read, understand, and use the methods for posting found in the URL listed in my signature.

Google sp_MSForEachDB.

Where do you get the Actual Row Count you're talking about from?

Yeaup... Segiy is absolutely correct... never load directly into the final table. Always use a staging table.

So far as the fixed field format you're talking about... yeah, you can...

Why are you retreiving 1,000's of rows into an application? What is it that your'e actually trying to do with all that information? This isn't a challenge... I...

How will you identify which month you want?

Grant Fritchey (6/19/2008)

---

Actually, quite a few of us get paid to rewrite 500 line stored procedures. We'll help, but you need to do most of the heavy lifting...

You create a...

You can do that... but a lot of such things will come up in the future. I recommend that you create a Tally table and learn how to use...

What are you? Skilled with a lot of intellectual curiosity and the propensity to be much more, I'd say.

I think you should pick whatever title you like. Application/Systems...

It depends... we don't really know enough about what you're trying to do to tell you whether you're headed in the right direction or not...

If you're looking at it in the grid mode, then it will look as if the CrLf's are blanks... try looking at it in the text mode.

Yeah... I'm afraid I'm a bit guilty there, as well.

elmerbotha... Chris Morris (posted above) thought that you might have more than 1 data point for each UoM for each Metal......

Let us know how the tests work out... even if it's just confirmation but especially if you find something new or different. 🙂

rbarryyoung (6/20/2008)

---

Try this:

SELECT Metal, min(Result), max(Result), count(Result), stdev(Result)

FROM Metals

GROUP BY Metal

By the way, stdev() is the statistical standard deviation, if you want the standard deviation for a population...

Grant Fritchey (4/6/2005)

---

Naming standards are very good things. Common abbreviations are very good things.

Very good things can, however,be taken to silly extremes. We've got a logical modeling team tasked with,...