Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE Print_CompanyDetails
- -- Add the parameters for the stored procedure here
- @DocKey@ int
- AS
- BEGIN
- -- SET NOCOUNT ON added to prevent extra result sets from
- -- interfering with SELECT statements.
- SET NOCOUNT ON;
- -- Insert statements for procedure here
- select @DocKey@ AS DocEntry, OADM.*, ADM1.*, DSC1.* from OADM INNER JOIN ADM1 ON OADM.Code = ADM1.Code
- LEFT JOIN DSC1 ON (OADM.DflBnkCode = DSC1.BankCode AND OADM.BankCountr = DSC1.Country)
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement