That is not a recommended process, you will have performance issues and you'll be losing all the advantages given by the full recovery model.

Once I found a company where they...

It's not a very difficult task to do, you just need to have the correct tools to do it. For reference on the methods used for this solution, you should...

erikd (9/2/2013)

Sean Lange (8/29/2013)

saravanakumar.G (8/28/2013)

Thanks for the reply.

Yes. the SP is working if we put single quotes across the tablename ('schemaname.tablename').

I want to...

Why would you need to handle nulls? Null won't be...

Yes, it is possible. However, for more information on how to do it, we need more information from you.

Check the article linked on my signature to get better help.

There might, depending on what the real information looks like. What's wrong with the given solution?

If I understand correctly, you need something like this.

SELECT SUM( CASE WHEN age BETWEEN 18 AND 25 THEN MyValue END) AS [18-25],

SUM( CASE WHEN age BETWEEN 26 AND...

Thank you for posting your sample data. If I understand correctly, the following query should help you.

SELECT a ,

b,

c ,

CASE WHEN a >= b AND a >=...

It's funny, your last sentence could be my answer. An example of what you need with DDL, sample data and expected results will be handy to help you. 🙂

Take a look at Jeff Moden Splitter and come back if you have questions or need help.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Thank you Jeff,

Your suggestion gave me an idea. It was actually a precision problem. I just changed to a larger precision and it was fixed. 🙂

Code turned out like this.

SUBSTRING([Column...

Hi Koen,

The expression works on most cases but on some values it just returns NULLS when it ignores failures or the following errors that make the task fail.

[Derived Column [187]]...

Even if the solution given will show the correct result, you should consider to do this calculations in the front end.

Do you mean that we're destroying this site reputation? I'll better...

Could you post DDL, sample data and expected results to give us a clearer idea of what you want?

Check the article linked on my signature to find out how. No...