Viewing 15 posts - 2,371 through 2,385 (of 2,452 total)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 1:04 pm
SELECT yourtable.name, Sum(yourtable.amount) As total
FROM yourtable
GROUP BY yourtable.name
hope this helps
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 12:50 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 9:59 am
frecal (8/15/2009)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 1:53 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 12:58 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 11:38 pm
Marios Philippopoulos (8/14/2009)
gah (8/14/2009)
what response times do you get if you use OPENQUERY against the LinkedServer?are you filtering on any records in the source table?
Thanks for the suggestion, actually this...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 3:48 pm
what response times do you get if you use OPENQUERY against the LinkedServer?
are you filtering on any records in the source table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 2:21 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 1:32 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 1:16 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 1:00 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 12:26 pm
Plase excuse my ignorance, but how much is a "crore"?
does one "crore" represent ten million (10,000,000) ?
gah
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 11:11 am
try this
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 9:21 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2009 at 7:56 am
Viewing 15 posts - 2,371 through 2,385 (of 2,452 total)