Triggers operate quite differently between RDBMS's... if you really want to know about triggers in SQL Server, read about them in Books Online instead...

Did you try any of the things I posted?

Also, why are you returning 42 million rows instead of a summary of the rows?

Whilst we wait...

CREATE FUNCTION dbo.ProperCase(@pString VARCHAR(8000))

/**********************************************************************************************************************

Purpose:

This function will change all letters to lower case and then change the first letter that follows any non-alpha

character to an...

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...