Why don't you give it a try? :unsure:

Does the trigger return any data (e.g. due to a SELECT statement left over from debugging)?

Can you post the code for the trigger?

Can you post the query you're using together with the exact error message?

Assuming you have a Tally table (see the related link in my signature if you don't know what that is) you could use this table in an OUTER APPLY query.

If...

Your question can't be answered in a forum post.

Especially the term "in general" could be broken down into the following subsections:

Hardware (e.g. slow spindles, network issues,...)

Overutilization of hardware (heavy load...

Since this is the 2008 forum I didn't even consider 2012 syntax as being an option. 😉

Even if, I wouldn't be surprised if the new syntax would perform less efficient...

duplicate post. No replies plese.

Please repond using the original thread

@Larry: Posting the same question multiple times does not only fragment the answers. It might also lead to duplicate answers (=...

Something like this?

DECLARE @Task TABLE

(

DESCRIPTION CHAR(5),

DueDate DATETIME

)

INSERT INTO @Task

SELECT 'Task1','2012-03-30' UNION ALL

SELECT 'Task2','2012-03-31' UNION ALL

SELECT 'Task3','2012-04-01' UNION ALL

SELECT 'Task4','2012-04-02' UNION ALL

SELECT 'Task5','2012-04-03' UNION ALL

SELECT 'Task6','2012-04-04' UNION ALL

SELECT 'Task7','2012-04-05'

DECLARE @RAG...

Shouldn't be Task4 show Amber then? (It's "between" amber and green)

Why should Task2 return Amber?

Why NULL for Task 6 and 7?

Using SQL Server it would be a little more tricky:

DECLARE @tbl TABLE

(

Name VARCHAR(30),

Dept VARCHAR(30),

Enddate DATETIME

)

SET DATEFORMAT mdy

INSERT INTO @tbl

VALUES

('Bill','Shipping','01/20/2009'),

('Bill','Receiving','05/15/2010'),

('Bill','Accounting','03/28/2011'),

('Sara','FInance','05/14/2010'),

('Sara','Shipping','10/11/2011')

;

WITH cte AS

(

SELECT *, ROW_NUMBER() OVER(PARTITION...

Are you looking for something like this?

DECLARE @table1 TABLE

(

id INT IDENTITY(1,1),

DateOfBirth DATETIME

)

INSERT INTO @table1

SELECT '20060331' UNION ALL

SELECT '20060401' UNION ALL...

Ronnie Jones (3/27/2012)

---

VIOLA!! Using the Hex for the ROWTERMINATOR did the trick. It's now importing correctly.

Thank you for all of your responses on this issue. I've been at this all...

Is it possible the .dat file is Unix based?

In that case a line feed is .

But when using BULK INSERT, it silently add \r to it, causing the error.

There are...

Did you have a look at redgates SQL-Compare[/url]?

It might do exactly what you're looking for.