Yes, if you need information to flow both ways and you are using SQL Server 2005, I'll agree with most of the other people here and say merge replication is...

eyejay (9/4/2008)

---

Sadly, even with your code edited I still get the error message that more than 1 value is returned by the query. I'm not smart enough to figure that...

I think something like this will work for you:

select

pat_nr,

abpm,

date_time

from

a_mon a

where

date_time >= (select date_time from a_ereig e1 where er_m_nr = 100 and a.pat_nr = e1.pat_nr)

AND...

This was one of the best questions with the best explanation I have seen out there.

IT does seem slightly dated now that 2008 is out though. In 2008 it...

Rod at work (9/2/2008)

---

In a previous post I asked about replication between and old production server and a new production server. We're going to go ahead with replication between...

sql_er (8/25/2008)

---

Thanks for all the suggestions.

I was able to fix the problem without adding an index, but just re-writing the query.

It was strange how a very simple change in the...

Awesome article that covers some of the lesser considered aspects of temporary tables and table variables. Thank you.

keppro (8/30/2008)

---

Thanks a lot to the author!

One problem with the script: it doesn't recognize indexes with included fields. Does anybody know what system table(s) contain this information? Better yet, is...

This article was really well written for what was there, but I was disappointed that it did not get into at least a little bit more depth on things like...

Normally SQL will do nothing if you attempt to kill a process that is being rolled back. It will simply display a message that it is already being rolled...

A database is more than just a data file, but it is not...

I'm inclined to agree with Ben. It does depend on how you define the terms, but I generally do not think of ldf as a database file.

It...

I couldn't agree with you more. Cheating is always disgusting.

mlarson (8/22/2008)

---

Thanks for the advice. Just to clarify a little bit, I do have a few projects that I would like to work on, but my main concern right...

I know there are many who disagree with me, but for me it helps to have a goal to focus on. That goal will give you something to focus...