David ...thanks for the procedure code ...could you also please post some DDL, sample data and expected results

This will probably help you in getting quicker and tested replies

as per this...

SELECT yourtable.name, Sum(yourtable.amount) As total

FROM yourtable

GROUP BY yourtable.name

hope this helps

Hi... I may well have misunderstood what you are attempting..it wouldn't be the first time ....;-)

Not knowing how many more colums you have in your table or how many rows...

frecal (8/15/2009)

---

Fair enough

let me see if i can translate to my the business process.

Just one thing...and i think i need to get my head around it...a few of the different...

Hey Fred...suggest you post your code here, that's the idea of of having a forum.

plus it allows others, more experienced than I, to also help you.

look forward to seeing your...

Fred

suggest you post some sample tables and data (in the same format as my first reply) ...we can then build on that.

I think this will save any possible confusion later...

Marios Philippopoulos (8/14/2009)

---

Thanks for the suggestion, actually this...

what response times do you get if you use OPENQUERY against the LinkedServer?

are you filtering on any records in the source table?

Hi..maybe I have misunderstood your question....but you ask that "want products ordered by category-wise "

from the table designs that you have provided I cannot see where " category" is defined?

Could...

Hi Seth...I think the answer is "it all depends"...apologies for the cliche

How many individual assets are you going to have?

Having recorded all the info against each asset, how do you/users...

Dear jrw

MS give the impression that upgrading from Access to SQL is a walk in the park...well it can be if all you wish to do is migrate some data...

Dear JRW

Did you look at this?...I posted this today in response to another question you raised in a different thread...this outlines MANY of the differences between Access and SQL syntax

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html...

Plase excuse my ignorance, but how much is a "crore"?

does one "crore" represent ten million (10,000,000) ?

gah

try this

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

Hi Fred

try the following code...it will create 4 tables, insert a small amount of data and run a couple of queries.....hope it helps with your thinking.

if you know in advance...