Archive for Mai 21st, 2022
Berchtesgadener Land am Untersberg – online webcam
Samstag, Mai 21st, 2022Bundesverband der Krankenhaus-IT-Leiterinnen/Leiter e.V. (KH-IT) – Frühjahrstagung 2022
Samstag, Mai 21st, 2022Samstag, Mai 21st, 2022
LIVE: The crew aboard the International @Space_Station opens the hatch of @BoeingSpace's #Starliner and delivers remarks welcoming the new spacecraft to the orbiting laboratory: https://t.co/TOi77Jz7ID
— NASA (@NASA) May 21, 2022
BR quer mit Christoph Süß – wenn die Berufsunfähigkeitsversicherung das Geld verweigert
Samstag, Mai 21st, 2022Raspberry Pi – GPIO Elektronik Einstieg
Samstag, Mai 21st, 2022Anstrengender Alltag als Wassermeister – was bekommt man dafür € 2.940,- netto
Samstag, Mai 21st, 2022Microsoft SQL Server – export XML column rows from SQL table into individual files
Samstag, Mai 21st, 2022
Microsoft SQL Server – export XML column rows from SQL table into individual files
It is roughly formatted as such
+————–+——————+
| REFERENCE_ID | REFERENCE_XML |
+————–+——————+
| 1 | <xml>…</xml> |
| 2 | <xml>…</xml> |
| 3 | <xml>…</xml> |
| 4 | <xml>…</xml> |
| … | <xml>…</xml> |
| 70000 | <xml>…</xml> |
+————–+——————+
I would like to loop through every row and bulk export each REFERENCE_XML column and name it as the REFERENCE_ID
My output folder set would look as such
C:\References\1.xml
C:\References\2.xml
C:\References\3.xml
C:\References\4.xml
C:\References\…
C:\References\70000.xml
Italy Seiser Alm 2055m – online webcam
Samstag, Mai 21st, 2022