Using Select Top 1 To @ Variable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Using Select Top 1 To @ Variable

Author

Topic

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2003-07-07 : 13:48:36

This is prob. a simple Sintax error on my part.

I have a top 1 Select I wish to assign to a @var for later use but I cannot get the syntax right.

ALTER PROCEDURE dbo.Update_PPCheckinDates
(@job_number nvarchar(50))
AS
Declare @Art_film Varchar(50)

SELECT TOP 1 Recived_Date
FROM dbo.Prepress_checkin
WHERE (Checkin_item = N'Art Cust Copy Rec.' OR
Checkin_item = N'Art Cust Disk Rec.' OR
Checkin_item = N'Art Cust E-Mail Rec.' OR
Checkin_item = N'Film Customer Sup.' OR
Checkin_item = N'Film Outsource Rec.') AND (job_number = @job_number)
ORDER BY Checkin_Number DESC

''I wish to Set @Art_film = Recived_Date

Jim
Users <> Logic

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-07 : 13:53:15

SELECT TOP 1 @Art_film = Recived_Date
FROM dbo.Prepress_checkin
WHERE (Checkin_item = N'Art Cust Copy Rec.' OR
Checkin_item = N'Art Cust Disk Rec.' OR
Checkin_item = N'Art Cust E-Mail Rec.' OR
Checkin_item = N'Film Customer Sup.' OR
Checkin_item = N'Film Outsource Rec.') AND (job_number = @job_number)
ORDER BY Checkin_Number DESC

Tara

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2003-07-07 : 13:57:09

I thought I had Tried that.... must have typoed......OR monday morning after 4th Syndrom.....

Many Thanks Tara

Jim
Users <> Logic

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources