Posts by Otávio Augusto • 87 points
7 posts
-
0
votes1
answer38
viewsA: How to know which users have a photo in a folder via OPENROWSET?
The problem was solved through the trial: CREATE PROCEDURE FOTO_USUARIO @Codigo integer, @TipoPessoa integer, @FOTO VARBINARY(max) OUTPUT AS begin DECLARE @FILE VARCHAR(100); DECLARE @nome_usuario…
-
1
votes1
answer38
viewsQ: How to know which users have a photo in a folder via OPENROWSET?
I have a system where photos are stored in briefcase and not in the database. To save the photo file, the system uses the following standardization: Username: Otávio Augusto | Primary Key: 12345…
-
1
votes1
answer69
viewsQ: Treat a column of the same table twice and present as a record in the same column
Good afternoon Dear Friends, I am developing a report with some necessary standards, I will not delve into the standards for the query, but fact is that I "managed" to make a Query with the…
-
2
votes1
answer78
viewsQ: Concatenation of Records via FOR XML PATH - SQL SERVER
Good afternoon dear, I have the following problem: I am developing a Query where I need to verify which documents were delivered by the student, documents that are in the table pre_matricula_doc and…
-
2
votes3
answers3588
viewsQ: How to store more than one value in an "SQL variable"?
I work with a system that has a very limited report. The reports are basically restricted to one sql query. I need to present in a report a query that, in my query, is being informed by the user a…
-
1
votes2
answers301
viewsQ: Bring the records from one table according to the Where from another
I am new in the database area and I came across a situation that I do not know how to solve. Even though it seems (at least, rs) simple. Exists the table called dbo.FISICA and another call…
-
0
votes0
answers50
viewsQ: Bring the value of one column according to the condition of another
I am developing a simple script but I came across a situation that I am not able to solve it, I tried through CASE but without success. With a simple select I need to bring the columns Name, RG,…