Sure you can replace it with null or use the nullif function.

declare @Return varchar(5)

set @Return = CHAR(13)

select REPLACE(@return, char(13), null), nullif(@Return, char(13))

sturner (6/23/2011)

---

10,000 rows... No way I'd be doing separate inserts via ODBC. I would explore alternate methods.

Push the rows over to thew remote server and then run a...

EEEWWWWW!!!!! I missed the 1 minute part and only 32 seconds. As i was writing this you posted that neither 3 or 4 worked on a single line. Not sure...

BAH! Thanks was wondering why that was an issue.

Try like this:

--method 3

EXEC('INSERT INTO VISITOR_POSITIONS (ID, VIPO_DESC) SELECT 1001, ''Test1''...

Not sure why method 3 did not work. Looks correct to me. Method 4 will only work if the remote server is sql 2008. From the two you have working...

Since it sounds like you have a lot of data to insert you might find it faster to do you insert as a single command like this.

EXEC('INSERT INTO Table (Name)...

And intellisense can not make up for naming issues like the OP is facing. That is a mistake that anyone with any real sense would make because the join has...

Be careful with the IsDate function. It will return values that can be parsed as a date that are probably not actually realistic for your application. For example:

select IsDate(5421)

There are...

Seems like you could create a table with a single nvarchar column large enough to hold the largest record for the import portion. Then do 9 - 10 insert statements...

Perfect example of why column names should remain the same across tables. Otherwise you can end up with a column...

Sorry if my first post sounded nasty. Apparently I was channeling a certain individual who posts here frequently.

If you are going to be converting this into a datetime field...

Wow this a classic example of why using the datetime datatype is so important. You have created a bowl of pasta and you are struggling with how to stir the...

For even better performance read Jeff Moden's Tally Oh![/url] article.

rbecl (6/22/2011)

---

Hi, What "read only activity" can exist on databases?

I am new to SQL and would like to find this out. I regard read-only activity to consist of:

views, stored...

Well all too often people will write an insert trigger to create an audit trail or something along those lines. Let's assume there are 3 records being inserted at once...