Posts by Miguel Meireles • 137 points
6 posts
-
2
votes1
answer194
viewsQ: Script to determine a desired column
Good morning! I’m trying to make a script where doing 2 joins, it shows me 3 columns. I mean, what I want is to get the email do lider. However it does not have a specific column, it is inserted…
-
0
votes1
answer342
viewsA: Msg 207, Level 16, State 1 and Msg 4413, Level 16, State 1 error
To solve the problem, we only had to do these two steps, as follows: - Attach the Reasons table to the Complaints table. Inner Join Motivos M on R.IDMotivo = M.Id And in the view design add also…
-
2
votes1
answer342
viewsQ: Msg 207, Level 16, State 1 and Msg 4413, Level 16, State 1 error
When I try to execute the following query, these two errors appear to me: Msg 207, Level 16, State 1, Procedure V_RECLAMACOES, Line 3 [Batch Start Line 0]Invalid column name 'Reason'. Msg 4413,…
-
2
votes3
answers1018
viewsA: Convert to date type 'yyyy-mm-dd'
I figured out the mistake. The error would be in the code part: convert(datetime, R.Data) ISNULL(convert(nvarchar(50),DataConclusao) And the solution to the same is: convert(char(10), R.Data)…
-
4
votes3
answers1018
viewsQ: Convert to date type 'yyyy-mm-dd'
I have a problem trying to modify the type of date that appears to me in two columns of a table of mine. This is my code: declare @top10reclamacoes varchar(max) declare @html varchar(max) declare…
-
1
votes2
answers1011
viewsQ: Msg 8114 error in SQL Server while performing query
I’m having a problem executing a query in the SQL Server, where I try to bring a column with a conversion of done in a column like DATE and another column with an HTML code mounted. Follow the query…