Posts by Marcelo Catunda • 146 points
3 posts
-
12
votes3
answers62099
viewsA: zero to left (LPAD) in Sql Server
If the mes field is numeric, to display with zero on the left, vc should demonstrate it as a string. Error may be masking the real problem. Pass the table structure. select distinct…
sql-serveranswered Marcelo Catunda 146 -
1
votes2
answers84
viewsA: Running the Procedure with date type argument on a dblink
As it was a problem for a supplier, I wanted to share the doubt before presenting the suggestion that I thought was right. Well, the call in Sybase works fully in this format: .…
-
0
votes2
answers84
viewsQ: Running the Procedure with date type argument on a dblink
when running the file below, via DBLINK on Oracle corporativo..UP_COP025_ASS_DMANDA_JURID_I 17444968, 1, "1", "20150806", "RJ", " ", " ", "000020" get the bug: error: Syntax error During implicit…