-
Notifications
You must be signed in to change notification settings - Fork 19
/
Copy pathUSERGLA_USERGLI.sql
23 lines (22 loc) · 1021 Bytes
/
USERGLA_USERGLI.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SELECT TOP 10
SUBSTRING(F2_USERLGI, 3, 1)+SUBSTRING(F2_USERLGI, 7, 1)+
SUBSTRING(F2_USERLGI, 11,1)+SUBSTRING(F2_USERLGI, 15,1)+
SUBSTRING(F2_USERLGI, 2, 1)+SUBSTRING(F2_USERLGI, 6, 1)+
SUBSTRING(F2_USERLGI, 10,1)+SUBSTRING(F2_USERLGI, 14,1)+
SUBSTRING(F2_USERLGI, 1, 1)+SUBSTRING(F2_USERLGI, 5, 1)+
SUBSTRING(F2_USERLGI, 9, 1)+SUBSTRING(F2_USERLGI, 13,1)+
SUBSTRING(F2_USERLGI, 17,1)+SUBSTRING(F2_USERLGI, 4, 1)+
SUBSTRING(F2_USERLGI, 8, 1) Usuario_CRIAÇÃO
FROM SF2010
ORDER BY R_E_C_N_O_ DESC
SELECT TOP 10 F2_DOC,
SUBSTRING(F2_USERLGA, 3, 1)+SUBSTRING(F2_USERLGA, 7, 1)+
SUBSTRING(F2_USERLGA, 11,1)+SUBSTRING(F2_USERLGA, 15,1)+
SUBSTRING(F2_USERLGA, 2, 1)+SUBSTRING(F2_USERLGA, 6, 1)+
SUBSTRING(F2_USERLGA, 10,1)+SUBSTRING(F2_USERLGA, 14,1)+
SUBSTRING(F2_USERLGA, 1, 1)+SUBSTRING(F2_USERLGA, 5, 1)+
SUBSTRING(F2_USERLGA, 9, 1)+SUBSTRING(F2_USERLGA, 13,1)+
SUBSTRING(F2_USERLGA, 17,1)+SUBSTRING(F2_USERLGA, 4, 1)+
SUBSTRING(F2_USERLGA, 8, 1) Usuario_ALTERAÇÃO
FROM SF2010
ORDER BY R_E_C_N_O_ DESC