Posts by Brupikk • 141 points
4 posts
-
4
votes1
answer427
viewsQ: Search only the smallest number of each letter
How do I search for only the smallest number of each letter, in Sql server? My table: Expected result: A - 1 B - 2 C - 1 D - 1 E - 3…
sql-serverasked Brupikk 141 -
1
votes1
answer215
viewsQ: Job to write query data to an XML file
I need to save the result of a query in an XML through a job that will run scheduled daily in SQL Server. Procedure already brings the result in XML format with tags, in a variable. I just need to…
sql-serverasked Brupikk 141 -
1
votes1
answer182
viewsQ: Sharepoint - Block excel connection data view
Safety issue in connection information. I implemented a Sharepoint and users open the spreadsheets through the web, but they have the option to open in Excel too, it is possible to block this…
sharepointasked Brupikk 141 -
8
votes5
answers6773
viewsQ: Separate ddd from phone with SQL statement
I have a table with fields DDD and Phone. Some were registered correctly, others the ddd is next to the phone and need to separate. TABLE +--------------------+ | DDD | Telefone |…