-
Notifications
You must be signed in to change notification settings - Fork 1
/
ecProblemPS.sql
46 lines (45 loc) · 1.82 KB
/
ecProblemPS.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [AutoID]
,[vID]
,[RedBr]
,[ProID]
,[Kol]
,[Cena]
,[CSaPor]
,[Rabat]
,[Porez]
,[Tarifa]
,[Koef]
,[Realna]
,[Fakturna]
,[RabatFak]
,[Akciza]
,[Carina]
,[Naziv]
,[StaraCena]
,[StaraCenaSaPor]
,[StaraKol]
,[Trosak]
,[StvarnaKol]
,[CProdPrenos]
,[CProdPrenosBPor]
,[PDV]
,[ecBit]
,[PredznakParcijalneNiv]
,[PrenosRabat]
,[vPrenos]
,[MarzaPrenos]
,[Bruto]
,[Neto]
,[vJCI]
,[CenaUMoneti]
,[RokIsporuke]
FROM [Prokontik13].[dbo].[UlazIzlazDetalj]
where proid='1014887' --vid=10109853
order by autoid
select * from ulazizlaz where vid in (
10123352,--30219
10126904,--30510
10109853,--30001
10128714--30500
)