i have no problems executing that query, but it only returnes the last row from each table.
how would i be able to retrive all the rows?
ALTER PROCEDURE dbo.AccountTrakingSELECT
@.From smallDateTime,
@.To smallDateTime
AS
DECLARE @.VolID int
DECLARE @.TransactionID int
SELECT @.VolID = VolID, @.TransactionID = TransactionID FROM Transactions WHERE TransactionTime BETWEEN @.From AND @.To
SELECT * FROM Transactions WHERE TransactionID = @.TransactionID
SELECT VolFrstNameEN, VolLastNameEN FROM VolMain WHERE VolID= @.VolID
RETURN
GO
Quote:
Originally Posted by Cshrek
helo,
i have no problems executing that query, but it only returnes the last row from each table.
how would i be able to retrive all the rows?
ALTER PROCEDURE dbo.AccountTrakingSELECT
@.From smallDateTime,
@.To smallDateTime
AS
DECLARE @.VolID int
DECLARE @.TransactionID int
SELECT @.VolID = VolID, @.TransactionID = VolIDFROM Transactions WHERE TransactionTime BETWEEN @.From AND @.To
SELECT * FROM Transactions WHERE TransactionID = @.TransactionID
SELECT VolFrstNameEN, VolLastNameEN FROM VolMain WHERE VolID= @.VolID
RETURN
GO
hi
I am not clear with your code. try with this code .this is not exactly suit for ur requirement but this idea will help you
[code]
declare cur1 for select VolID from Transactions WHERE TransactionTime BETWEEN @.From AND @.To
open cur1
fetch next from cur1 into @.VolID
while @.@.fetch_status=0
begin
SELECT VolFrstNameEN, VolLastNameEN FROM VolMain WHERE VolID= @.VolID
fetch next from cur1 into @.VolID
end|||hey, thanks.
wehn i try to run that code:
----------------------------------
ALTER PROCEDURE dbo.AccountTrakingSELECT
@.From smallDateTime,
@.To smallDateTime
AS
DECLARE @.VolID int
DECLARE @.TransactionID int
declare cur1 for select VolID from Transactions WHERE TransactionTime BETWEEN @.From AND @.To
open cur1
fetch next from cur1 into @.VolID
while @.@.fetch_status=0
begin
SELECT VolFrstNameEN, VolLastNameEN FROM VolMain WHERE VolID= @.VolID
fetch next from cur1 into @.VolID
end
----------------------------------
it all seems to be good, but i get that error:
"Msg 156, Level 15, State 1, Procedure AccountTrakingSELECT, Line 22
Incorrect syntax near the keyword 'for'."
and i defently have no idea what is that mean? or what am i doing worng?
appriciate your help.sql
