Heh... I gotta get it through my head, someday... order of predicates is not guaranteed to be in same order listed. I keep treating the bloody things like a...

http://www.simplyhired.com/

... is one of the best sites I've run across with feeds from Monster, Dice, etc, etc.

Maybe partition the table so you can manage smaller tables instead of one huge one.

So, try to manuall login to the subscriber machine using PVALDEVINO and see what happens.

Best (10/14/2008)

---

i have a column called DOB(datatype :datetime) in my table A which as values like as follows

DOB

1925-12-19 00:00:00.000

1935-04-10 00:00:00.000

1929-08-19 00:00:00.000

I WANT IT TO UPDATE...

leo.medina (10/14/2008)

---

You're right we're also asking ourselves why the select does not give us any error and here we see actual results with ten records. It's just weird!!!

Anyways, thanks...

Heh, no rest for the weary, eh? 🙂

Guess I don't see it since you have the same thing in the SELECT list... should fail there, too. Maybe, I've just not had enough coffee today. Sorry,...

Heh.. yeah... you're right. Still looking.

... but the morons did it anyway. That bloody well sums it up and that's why "Business Intelligence" is an oxymoron. 😉 There's...

If FName has no spaces, the CHARINDEX will return 0 and then you subtract 1 to make the operand of LEFT a negative number. You need to check for...

Max,

Can there be a 4th possibility or not?

RECID COL1 COL2 ...

What did you try? Please post the code and the data you tried...

I agree......

That's a...