I have a data extension (Name: Factura_T_Alex) with a single primary key (Name: NrFactura) and an attribute (Name: DataEmitere) which is a DateTime type. I need only the date part to use in a script so I created a Text type attribute (Name: DataEmitereText) in which I want to save only the date from DataEmitere so I wrote the folowing SQL Query:
SELECT NrFactura, CONVERT(varchar, DataEmitere, 101) AS DataEmitereText FROM [Factura_T_Alex]
and IT WORKS!
But the targeted data extension for this is the same data extension I'm using in the SQL Query Activity, Factura_T_Alex, as seen in the image below.
My question is: Can I do that? Can I use the target data extension to update it's own fields in SQL and be sure that nothing will go wrong here? Like a field being written with the wrong value?