Probabaly you may not want to use sp_ as prefix for you stored procedure as it is meant for the system stored procedures. I assume Monte just used it for...

Do you want to calculate difference between two days in terms of Years, Months and Days like difference between current date and '01/01/2000' or something of that sort?

SELECT TOP 5 * FROM dbo.Employee ORDER BY Salary_Col  DESC

If you know the value that you need to update you can directly use it in the update statement

CREATE PROCEDURE dbo.Upd_TableName

AS

BEGIN

UPDATE dbo.Table_Name

SET column_name = 'Prasad'

END

But it would be...

Well, as you must be aware there are several limitations with SQL Server 2005 Express as far the Reporting is concerned, however it should definitely work on your local instance....

I believe you should install SQL Server 2005 Express Edition with Advanced Services to enable Reporting Services, I am not sure if you are already doing that.

Looks like it is database connection configuration issue. Please check if you can find the required information at

http://msdn2.microsoft.com/en-us/library/ms156468.aspx

Thx

I am not sure of the access application but, it is always a good idea to use proper Locking options in your queries and stored procedures to avoid locking and...

Yes, it makes more sense to use the trim functions when you have the columns that allow even the character datatypes.

CREATE PROCEDURE dbo.Upd_TableName

@Value VARCHAR(50) --REPLACE WITH THE EXACT DATATYPE

AS

BEGIN

UPDATE dbo.Table_Name

SET column_name = @Value

END

I am not sure if I understood your question, but per my knowledge printer would take the default paper size configured on the mapped printer. And if your default setting...

As suggested by Jeff I believe per your post, you are looking at only a subset of your base data, and you anchor all your logic off of a Temp...

It really is interesting,

SELECT a, *

FROM a1

ORDER BY a1.a

GO

SELECT a, b

Infact you don't really need a brace

CREATE VIEW InventoryPublisherView AS

SELECT * FROM

Based on your posting

CREATE VIEW InventoryPublisherView AS

(

SELECT * FROM dbo.Inventory...