If you use up all the bigints, that would mean you have about 18 quintillion records in your table.  Just a simple table scan would take over a million years.  I can't...

Given that the largest group of corporate investors is retirement funds, maximizing profits is socially responsible.  People work hard and sacrifice to be able to invest money in their retirement;...

OK, I'll do that.  Thanks for the help!!!

I'm not sure what you mean by documenting it.  I found the solution here:  http://www.tek-tips.com/viewthread.cfm?qid=1306991&page=6

Here's another solution I just found:

SELECT A.x, B.y

FROM A LEFT JOIN B ON 1 = 1

Is there a downside to putting '1 = 1' in an ON clause?

Thanks!  Those both worked.  Dave's seems simpler so I'll probably go with that one.

CREATE TABLE A (x bigint)

CREATE TABLE B (y bigint)

INSERT A SELECT 1 UNION SELECT 2 UNION SELECT 3

(Leave Table B empty)

Desired output:

x     y

1     NULL

2     NULL

3     NULL

INSERT B SELECT 5 UNION...

I finally got this to work with a constraint/UDF combo, but for some weird reason it doesn't work on Updates using Enterprise manager.  With Query Analyzer the Update is constrained...

I thought about that, and I know it would work, but something in me rebels at the idea of using triggers for constraint purposes.  I'd like to use a check...

Instead of using a view, why not just query the tables directly?  You're doing a query anyway.

No way you can do that in a view.  When you query a view, you're querying static information just like querying a table; you can't calculate average on the fly...

How are you going to get the dates in at all without variables or hard coding?