I agree. I would script the job onto development. If successful, then script to production. There are a number of stored procedures that must be used to...

You can use a join statement in a delete, and in this case this statement would have done the trick:

DELETE FROM ol

FROM Orders o

JOIN OrderLines ol

ON...

quote:

---

FROM Precertification INNER JOIN

PrecertificationDiagnosis ON Precertification.idsPrecertification = PrecertificationDiagnosis.idsPrecertification INNER JOIN

PrecertificationService ON Precertification.idsPrecertification = PrecertificationService.idsPrecertification INNER JOIN

CommentsPrecertification ON Precertification.idsPrecertification = CommentsPrecertification.PrecertificationIdx

---

Es gefaellt mir, dass die Erklaering Ihnen Hilfreich war.

Ich habe Deutsch seit neun Jahre in der Schule gelernt. Zwei Woche lang als ich funfzehn war, habe ich mit einer...

Weil Sie aus Deuschland sind, denke ich, dass Sie Deutsch koennen ("oe" bedeuted ein "o" mit einem umlaut).

If you don't understand German, please go to the paragraphs below.

Das Woert "cute"...

We always use RI. I can't imagine not using it.

We have a third-party application that doesn't use it. We have a lot of problems with it from performance...

By the book you do have to detach the databases to be able to reattach them, but so far I have always been able to attach a database even if...

By rebuilding the master, you can set the appropriate permissions to allow you to attach the databases. Unfortunately you will also need to recreate anything else stored in the...

Yes, you can delete NT Authentication logins that have been deleted from the domain, because even if they were recreated in the domain, they would have different spid and so...

Thanks Rita,

I checked another thread and have found that just because I couldn't restore master doesn't mean the same limitation applies to user databases.

I'll be trying to attach the master...

Andy,

It could be that I did something wrong in the test, but when I completed the install without doing the uninstall, upon completion the Query Analyzer interface looked like the...

Not sure what you mean by new client tools. I am going to upgrade client machines, but am only testing server upgrades at the moment.

I have never done an...

If you are not changing the structure a Full Process is more than you need to do. A Refresh will get you the same result and will have less...

I'm curious to know the latency of your cube data. Does it need to be updated immediately.

I have a similar situation with one of my cubes. Every night...

This also seems to work:

SET @DateTime=DATEDIFF(DAY, 0, @DateTime)

This eliminates the CONVERT function.