How Declare.. I''ll DO Deeeeclare :)
-
Hello,
I am tring to work this out in Analyzer, however, not working out for me.
I am tring to make a double select and test in analyzer but i am getting error near declare
sos......
ALTER PROCEDURE a_Get_Information_For_Datalist_Global_test
declare @IDCompany int , @IDProduct int
set @IDCompany = 20,
set @IDProduct = 77
AS
SELECT Product.ProductName,
Product.ProductID,Product.ProductImage,
Product.ProductDescription, SprocsTable.*
FROM
INNER JOIN
SprocsTable ON Product.ProductID = SprocsTable.ProductID
WHERE Product.ProductID = @IDProduct
GO
SELECT Company.CompanyID, Company.CompanyName
FROM COMPANY
WHERE COMPANY.COMPANYID = @IDCompany
Dam again!
-
I DID DECLARE
I got it..
declare @IDProduct int
set @IDProduct = 77
SELECT Product.ProductName,
Product.ProductID,Product.ProductImage,
Product.ProductDescription, SprocsTable.*
FROM Product
INNER JOIN
SprocsTable ON Product.ProductID = SprocsTable.ProductID
WHERE Product.ProductID = @IDProduct
GO
declare @IDCompany int
set @IDCompany = 20
SELECT Company.CompanyID, Company.CompanyName
FROM COMPANY
WHERE COMPANY.COMPANYID = @IDCompany
Dam again!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply