Thanks, not heard the term blueprint before , but sounds what I need.

However can't find 2008 version.

I THINK the EXISTS would be faster than the LEFT join, but both are v.easy to read.

For the unique constraint. I think you could create a filtered unique index...

No prob thanks for helping.

I got it to work with SQLCHAR in format file, Just worried I've got it to work by chance and storing up potential problems.

BTW. (Loved the...

Thanks

Where do I put the -c I tried

BULK INSERT tBCP FROM 'C:\temp\tbcp.csv'

WITH (FORMATFILE='C:\temp\fmt.fmt', DATAFILETYPE='char')

It doesn't work

again it has removed the backslash n

BTW the field terminator for the 2nd column is "\"\r" when I post it removes the

Yes 7 does get converted to 55 its ASCII value.

If I try and import 21 it gets converted to 12594 (2=ASCII 50 and 1=ASCII 49) so how it gets to...

Hi

Never used access, but had problem with Excel file on another machine. I had to set the user in the linked server properties to connect to the XLS as...

Thanks for the replies

I will try the rebuilding the index after the delete.

I wasn't really clear in previous post. The Archive process.

1. deletes approx 5GB per day from a_tbllog.

2. Then...

Sorry, it is Management Studio on 2008 R2.

So if the owner of the job is sa and SQL Agent service runs as SQLAgentUser then whenever the job interacts with Windows,...

Thank you very much.

it's the second one: get the latest bill run per customer when the customer has multiple records select the one with the Largest billrunid (does that make...

Thanks for relying Gila

I don't know of this concept.

However it's a 3rd party DB I cannot make changes to it.

As a simplified model I THOUGHT Sql executed the...

I think I've misunderstood your requirements but this is how you can call a function

create table #tmp

(

f1 int null,

f2 int null

)

GO

insert into #tmp values (1,2), (2,9), (3, 15)

GO

create...

Thanks people.

I've just played with the profiler on my machine (the app works on my DB) and traced the errors transaction and error event. There is no transaction around the...

Thanks HanShi

I was just using default options for profiler. I will test this locally so when I have my window on the problem machine I can set profiler up and...