Apparently I've misunderstood you. Will dig into this...

Have a look at CROSS JOIN in BOL. If I understand you correct that should give you what you need.

Can it be you're looking for a CASE expresssion?

Before reinventing the wheel have a look in BOL at "CREATE FUNCTION". You'll find a UDF to calculate ISO weeks.

Well, at least Windows has a little bit more air to breathe.

Take a look at the link, alzdba gave above. You will get some ideas how to achieve your result. But please, read it carefully and then decide if you want...

I think you really should give a bit more information of what you really try to achieve. Try using pseudocode to explain it.

If I would do this, I'd use MAX() instead od TOP.

However, I wouldn't do this. SQL Server is not Access. Consider two users inserting data. One started a little...

John, will your homepage be online soon?

Now the discussion of whether or not to store BLOB in a database comes into play. You might want to read http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx on this. And again I really think this...

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

1. No, IMHO not any value

2. No, not really.

3. No, why should they?

4. This is very detailed in BOL. Please read this first and ask when you don't understand something...

Hehe, after finding out what "glossy" means, no!

Sorry, but if I have the choice, I actually prefer some other kind of glossy photos