Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using a variable from a select statement

Status
Not open for further replies.
Jun 10, 2004
3
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top