You are here:
From general queries about SQL Severs both 2000 and 2005 to advanced features like Integration Services and Reporting Services.
Experience in the area: I have been working with database triggers, stored procedures, views, function, joins, dts, Query optimization. Education/Credentials: BE IT - 2005 Batch with First Class.
http://jnsoneji.blogpost.com
BE IT, India
MCP
Its changing everyday and so one can get many things to learn.
Data warehousing.
The pronunciation of the word "SQL" is sequel or S Q L, which is more official?, as Microsoft it self sometimes say sequel, is still a mystery for me.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| John | 03/14/12 | 10 | 10 | 10 | |
| John | 03/14/12 | 10 | 10 | 10 | |
| Mike | 03/13/12 | 10 | 10 | 10 | |
| John | 03/13/12 | 10 | 10 | 10 | |
| Dmitriy | 08/29/11 | 10 | 10 | 10 |
Dear Betsy, Thanks for coming back! Yes, you can link an access file to SQL Server and it will not slowdown. The link given in the previous reply has the same information of linking an access file
Hi Betsy, It can be tricky to control performance of the combined database usage as per your requirement. Could you please suggest what syntax are you using to fetch data from MS Access? Also
Hi Richard, Apologies for late reply... Well, there will be some good SQL clauses which you can use to roll-up, though as a simple way, the query below might help. Let me know.. #################
Dear Rakesh, It seems that you want only 4 records out of whichever has price=2000. So, if there are 10 records which has price=2000, you want to get only 4 records from those; correct? In that
Dear Rakesh, I think you mean that total 15 records have price more (or less) than 2000. It should be a fairly simple query using WHERE clause by putting all filter criteria in it. Like---
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.