Click here to Skip to main content
15,878,809 members

Comments by fvalerin (Top 14 by date)

fvalerin 23-May-14 11:50am View    
Thanx J Snooze, God bless you. It seems your answer is the correct, but I have some problems :

First I didnt explain all the context the right way, I am really using a column field on a table instead of a XML variable, besides the field is a VARCHAR(max), instead of a XML (this is the way it was designed, I didnt, and cannot be changed).
Second I have the requirement to process the records in DLM sentences, not processing records one by one on a loop.
Third the process is a trigger, so what I need is to make a INSERT INTO ANOTHERTABLE SELECT ... FROM INSERTED , so it will be a massive INSERT.
Finally, I will do make a loop for the INDEX of the XML element on the pseudo XML field.

So I learnt that I can use CROSS APPLY like this :

...
FROM TABLEWITHXML
CROSS APPLY CAST(PSEUDOXMLFIELD AS XML).nodes('Root/ProductDescription[ position() = sql:variable("@index") ]') as Table2(ProductDescription)


But generates the error : Incorrect syntax near the keyword 'AS'.

I dont know how to proceed or how to do it another way fulfilling the previous requirements.
fvalerin 6-Mar-13 9:52am View    
This solution only applies to C++, on C I get the error :

This header requires a C++ compiler ...

I know I tagged this question as C or C++, so my mistake. I did it because sometimes stuff on C++ works on C, but this is not the case.

Anyway I will use it when I need this on a C++ project.

Thank you very much for your time and for the try.
fvalerin 3-Oct-12 11:28am View    
So, can we call to this the 3-tier Architecture pattern or Multi-tier pattern in Design Patterns jargon ??????
fvalerin 3-Oct-12 11:22am View    
Dear RaisKazi : in MVC there is a direct relationship between View and Model ....
fvalerin 7-Sep-12 16:10pm View    
Thanx again, another good idea, I'll try to do that, i dont know when yet, to search for the open source code of a tool like that.

I gave you points too, now. (Im not used to use forums).