Here's the quick solution:

select o.name from sysobjects o where o.type = 'v'

and o.name not in ('syssegments', 'sysconstraints')

Haven't looked too close on them, but if these are flagged as userobjects, it...

Untested, but I think this should do the trick.

select  t.ThreadID,

        t.ThreadName,

        t.ThreadDescription,

        x.UserName,

        x.maxDate

from  (

         -- latest post for each thread with name and date

         select  p.ThreadID, u.UserName,...

You should have the feed not trying to insert already existing data.

It can be done in several different ways, but the common factor is to modify the feeds insert statement.

/Kenneth

As with most things, it's a matter of habit.

Things we know are 'easy', things we don't know are 'difficult'.

There's no rocketscience about that.

I...

This isn't necessarily the wrong section..?

As for checksum goes - you have to be aware that checksums aren't 100% failsafe.

There is always the possibility that although there are different values...

Oh, every time we fall for the trap of relying on implicit defaults, it will error - sooner or later.

As for 30...? Nope... Doesn't seem like it in my case...

Here's one way.. also assumes no double spaces are present...

-- Sample on how to count # of occurences of a single char

-- or pattern from a text...

If the purpose is to retain partial loginfo during a transaction that is rolled back, there is a way to use a table variable as placeholder whithin the transaction. Since...

This construct isn't so good, since placing a function on the datecolumn may prevent indexes to be used.

Please see the link Gift Peddie posted on best practices on dates and...

As said above, this is an old 'caveat' with the legacy outer join syntax compared to ANSI joining, that has been around since day one ANSI joins was available.

The primary...

This thread is almost two years old

Perhaps you'd better start a new thread with your specific problems, you environment, what errors you get...

Agreed.

MS has for many years now recommended that old legacy join syntaxes be replaced and rewritten in ANSI style. I wouldn't be too surprised if in the next version of...

Hmm... yes, there is. Updated stats on it just for kicks, but still the same results.

However, there may very well be some skewing going on, since I now noticed that...

Very unscientific, quick and dirty on my desktop, but there seems to be consistent anyway...

Out of a table with ca 3.7 million rows, do the 'extract only digits' task on...

This is not correct.

Using BETWEEN in this scenario will give you everything from midnight 2006-05-01 up to and including midnight 2006-05-02.

/Kenneth