Hi,

Thank you, it is configured for every 3 hours. Sorry could you please explain what are differences between configuring the schedule to back up transaction log and truncate t-log?

Best regards;

Hi,

Thank you, it is the full recovery mode. I already configured the schedule to back up transaction log. Could you please clarify why do we need to configure the schedule...

Hi Friend, thank you so much it is very helpful I can solve my current concern.

Thank for your help, I could read it in fixed m , but i am researching how could I know max of m value because I need to take values...

Hi again,

I addressed it, i just follow

SELECT

n10.nd.value('@id','varchar(50)') AS ID

,n1.nd.value('(./text())[1]','varchar(50)') AS PDTYPE

,n2.nd.value('(./text())[1]','decimal(12,2)') AS AMOUNT

FROM @TABLENAME AS n0

cross apply

n0.XMLRECORD.nodes('row') AS n10(nd)

CROSS APPLY...

Hi, thank for your answer, you advised me in XML RECORDS. In case I have 10 xml records in the table, what should I adjust in your solution?

ID ...

Thank for your answer. It is helpful