Posts by Lucas Lira • 41 points
7 posts
-
1
votes0
answers51
viewsQ: Customer SELECT with payment for the last two months (60 days)
I have a TBCLIENTS table where I have the columns: NAME, DATA_PAGAMENTO, FORMA_PAGAMENTO. I need to know the customers who paid in the last 2 months (60 days) in the form of payment BOLETO. How I…
-
0
votes0
answers65
viewsQ: Connection with two banks in c#
I need to connect to two types of databases, namely: Oracle and Postegre. I need to go to Oracle, generate a spool with some queries and upload this spool in Postegre. Is it possible to do this in…
-
-2
votes1
answer40
viewsQ: SQL Server Query
can help me with this consultation? CREATE TABLE Region ( idRegion INT PRIMARY KEY IDENTITY(1,1) ,cdRegion VARCHAR(50) ) CREATE TABLE Store( idStore INT PRIMARY KEY IDENTITY(1,1) ,cdStore…
-
0
votes1
answer41
viewsQ: SQL Server Order Allocation
It is possible for me to relocate this latest product with ID 21, to the field I have drawn in red? Actually, look at that. It is not by TOC, but something functional, in our site where it is taking…
-
-2
votes3
answers47
viewsA: Sql return generation limit
Good afternoon, but in case, it wouldn’t help, because if you see in WHILE, it goes from zero to 670, there are intervals.…
-
0
votes3
answers47
viewsQ: Sql return generation limit
I have this code, which generates number of periods, but I take this return to excel, I can define the amount of returns? I could only bring five, returns, I can limit? DECLARE @serie INT, @ordem…
-
2
votes2
answers209
viewsQ: SQL server random numbers
In this code only returns a value, I need a list of values, as I do? declare @letras varchar(max) = 'ABCDEFGHIJKLMNOPQRSTUWVXZ1234567890' declare @tamanho int = 10 ;with cte as ( select 1 as…
sql-serverasked Lucas Lira 41