If it's the Primary Key, then you may be (will be) destroying referential integrity for other data in other tables.  If it's the Primary Key and you don't have referential integrity,...

I'd never use @@Identity because it is not scope sensitive and, in the presence of triggers, will surely return an incorrect value.  Always use SCOPE_IDENTITY for such a thing.

Yes, it is possible to modify the number by first doing a SET IDENTITY INSERT... here's the syntax from Books Online...

SET IDENTITY_INSERT [ database. [ owner. ] ] { table...

Actually, there is one method that's a few milliseconds faster over a million or so rows...

SELECT CAST(CAST(datecolumn-.5) AS INT) AS DATETIME)

As usual, please don't take my word for...

Felix...

You may want to post some of those custom functions you're talking about... you'd be surprised at how some of them can be speeded up or maybe even eliminated with...

And, you still need to determine.... is null a date way back in the past or a date in the future?

The destination table has a ROWID field which cannot be an identity key, ...

Why the heck not?

I'm not seeing the pattern here... can you explain how you came to the actions you took and why you need to do the INSERT to begin with?  What do...

Yes, there are some concerns...

SQL Injection Attacks

Poor performing code due to recompiles because is really 100% dynamic SQL

Poor performing code because it's written by GUI experts who might not be...

Thanks for taking the time to provide the belated feedback   Lot's of times, you wonder if someone died or what?

This would work...

 SELECT *

   FROM dbo.PostalCodes P WITH (NOLOCK)

  WHERE SQRT(

            POWER((69.1 * (P.Latitude - @Lat1)),2.000)

          + POWER((53 * (P.Longitude - @Long1)),2.000)

            ) <= @Distance

...but I believe this only works...

Cool... thanks for the feedback, Mick.

"SysDate" "Months_Between"  Are you trying to do this in Oracle or SQL Server?

DTS the production tables to a development database.

David,

Tomakeiteasiertotroubleshootyourcodeyoushouldadoptandfollowaformattingstandardthatincludesthepropercasingpunctuationandindention

Intheprocessofformattingyourwillfindthatmanyproblemswiththecodewillsimplyvanishbecauseyouwillbelookingatthecodemorethanonceaswellasit

beingeasiertounderstandforevenyou.