Nice question. Thanks.

Your result is ordered by k. It really doesn't matter what in order you load the table, you order it on the select out, or use a clustered index.

I have'nt had to think about bitwise operations since the mid '80s so my brain is mushy now. But the modulo gave it away.

Thanks for the question.

http://www.amazon.com/Server-2005-Replication-Definitive-Guide/dp/1590596501/ref=sr_1_1?ie=UTF8&s=books&qid=1277035827&sr=1-1-spell

This book I find to be very thourough. It is quite detailed. It is a great reference if you're setting up or administering replication and has...

July is Lasagna Awareness Month ?? OMG!!! I've been celebrating it all wrong.

😀

Great question. Confirmed what I already knew. Point collected.

Use a query.

INSERT INTO TABLE_Z

SELECT col1, col2, col_x

WHERE col_y BETWEEN DATEDIFF(dd,GETDATE(),-7) AND GETDATE()

It seems you are resistant to junction tables, so try it without them in a dev environment and see if it works for you.

There is no law that says you...

Is there a Human Resources dept? I so, you should schedule a discussion with a HR rep to discuss some concerns and to ask questions about review policy.

http://msdn.microsoft.com/en-us/library/ms190397.aspx

A single column will always be faster than multiple columns. It's quantity of data down a fixed pipe.

I think too many (myself included) are looking for trick questions. Nice simple question today. Thank you for that.

Investors often require all employees to sign NDAs. Your company may replace anyone refusing to sign with someone who will. 😉

Even though I received 3 points in this question, it leaves a bad taste in my mount. I still had to guess (correctly) that the intent of the author...

It is considered poor practice to use "select *" for anything but simple, temporary queries.

The good new is that it's easy to make SQL write your queries for you. ...