Sanju (10/17/2007)

---

forgot to mention the columns in the currency rate table are rate_01, rate_02 till rate_12...

There is no column which identifies period in the table..so I need to check if...

Andras Belokosztolszki (10/19/2007)

---

Writing binary data, especially if you want to write out to several files, several objects, ... to disk is a bit of a pain. Your best bet would...

Actually, just had cause to revisit this particular thread...

... and it just dawned on me that tests in the article are not measuring the performance of each method... the tests...

Yvan Bouchard (10/19/2007)

---

Hi everyone,

I am looking for a course that will talk about only the modeling part of the database, starting from gathering the requirements, listing the entities-attributes and then...

If you only want them to connect via VNC, then you're in tough shape.

If you want to use it like a Server, then you need to setup users and have...

Whatever you end up doing, everything in the select list (including long winded formulas) that isn't contained in an aggragate funtion, MUST BE INCLUDED IN THE GROUP BY CLAUSE. 😉

:blink::ermm::Whistling: The constant is also a LITERAL in this case... it's not like they're selecting it or anything... the view is simple...

create view dbo.view1 as

select * from table1 t1 inner...

You could at least say that you copied all of that from Books Online so the other guy can help himself in the future 😀

C'mon folks... What makes you think that SET DATEFIRST is going to change the NAME of the day... TUESDAY is TUESDAY no matter what SET DATEFIRST is set to.

I'm a...

"IT"? What is "IT"? Jason's code?

Not sure what you're trying to do, but here's a different angle... think of it as a "set-based IF" 😀

SELECT TOP 1

CASE...

GUI code (Like VB, etc) and SQL have different base dates and one may not have recognized the year 2000 as a leap year.

I agree... way to much "big brother" already...

Shoot, I'm still ticked off about having Fluoride, ABS, airbags, seatbelts, lid laws, the fact that my truck records the last 5...

Although I got the answer right, it's kind of misleading... if the value of a column has been updated to the same value (usually do to bad GUI code), do...

First of all... I'm not going to solve all your problems with all your temp tables, etc, etc... You've already done most of that. My purpose here is just...