In a simple race single T-SQL REPLACE outperforms CLR simple byte-by-byte...

Your question is not very clear.

To get number of weeks...

It wouldn't help to track DELETE's...

Compare prices on amazon :-D...

Without having table defenitions it's not easy to understand what you really want here. DDL with some sample data would help a lot, therefore click the link in my signature...

You can also learn about another two string T-SQL functions:

SELECT LEFT(ACCOUNTNUMBER, 3) + '-' + SUBSTRING(ACCOUNTNUMBER, 4,5) + '-' + RIGHT(ACCOUNTNUMBER,2)

FROM BILLING.ACCOUNT

However, it looks like you are going to...

Ok I assume that your source table has no "anchor" column which can be used to count your inserting progress...

So, here an example.

Lets crerate such a table, you will see...

You are welcome!

Have you tried to use the column from the DataSet used for report to populate the Paramaeter ListBox? Does it works at all?

I suggets you creating separate DataSet as SELEct...

If you perform real DELETE on this table and you count it as activity you will need to do the following:

1. Create a trigger to log action and its timeinto...

To read about SQL Server Agent:

http://technet.microsoft.com/en-us/library/ms189237.aspx

As I said before, you will, most likely, need a trigger to log the action. Indeed, UPDATE and INSERT could be tracked just by having...

1. As long as your naming is consistent, use of udf_ prefix is fine, as it helps to identify UDF just from its name. Until you have insomnia, I would...

That will do what you asked for, but I have doupts that it is what you really want...

select *

from @t1 where maintdte != (select MAX(maintdte) from @t1)

You will need to use change detection triggers or your queries will be quite complex.

Please follow the link in my signature to see how the case/question should be presented for...

What determines "Position" of the row in your tables?