tkilgallen
MIS
I am looking to set a variable in SQLTalk to be used in the where clause of my actual sql statement. I have it working in SQL Server using the following:
DECLARE @latestentry datetime
Select @latestentry = MAX(StartDate) From Start
Select SubscriptionID, StartDate
From Start
WHERE StartDate = @latestentry
Anyone know how I can do this in SQLTalk? I looked at bind variables but can't use a select statement to update the variable.
Thanks - Tom
DECLARE @latestentry datetime
Select @latestentry = MAX(StartDate) From Start
Select SubscriptionID, StartDate
From Start
WHERE StartDate = @latestentry
Anyone know how I can do this in SQLTalk? I looked at bind variables but can't use a select statement to update the variable.
Thanks - Tom