I know how to do that in SSIS and in T-SQL, but not in DTS. Maybe try the SQL 2000 Forums on this page. You might have more...

I don't believe you can update those directly in the system tables. Haven't tried, but I'll be shocked if you can do it.

What you might be able to do...

As far as replication set-up goes, I haven't done it enough to have a strong opinion one way or the other.

My point was merely that "rolling your own" on an...

Michael Earl (6/3/2008)

---

I agree with much of that, but this is a case of consolidating business units, not data from several companies (according to the original post). So, the...

Gotta agree with Michael on this one. Gaps in identity don't matter, and that's a good thing.

Michael Earl (6/2/2008)

---

If this is a total re-design, why wouldn't you just create a single database that included composite keys in the tables - one of the key fields indicating...

I've seen this before, but it's been a few years. It may have to do with the missing primary key.

What that error means is that the primary key of the table is part of the key for the partition. That means it's not a permissions issue. First,...

I'm assuming you mean the avg for either online or student. If that's correct, it would be something like:

case

when avg(online) > 0 then avg(online)

else...

TheSQLGuru (6/3/2008)

---

I would use SET STATISTICS IO ON and execute in SSMS. Also use profiler to get good IO metrics as well as CPU, duration, rowcounts. Use the...

I would use Profiler to gather the relevant information.

Jeff Moden (6/2/2008)

---

Grant Fritchey (6/2/2008)

---

Really, never?

I find the percentage of the batch to be a pretty useful guide most of the time. Not all of the time, no, but more...

swekik (5/29/2008)

---

Hi Guys,Im getting tis error for this,whats wrong in this ?can anybody suggest me?

I am doing UPDATE #temp SET

Fname = LEFT(Logins, CHARINDEX(',',...

It looks like this same question ended up in three threads in this forum. As with all the rest, try this:

;with LastEntry (N, D) as

(select name, max(date)

from dbo.entries

group by...

Try this:

;with LastEntry (N, D) as

(select name, max(date)

from dbo.entries

group by name)

Select E.Number, E.Name, E.Date, M.Text1

From Entries As E

Inner Join Main As M

On E.Number = M.Number

Inner Join LastEntry

on E.Name...