The simplest way is to record a credit as a negative "payment" amount. If your need for credits is fairly simple, that's a good way to go. It's...

Did you actually change anything in the structure from the last time you posted this?

Repeated ideas from last time:

Remove customerName, and put it in the Customer table.

Move creditCardName to the...

Grr. That's a result of combining my methods and brij's.

Remove the SET @VDNList = '' statement from your function. That should mean that the variable is initialized as...

Put your concatenation process in a UDF, passing whatever value you're grouping on. So, in your case, it might look like:

CREATE FUNCTION ConcatVDN (@type varchar(30), @center varchar(50))

RETURNS varchar(4000)

AS

DECLARE @VDNLIST...

Huh. I didn't think it would actually evaluate that. Well, there's proof that stripping semicolons is not sufficient protection.

In your procedure, you would put something like:

IF CHARINDEX(';',@formula) 0 THEN

BEGIN

-- raise error indicating possible injection

END

ELSE

BEGIN

-- put your EXEC statement here

END

Since a semicolon is not a character...

You are giving anonymous users read and write access to a folder on your website. Which means that they can see whatever files you put up there. And...

Yup, that pretty much ought to work.

As a critical note, this method opens you up to a problem known as SQL injection. That's when a hacker is able to...

The biggest thing to hit them with is that you already own the SQL Server. That's like insisting on leaving your pickup in the garage while you try to...

Security is a major concern. Security in Access is essentially non-existent. There is no way to secure Access against a dedicated, knowledgeable hacker. It's pretty difficult to...

Try EXEC. Except that you have to put SELECT in front of the expression. For example:

EXEC('SELECT 10 + 20')

Will yield 30.

Note that this method gives poor performance if...

If redesign is an option, I would strongly recommend it. This sort of information should be drawn from an Orders table with a GROUP BY query, not stored in...

I strongly recommend that you create this with the cross-tab functionality built into Crystal Reports. It is simpler, more powerful, and more intuitive.

Just in case your boss needs more than one opinion, I'm going to agree with Mike. This seems like, honestly, the worst possible solution. Why can't the webmonkeys...

Identity values are meaningless. They serve solely to produce an artificial primary key. They should not have any relation to real-world values, unless you don't mind having, say,...