Try this and see what comes out

SELECT * FROM [dbo].[Just_imported_table]

WHERE ISNUMERIC([Col003]) = 0

OR ISNUMERIC([Col004]) = 0

OR ISNUMERIC([Col005]) = 0

OR ISNUMERIC([Col006]) = 0

OR ISNUMERIC([Col008]) = 0

Something does not look right in your description of the problem. The first post suggested that you are reloading data from one table (with varchar fields) to another table (...

is it 06/20/2006 or 06/01/2006?

One of those should work. They are primitive but as long as you can goarantee the input format to be always 6 chars then you should...

If the error pops up in the UI but the button gets greyed out then you have to check the GUI code. Some of the event handlers are messed up.

Re...

There is a bunch of small problems with this trigger.

1. This is an INSERT trigger so it does not fire on updates.

2. It does not cover all scenarios, for...

There is another twist to this story. The value that the system timer presents to the callers is sometimes interpreted differently by the callers. I run some tests where I...

OK. I did more testing and more investigating and would like to clarify to all what is going on.

First of all the 15 or so ms gaps are not a...

I need this for logging in a multiprocess, multithreaded environment.

I understand that the CPU does other things but even when I have multiple callers call the logging SP (I...

Andrew.

Just few things to clarify. When I stated that they required few months of tutoring it meant that from the point of zero knowledge of SQL to the point where...

I personally love NULLs.

I never developed an application where all the data was always available or known and NULLs are perfect for such situations. I don't fully agree with Andrew...

Thanks for the input.

george, thanks for the extensive 'script' to go by.

To me the natural keys are like requirements. Both have the twisted tendency to change. In many cases what looks like a perfect natural key today looses it's quality tomorrow.

Also...

Sorry, I think I did not properly ask the question. I am looking to find out if using a 2000 database (restored or reattached) on a 2005 server creates some...

I use the identity fields a lot but I do not go crazy with them. I would never use them on lookup tables like states, ZIP codes, gender or such....

The above works with DD/MM/YY only. For dates in DD/MM/YYYY format use 103 instead of 3.

You can use the CASE to check the length of the input and use both...