Why are you storing this data twice? Store it *once* (in the orders) and create a view that aggregates it.

Anyway, here's the query you asked for:

SELECT Item.*

FROM Item

WHERE TOTAL_VAL...

I would always handle this with a calendar table, personally. There's a lot more than just holiday dates you can include: Comments on what the holiday is (or...

Updated version of the UDF posted here:

http://sqljunkies.com/WebLog/amachanic/articles/PatternReplace.aspx

Thanks again for the input, Frank!

Comic sans?? Hmm, that's a bit suspicious!

Anyway, give Profont a try and tell me what you think. I tried it after a friend recommended it, didn't really like...

You touched on fonts, but not on WHAT font to use...

I *highly* recommend everyone download and install a copy of ProFont:

http://www.tobias-jung.de/seekingprofont/

I am using the "tweaked" version, I believe. ...

Here are more test cases... Turns out this thing (my version) is a mess!

SELECT dbo.PatternReplace(NULL, '', 'abc')

SELECT REPLACE(NULL, '', 'abc')

SELECT dbo.PatternReplace('abc', '', NULL)

SELECT REPLACE('abc', '', NULL)

SELECT dbo.PatternReplace('abc', NULL, '')

SELECT...

Frank,

I'm not a big fan of that modification, generally-speaking, as it differs from the functionality provided by the REPLACE function itself...

Observe:

SELECT dbo.PatternReplace('abc', '', NULL)

SELECT REPLACE('abc', '', NULL)

Both of these...

I'll take this opportunity to promote my own generic, pattern-based replacement UDF for your consumption:

http://sqljunkies.com/WebLog/amachanic/articles/PatternReplace.aspx

Enjoy!

MySQL is not free for any kind of commercial use.

That's the biggest misconception out there about it (other than people thinking that it's actually any good

And also, the licenses for both PostgreSQL and Firebird are a lot more leniant than MySQL -- you can get a good product GPL licensed, or you can pay for...

Quote:

--

The fullness of the index pages can be determined by reading the "Avg. Bytes free per page" and "Avg. Page density (full)" statistics. The "Avg. Bytes free per page" figure...

The correct answer to this question is: It depends on how the client tool formats the output. Floating-point numbers, like dates, are at the discretion of the client...

Hmmm!!!

That should read, "0 row(s) affected" !!!

What kind of "geek" made up that shirt?!?

Minor bugfix needed! I found cases where the id would sometimes start at 2 in the outer query.... And I've never heard of ThinkGeek before but I'll check...

Oh, come on, it's so easy to generate this stuff...

Just put QA into "Results in Text" mode and....

---

set nocount on

declare @string varchar(200)

set @string = 'yes, maybe I do have too...