Are you saying that you have no form of backup on anything of any kind?

No database backups, no file-to-tape backups, no nothing?

If that's the case, then I think that the...

>i know that using OR disregards the index (eg: select * from table where date = x or date = y ) , but what about > ?

This isn't correct.

You...

Hmmm, no not really...

When I tried (which was on a simple numberstable), it wrote each row neatly in the file.

Could it be something with the identity?

Have you tried on a...

Fooled around a bit with it on 2005, but...

Couldn't find a way to get the xp_cmdshell 'bcp ....exec dbname.dbo.proc' construct to work, so far I'm convinced it's a database context...

>If that's ok with you, then I'll hang fire until you've had an opportunity to look at the code I posted earlier. >Feel free to switch to personal mail to...

Well, accurate wording is a difficult art, be it in writing or in tongue.

I agree that a policy ísn't automatically the same as a 'best practice', though I think they...

Don't know about all others, but I don't think this thread is anywhere near 'Bankers rounding'.

Though as with all longwinded debates, the focus tends to occasionally weer off course from...

The reason I suggested a proc, is that a proc lets you divide the logic into smaller 'chunks' if need be.

With a view you have to do it all in...

Must you package your report in a view?

You could perhaps write a procedure that produced the output you want.

A proc would give you some more flexibility when adding/summing/grouping etc.....

/Kenneth

Sergiy,

I know you love words, and you love to twist and twirl them too.

I also know that you know what I mean, and you know that I know that you...

Cheers boys and girls. Monday again

I think I'll just make a last post for closure in this thread.

Something struck me during the weekend...

> I said.

> You definition of your habits as "best practice" is wrong.

> Period.

Fine by me. You don't have to agree, and I certainly don't want to force my...

Well, the debate started with just that, the semantics of the two words 'best' and 'practice'

The challenge was if the proposition was really 'best',...

It's kinda hard to say anything specific, other than that in general, regarding deadlock issues, a deadlock is often a result of a flawed design. More than one process wants to 'touch'...

Some other folks mentioned language, which I agree is something very important.

Especially when the language is the only media you have available to communicate with.

Add to that different language and...