SA-MP Forums Archive
Not actually related to SA-MP - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Not actually related to SA-MP (/showthread.php?tid=617709)



Not actually related to SA-MP - MarikAshtar - 25.09.2016

Yes I know this is not related to sa-mp!
But since I've tried other forums etc with little to no help I'm desperate.

What I need help with is this code:
PHP код:
SELECT *
FROM [Database1].[dbo].[Table_1]
ORDER BY NEWID()
FOR 
XML AUTO
SELECT 
*
FROM [Database1].[dbo].[Table_2]
ORDER BY NEWID()
FOR 
XML AUTO
SELECT 
*
FROM [Database2].[dbo].[Table_1]
FOR 
XML AUTO
SELECT 
*
FROM [Database2].[dbo].[Table_2]
FOR 
XML AUTO 
When I run this code obviously I get 4 .XML files. Is there a way to get the results combined into ONE xml file?
And I'm very very new to this so please point out if I can do this code faster and more efficient in some way.

What I then have to do is take the .xml file into C#, bubble sort it, and transfer it back to a 3rd database.
And at that point I'm compleatly lost..

Again, I know this proberbly doesn't belong here and is a possible rule break but since I know there a good and helpful coders here who can help me understand and get this done I'm willing to risk it.


Re: Not actually related to SA-MP - X337 - 25.09.2016

Check out http://stackoverflow.com/.
I think this should be posted in Everything and Nothing forum


Re: Not actually related to SA-MP - MarikAshtar - 25.09.2016

Thank you