Thank you for your reply. I will try that.

Thanks for the replies.

Yes, we are working on alerts now.

In our case its a DW. Since we have multiple files that are currently set as limited in their growth, would...

Thank you John.

Thank you for your reply. This is very helpful.

Thank you everyone for the input. It is very helpful.

Thank you for your response

We are not sure yet whether to create it as clustered or not. This is something we will need to test with.

The deletes will happen...

Hello,

This worked great. Last Friday I was able to get this working on our system.

Thank you very much for your help.

Thank you Jeff and thank you all very much, I will try this out tomorrow once I am back in the office.

Hello,

Thank you very much for your help. I appreciate it. Will this have the CTE recursion limit? For now The data sets are small, but we may get larger files.

Thanks...

Hello,

Here is the set. There will be a begin and end date where we get the min(begin) and max(end) for each set. The cols will be ordered by the date...

Hello, Thank you for the reply. It did work. This is the way I get the data in the file from a source system and need to properly insert it....

I tried to paste the result to make it looks nice, but could not.

Here is the code for the dataset in question. Thanks for your help.

CREATE TABLE #testa

(

A INTEGER,

B VARCHAR(2),

ToSum...

Hello, Thanks for your reply.

This will group all the rows where A = 1 and B = Al to one row.

I only want to sum those up where they...

It is not yet in place. Currently we have a service that does calculations to populate a table. The developer is asking if we could have a clr to...

Hello,

Thanks for your reply. Its just something I hope to get done with a query that I can reuse.

Thanks