Thank you very much for your reply.

Could you explain more about the SSIS solution possibilities?

I was discussing this issue with the management..........and I want to solve the problem with Dynamic SQL solution. Thank you Very much.

Really thank you very much for your best explanation. I am satisfied using temp table.

how to solve this problem using dynamic SQL? Thank U

For security reason( SQL Injection),Dynamic SQL is not allowed for me.

The number of columns from the base table is known. But the number of columns having at least one...

The problem is, the situation is different for different condition. C1 may be NULL for one condition and may have value in other situation. The condition is dynamic.......

Actually, this is not a data directly from the original table. This is a table variable populated from different tables based on a certain condition.After that I am not...

My Expected result will be ,remove Column C3 and C5 and returns the other as it is

The orginal value is

PKC1 C2 C3 ...

Really thank U very much for your help.

The question is we have log backup before 5 days

I didn't take any single backup after that

When we backup the database 5 days a go, it was very large log file. Immediately after the back up, we created new log file and deleted the previous large...

The Database transaction Log file was on a separate hard drive where the drive is working currently.But We didn't take log backup for the last 5 days

I took the backup using the Backup Up option in the Microsoft SQL Server Management Studio. While I was taking the backup, the database was online (meaning it was not...

Please Help: Is it possible to take buckup from Log file with out bring DB online. For your information, the real data is not available

It is in Full recovery Model

Thank U for your reply:

When I say Full backup ( offline).... we have the full backup taken 5 days a go and in external storage and now we are...