Posts by Caio Felipe • 16 points
3 posts
-
0
votes1
answer66
viewsA: How to process in Mysql with select
I believe that what you want to do is a view not a previous, the view that would be a "visualization" of a query, follows the example: CREATE THE VIEW: CREATE VIEW [NOME DA VIEW] AS SELECT [PASSAR…
-
0
votes2
answers70
viewsA: Doubt in an SQL DISTINCT
Good morning, you can use the row_number passing only the cd_agrupador, if you want to add more fields. Follow the example: SELECT * FROM( SELECT CD_CLIENTE, CD_CONTRATO, CD_AGRUPADOR, ROW_NUMBER()…
-
0
votes1
answer188
viewsA: Data Flow Task: Processes but does not write to the Database
Make sure your data stream component is set to "redirect line". If you are trying to switch to "component failure". By changing the setting to "component failure" and run, in case of error, you can…