You are almost certainly dealing with INTEGER arithmatic. The data fields you are referring to are most likely INTEGER fields. When arithmatic is performed on two integers, an...

Ok, well I misunderstood but I think what I said still applies...

In order to modify extended properties, you need ALTER or CONTROL permission on the table in question. Those...

If you're joining a non-indexed view against another non-indexed view, you're probably going to notice performance degredation. You'd probably be better off creating just one view that joins all...

Best practices dictates:

Use the EXECUTE AS clause in the stored procedure, and have it execute as a user with the proper permissions.

Create a role, and give it access to the...

The most obvious optimization would be to make sure Port_Timestamp is an index. Also, if the PortRecord table has more than the 3 fields you stated, you may want to...

I welcome any input you can offer. Here is the stored procedure in its entirety:

CREATE PROCEDURE [dbo].[VMFG_UPSPackageConfig]

@partlist NVARCHAR(MAX),

@debug INT = 0

AS

--------------------------------------------------------------------

-- Table Declarations

--------------------------------------------------------------------

DECLARE @items TABLE...

SELECT ... INTO will create a table based on the data retreived from the SELECT clause. I use it when generating log tables. It works the first time...

Thanks for all the information.

Based on the information presented, it looks like I'd have to jump through a lot of hoops (that I don't necessarily want to jump through) in...

Case Qty is the number of items that make a case. Pallet Qty is the number of cases that make a pallet.

At the point in the code where I...

The Kimball method is great (and it's probably what most of us use), but it's general purpose and system independant. SQL Server has been optimized to the point where...

You really don't need to turn you dates into integer "date ids". SQL Server is highly optimized to use dates as indexes. Internally, they're stored as integers anyways,...

timmy,

It's not just him, no one can help you solve your problem without enough information. That's just reality. As the owner of the problem, you may not know...

Length, Width and Height are the same for every distinct package type, but the data for that comes from somewhere else so I grab it all at once. Two...

From my experience I don't believe it is possible to insert a newline in a SQL email. I ran into this in the past. I just had to...

No, you can't restrict sysadmin access from anything. They are the sysadmin, and have to be able to maintain the entire database. Using a schema is just best...