სერხიო,

სკრიპტის მიხედვით გავაკეთე შესაბამისობები.

პრობლემატურებს გიგზავნი ექსელის სახით და გავიაროთ

უშკა

Select Distinct Org.*

From [HESPERUS.DB].ncdc_hesperus.dbo.[CONTRACT]  c

Join [HESPERUS.DB].ncdc_hesperus.dbo.ORGANIZATION Org On C.ORGANIZATION_ID = Org.ID

Where 2014 <= Year(VALID_TILL)

       And c.ORGANIZATION_ID Not In (Select NcdcOrganizationID From _NcdcBillingProviders Where DateDeleted Is Null)

       And dbo.GetNcdcId(BUDGET_PROGRAM_SUBCOMPONENT_ID) In (

                                                                                                       Select S.OLD_ID

                                                                                                       From dbo.BL_BudgetHierarchy P

                                                                                                       Join dbo.BL_BudgetHierarchy C On C.ParentID = P.ID

                                                                                                       Join dbo.BL_BudgetHierarchy S On S.ParentID = C.ID

                                                                                                       Join dbo.BL_BudgetSummaries Summary On C.ID = Summary.BudgetHierarchyID

                                                                                                       Where P.ID = 'fabd4fb5-5580-4085-b0af-0833f7ed689a' --საზოგადოებრივი ჯანმრთელობის დაცვა - NCDC

                                                                                                              And Summary.[Year] = 2014 And Summary.IsApproved = 1 --იმისათვის, რომ მხოლოდ იმ კომპონენტების ხელშეკრულებები წამოღოს, რომელბიც დამტკიცებულია მოცემულ წელს

                                                                                                              And C.ID = '9bb1c15d-a8e4-45ba-bbcb-47c2ab799f3d'

                                                                                                       --Order By S.OLD_ID

                                                                                                )

       And c.ORGANIZATION_ID Not In (5807, 83)

       And Org.ID = 406    

Select Parent.TAX, Branch.*

From dbo.BL_Providers Branch

Join dbo.BL_Providers Parent On Parent.ID = Branch.ParentID

Where

       Parent.ParentID Is Null And

       Branch.OLD_ID = 406

პატივისცემით,

სერგო როსტიაშვილი

USAID-ის ჯანდაცვის სისტემის განმტკიცების პროგრამა