In MS SQL Server 2000, you can get a cartesian product simply like this

[font="Courier New"][font="Arial"]create table TableA...

I did not even bother to try...

Pressed "Post Reply" too quickly. Forgot to add this:

I have also used the approach of comma-separated single parameter but it has limitations:

- the is a practical limit to the length...

Mr. Moden,

I was talking about a GUI. Working off a DevExpress grid in Delphi, the user can multi-select several lines. It is then a simple matter of looping through the...

Steve Jones - Editor (4/1/2008)

---

1...2...3...4... enough recounting.

I'll add points back to the True's later :). The system doesn't allow "either or" answers. If I ticked both, both would be required.

Happy...

Er, is the question addressed to "Rags" or to "J" ?

Another suggestion: Enter in a working table the list of your productid's.

Example:

CREATE TABLE myTempSelectionList

. (

. pk INT NOT NULL PRIMARY KEY bigint,

....

Let me get this straight:

You divide two integers and expect a decimal result ?

The previous suggestion:

[font="Courier New"]. select (convert(decimal(2,1),3)/convert(decimal(2,1),4))[/font]

does produce what you need:

[font="Courier New"].750000[/font]

So I am not...

After falling for the Featured article "The New SQL OS", I fully expected that the Question of the Day, in the same e-mail and given its obviously preposterous nature would...

Hmmm

I vaguely remember the furor about VB "dot Nyet" invalidating all code written in previous VB versions...

Walking up to Frankenstein's castle with torches and pitchforks ...

In the trivial statement, I also got the answer right without testing or reading BOL.

However, even without bit operators, I have had cases where the statement was more complicated than...

My thoghts exactly.

FOURTH normal form? I know what it is but is it REALLY used in the real world (performance issues).

Comments invited.

You could also calculate ONCE the "10 +" dates -- when crreating the record.

True, you would need an additional column (AARG! Thrid Normal Form Violation ! do NOT add...

Implied vs Explicit

I prefer to use parenthesis to clearly express the precedence. This saves me from having to mentally reestablish the precedence every time I read my own code. Also,...

I hope you do not intend to store BC dates in SQL Server 2000.

In SQL Server 2000, the allowable range for the datetime type is from January 1, 1753 through...