Now you're agreeing with us .

"My managerial tact was treat them all differntly under the same rules."

Wow... that sums it up good .

Can you post the table(s)'(s) definition and also sample data and the expected results of the proc. I don't have enough info to help you at the moment.

Corrected the main post...

Also I never used NSP, in any language and there was like 50 possible meaning.

Ya... that should save you a KBs on the HD . But might be costlier on the CPUS. Always that depends...

I heard maybe NY or london... but she also said to me tha she lived in China so I have no clue.

... and maybe your wife would be against the idea too.

Although you never know these days .

A DB shouldn't be without a calendar and a numbers table .

Create a calendar table. TheDate Smalldatetime clustered index primary key and fill it untill 20??

Then just do select from Calendar where Date between ? and ?

Ya I had figured the select null at the end and the db change... but that was it.

And since it's you, I'll have to withdraw my mariage proposal...

I think I read sometime like this and it might have been related to SP4 but I'm not even not too sure about that to begin to make a statement...

Well it wouldn't be false ... and it might start to send 'em some hints.

There's always the crdate column in sysobjects for the constraints... but that's not much info.

I'm the third with the same understanding of cursors... so we must be right.

Can you run the profiler and try to get more info?

I'm really thinking to upgrade and move to the us... warmer climate funnier job, better conditions (hopefully). Closer to the us pool tour