No. The only way to move a SQL Server 2000 database to a SQL Server 7.0 server is by using Data Transformation Services (DTS).

--Jonathan

Sure, just add a reference to ADO ("Microsoft ActiveX Data Object 2.x Library") and you're set. If you don't know ADO, then you'll need to learn it, though.

I agree with stax68--unless misuk11 provides more information, we'll never know. There is nothing inherently wrong with the query as written, so we cannot know what the problem is without...

SQL Server will sequester memory as needed and not relinquish it unless the OS attempts to allocate memory to other applications, so you best use the dynamic setting.

If you fix...

Use a CASE expression.

SET Col2 = CASE Col1 WHEN 1 THEN SomeValue ELSE OtherValue END

--Jonathan

quote:

---

is there a better way to do this ?

---

Replication?

--Jonathan

If you set your recovery model to Simple or Bulk-Logged in SQL Server 2000 (or set the "select into/bulkcopy" option to True in previous versions), then any inserts done with...

quote:

---

Thanks for the idea. I definitely concur with limiting the return and was looking for proven ways of accomplishing this. ...

quote:

---

I see that this method requires as many left outer joins as the max number of records that a single...

quote:

---

I personnaly don't like that kind of programing behavior in a client/server environment.

That one fits well on a standalone database/application of Clipper/ACCESS......

quote:

---

SELECTa.fk,a.dat+ISNULL(', '+b.dat,'')+ISNULL(', '+c.dat,'') as combined_dat 

FROM(SELECT fk,MIN(pk) as pk FROM tablea GROUP BY fk) x 

LEFT OUTER JOIN...

Don't mean to be harsh, but you're evidently already working beyond your RDBMS knowledge by creating that schema. If you want to do this calculation on the server side, you've...

quote:

---

count(i.invoice_date) eliminates all NULL values in the field i.invoice_date, that is, all days without invoices. Try count(*) instead, that should help.