Posts by Adalberto • 23 points
3 posts
-
0
votes2
answers2379
viewsQ: Merge 2 selects into one, showing fields
The 1st select shows the following fields: CONCAT - FILIAL - COD. PRODUTO - DESCRICAO - QNTD. VENDAS PUB. 11 - 1 - 1 - PRODUTO 1 - 10 12 - 1 - 2 - PRODUTO 2 - 20 13 - 1 - 3 - PRODUTO 3 - 30 2nd…
-
1
votes1
answer271
viewsQ: Remove fixed-sized part of an xml
People, I have this piece of an XML and I need to remove the value (357122.40) that is between the tags < vMerc>xxxxxx< /vMerc>. Only this value has no fixed size.…
-
1
votes1
answer1315
viewsQ: How to run a script before a view on sql server?
I created a view and it looks for information from an X table. Only this table X, must be created in a select, before executing the view, for the data to be updated. It has to create something in…