I put a copy of PKzip25 in a zip file, along with a .SQL file containing an example, which you can download here

yes, the logic is the...

when converting a number to datetime, the date portion is left of the decimal place, and the time portion is to the right of the decimal point.

I think it really...

Matt Miller (2/27/2008)

---

Lowell - if you're on 2005 - use CLR instead to create the REGEX expressions instead. The XP is nice in 2000, but you can do better...

I know that by using regular expressions, the \b is a word boundary; it might be a space/tab/Crlf, or it might be punctuation...period comma exclamation semicolon etc.

using regualr expressions, you'd...

SQL ORACLE is right...since "sa" never logs into the domain, it has no access to the computers and shares that exist on the network.

you'll have a similar issue if you...

I love SSC, and wander through it nearly every day .

things i'd like to see:

Something we had at one time, that was snipped out in the new design:

under "Recent Posts"...

that goes back to my original assumption...you said consecutive, and i stated my solution would work If you meant consecutive by the PK of the table...now you've changed the rules....

now...

my example still finds all suspected records...try it.

here's your statements cleaned up so they work:

the idea is joining the table on itself in order to do the comparison

--===== Create the...

well, text all the other blob typea are not allowed, but you can cast/convert to a varchar(8000) in order to work around it: this is typically what i would do:

Select...

here's the function:

I tripped over that issue as well;

below I pasted a function i made for encoding "illegal" characters, it might help you out to clean up the data, or get the...

ok, I'm assuming that by consecutive, you mean that the PK is an identity field, and that if you self join the table on itself by way of PK =...

behind the scenes, the GUI is creating a new table, then dropping the constraints on the old table,

dropping the table, renaming the new table to the proper name, and...

connections are not really handled by SQL server, but usernames/passwords/spids, once a conenction has been made is auditable.

If you need to know who is connecting by IP, you should capture...