Hi Lutz,

Thanks for help me out.

But it is difficult for me using CTE.

anyway, i know we can do also another way using nested while loop.

it's much easier that CTE...

Hi Sean,

I am trying to make a triangle pattern like this

i want to implement while loop.But whenever i try to run then it goes to infinite loop

my pattern is like...

i have not new backup file.I have only new .trn file.

So when i am going for restore the database, i am using the old one .bak file

and the recent...

Yes it is possible using the convert or cast function !!!

may be you don't know that..