What do you want to do with macintosh or mcintonsh?

In your mind, you've adequately defined the requirements... in my mind, I still don't know what you want.

midan1 (12/2/2007)

---

what i mean is that

i need to to generate the next month that depending whre the last month end !

and i must check whre this employee ID...

So, you're saying that no matter what happens, you want numbers that start on 01/01/2007 and follow the pattern of 1,1,2,2,3,3,4,5 for the full year?

Title says "Convert Sql Data to any file format "... So, show me how this coverts to XML, PDF, EMI, or EDI.

The best way to do this is to not do it at all... OP wants to limit the number of ID's to 999.

Appreciate you bumping your own post, but the reason why not many folks have responded is we just don't know what you're talking about....

Lets see... displaced Russian living in New Zealand... which country would that be?

Sorry for my bit of sarcasm... you do realize that you get 999 ID's and that's it, don't you?

I'm sorry, I don't see the pattern...

B

I've done some testing and if you put an exclusive lock on a table you're deleting from and leave only the PK (doesn't matter if clustered or not), takes 15...

but when you're dealing in hundreds of millions of records with finite resources you have to delete it sometime.....and when the garbage man comes around to remove the records flagged...

Hmmm... and what do you do for sprocs that are used by multiple applications?

"Steal" code from those...