Kurt,

I am assuming you are using sp_add_job in your stored procedure to create the jobs.  You can add a parameter to this procedure, @delete_level = x.  The value for x...

Stephenie,

Actually what you did makes good sence for the data warehouse.  You don't necessarily want to use natural keys in the data warehouse.  Conforming data means coming up with a...

Whatever.  It seemed all my suggestions were wrong, regardless of what was said.  So it doesn't matter.  Also, I did say use what I provided as a start, not a...

Gova didn't.  He provided sample data and what he wanted, but didn't provide a sample input and desired output.  It would have been better to say given this date: 8/12/2007,...

gova,

It would be beneficial to all if you provided complete information up front; sample data, sample input, and expected results.  With out all that, we are just shooting in the...

The big question that has not been answered, is what type of application is going to use the database.  Again, using a ooak or synthetic id needs to be balanced...

Can you post the DDL for the table and the queries you are having problems with?

Okay, you are talking about a synthetic key; one that has no actual relation to the data being stored in the record.  The answer comes down to this, it depends.

What...

From what I can see, you have the file setup correctly.  Perhaps someone with more knowledge of BCP will see something I am missing.

What version of SQL Server are you running?

Actually, your expected results didn't clearly detail what you were looking for so I guessed.

Check this, is this what you were looking for?

DECLARE @myTable TABLE

(

DataDate DATETIME,

DataVale INT

)

INSERT @myTable

SELECT '07/01/2007', 100...

Use my first query.

try:

exec xp_cmdshell 'telnet aukebper.dc-dublin.de 1521'

Can you post the DDL for the table, the query you are running, and some sample data?

DECLARE

@myTable TABLE

(

DataDate

DATETIME,

DataVale

INT

)

INSERT

@myTable

SELECT