Good question, but I think I'll keep mine:Whistling::-)

Mark Harley (7/23/2014)

---

I've confirmed that this does indeed work, but it can take an ungodly amount of time. I have 125,000+ events and 175,000+ locations to work through and...

Mark Harley (7/17/2014)

---

I have a table with events that took place at specific x,y coordinates and another table with a listing of our locations and their coordinates. I need...

I think I remember reading somewhere that the memory grant for a n/varchar(max) is 4000 bytes.

Paul White has this article which may also be helpful

Good question thanks Phil

Good and interesting question thanks

Yeah the documentation isn't that great. I spent a fair amount of time trying to change oracle sqlloader scripts to BCP with limited success. In the end I...

Also, before I forget I ran it with this

BULK

INSERT #TmpStList

FROM 'c:\Temp\TxtFile.txt'

WITH (

FORMATFILE = 'c:\Temp\formatFile.fmt'

...

Sorry it appears that slash n's are stripped from the forum. Put a \ n after the \ r for line 5 and try that. Without spaces of...

Hi

Try this as a format file

9.0

5

1 SQLCHAR 0 1 ...

Do you mean that if...

To build on mister magoo's suggestion you could try

CREATE PROCEDURE [dbo].[TestInsert](@IdEmployee int, @Name varchar(20))

AS

BEGIN

DECLARE @o TABLE (IdEmployee INT ,Name VARCHAR(20));

INSERT INTO Sandbox.dbo.Emp(IdEmployee,Name)

OUTPUT inserted.IdEmployee, inserted.Name

...

I couldn't agree more, it would be nice to clean up some of these things.

Personally I would leave REPLACE alone and add a PATREPLACE.

I would also...

Thanks Andy

Hi

This should help you

http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html