That's a strange shift...

That is a failed word, one of Quintus Horatius Flaccus's more pedestrian attempts at invention.

If "sesquipedalian" were sesquipedalian, it would have fewer syllables. Unless you believe...

petervdkerk (8/1/2011)

---

Ok I did that...that deletes the data from prospectsincampaigns for the specific campaign, good!

However *looks afraid to ask*, it still deletes all data from prospects that are NOT in...

Bad day today. Needed telephone for various things (could use mobile, but (a) expensive and (b) no loudspeaker and area mike so wife and I couldn't have joint conversation...

Nakul Vachhrajani (8/1/2011)

---

David in .AU (7/31/2011)

---

This article might be interesting: note the reply from microsoft at the bottom

Replace of char(0) does not work in DB with Windows collation

I know it...

Very interesting question.

I knew the behaviour with the windows collation (no sql_ prefix to the collation name) because that's the collation I've worked with more than any other (in fact...

I'm coming rather late to this discussion, I guess, but here goes.

At Neos we set up our customer sites so that the main active database got a full backup daily...

I guess you need "and f.campaignid = 4" in the dup...

petervdkerk (7/30/2011)

---

Thanks again for the quick response 🙂

It almost does what I need, except for ONE thing: currently your code also deletes this row from prospectsincampaigns:

135501048

But that shouldnt be...

chadphillips807 (7/26/2011)

---

Hello,

So I have been tasked with creating a table where the Primary Key is a 10 digit number and is randomly generated with each insert. NEWID() and NEWSEQUENTIALID() are...

Have you tried changing to push instead of pull, and seeing if it works then?

petervdkerk (7/30/2011)

---

To prevent any further surprises hereby below the 2 relevant tables and ALL their data scripted.

I've also created the before and after situation where I indented rows which should...

message in wrong forum. Deleted. Sorry

Glen Cooper (4/27/2010)

---

The app's fixed login string is not accessible to the user.

The lkpUser table checks user name/pwd which are passed by the app after the user enters a name/pwd...

So presumably the...