These queries are not the same. My gamble would be that you have duplicate recordid's in the cptrans_blacklist.

If you join with the table, the record from cptrans will be duplicated.

To...

If you want to have more than one date range linked to a single record, you can store the range in a separate table with a FK referencing the original...

There was an earlier post about this.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8528&FORUM_ID=5&CAT_ID=1&Topic_Title=Cross%20database%20permissions&Forum_Title=Administration

There should be ownership chains in SQL 2000 SP2 (maybe before that too). The problem in that situation was the fact that the dbo...

I know how these things grow, and I was just wondering if there are any issues with the DTS packages that made you choose this solution, to learn something more...

Triggers are definitely the way to go in my opinion.

If I'm not mistaken, the identity value is part of the inserted table, so that's no problem either.

To get the id...

As I see it, some of your choices are not the most straightforward ones. What was your argumentation for choosing this implementation?

Why you are using separate 'dummy' tasks to select...

If this is really a network error, maybe you can try connecting using another client library (e.g. named pipes). If this is possible with your configuration of course.

In the 'Notification' tab of an agent's properties, you can set options for logging (e.g. to the Event log).

Been working with Crystal reports 7 for some projects. Always got the job done, without too much hassle.

I think it's good value for the money (ever looked a licensing fees...

In your NOT IN subquery, you are comparing the values against the table you are inserting in.

The cursor (recordset) is built once, and you loop through the records. In the...

I don't think the solution from David solves this one. It will work, if you never have more than two records that need to be merged. It also won't take...

I believe the proposed price $15.00 is OK. Beats the price of most other books on the subject .

Have to agree with SQLBill on the typos. They...

Dificult one without some additional information.

First of all, do you have a 'parameter' in your select statements WHERE clause, and does that work without problems?

When you are updating, inserting or...

There is an ActiveX called PivotChart / PivotTable that allows easy connection to Analysis Services. (I guess this is what Nico Verbaenen is talking about.)

If I'm not mistaking, there is...

I think this might help you on your way, maybe there is some special data this query does not handle properly.

SELECT T.region, 

   ...