Be careful with your use of the ISNUMERIC function. It does not always behave like you may expect it to. You may want to consider using PATINDEX instead.

http://www.sqlservercentral.com/articles/SQL+Puzzles/practicalusesofpatindex/2236/

Here's some good reading for you folks who may be new to dynamic sql:

http://www.sommarskog.se/dynamic_sql.html

Developers resort to using cursors for 2 reasons:

1. The problem domain's complexity makes it difficult for them to envision the set...

I know you've already said that a view may not work for you, but can you clarify what your concerns are with this? What do you mean by 'a...

As rroque has stated, queries in a UNION/UNION ALL must have the same number and types of columns in the SELECT. So the UNION ALL in your first query...

Richter,

Stay away from the cursors/loops solutions and stick with the set based methods that Grant and Matt have posted. If you can, post back some feedback so we...

Yea, that's what I was getting at when I said 'how the data in the rows are used to identify where it belongs'. Most files like this that I've...

That's kind of what I thought based on the data you posted. This probably means also that you'd want to import the data into more than one table in...

So are these flat files fixed length files with one line entry representing one row in one table? If so, this is a pretty straight forward bcp (with a...

Mark,

I went back to the beginning and read your original post. Based on the number of unknowns from your original post, I am not about to begin to...

Also, create the table first if you can. When you run a SELECT INTO statement to create a table, system resources are locked for the duration of the create...

Did I read correctly, it is taking 50 minutes to query a table with only 5000 rows?

What a novel concept.....:)

Hi John,

The GUID in table A comes from the form directly but it has data which needs to go to Table B, Table c etc and when the data...

How many SSC logins do you have?