Demicog,

To remove the first character of a column, no matter what the character is, try this...

SELECT SubString(columname,2,999) --Sub the "999" with the max width of the column

To remove...

Here's a different way...

DECLARE @TestString VARCHAR(20)

DECLARE @DesiredLEN TINYINT

DECLARE @FillChar CHAR(1)

DECLARE @ResultString VARCHAR(255)

    SET @TestString = 'SomeString'

    SET @DesiredLEN = 25

    SET @FillChar   ='#' --So you can...

Heber!

I've been looking for a really simple way to "add a running number" to a SELECT for a long time!  Thank YOU!  That IS a really neat trick!

David,

Thank you for your kindness...

I've sent the code samples to 4 different people and have run it on the server at work.  In every case, your code with the <>...

David,

I'd say that I owe you an apology!  Your code does, in fact, return all of the rows expected!  I don't know what I...

Ugh... No cursors... although it can certainly be done with one ...

BJure,

When you say you tested "IT" and NOT EXISTS was faster, what is "IT"?  In other words, what was "NOT EXISTS" faster than?  Thanks.

Hey Matt,

I get it... when sorted in the order of the first column, you want to show only those rows whose value in the third column has changed from the...

All of the methods about system tables and procedures that begin with "sp_" are great... but if all you want to do is get all the columnar info to show...

Cmore,

Here's one more little "secret" of mine ... I never use BCP to import to a "live" table

It, of course, depends on the SELECT statement in the NOT EXISTS but, I'd have to say "Yes", in most cases (was going to say ALWAYS but, sure-as-shootin', somebody would...

Just a note... The IDENTITY function can only be used when the INTO clause (as Figaro did) is also present or you will get the following error...

Server: Msg...

Haven't tested this but should work just fine.  Notice how DATEADD was used to subtract 4 months from the current date... not a job for DATEDIFF as many would think...

It won't actually report what constraint was violated but it will reject any record to the "error log" that either violates a constraint, key, foreign key, data-type, or column width. ...

Thought I'd clarify my statement about using an Outer Join as a replacement for a "Where Not In"...

About outer joins... I'm sure you've heard all sorts of horror...