CLR?

I have seen some performance advantages when used in scalar functions. CLR can be used when there is no corresponding T-SQL functionality like splitting a string by a delimiter.

Most people...

Second query gives more correct answers. It also calculates incorrect result 1-15 days after today depending on the age.

For instance a person who was born on "19720315" gets incorrect answer...

Motorcycle, photography, scuba, ski and basketball.

But my favorite is playing with my 5 years old son. Also watching Sponge Bob with him.

Hi,

Have you watched "Office Space"?

Cenk

Hi,

1) If you send archive date as a parameter and store archive date in some table you can solve this by if statements:

IF @QueryDate > @ArchiveDate

  Select * from orders

else

 ...