Posted by SQL on 04/05/06 15:36

The code that you posted looks fine
When you run this

select Prefix
from Device
where Station_ID = @StationID

how many rows does it return?
Is it possible that the restored DB does not have all the data?


Denis the SQL Menace
http://sqlservercode.blogspot.com/

• Next in forum: Re: Problem concatenating column values into string...
• Prev in forum: Problem concatenating column values into string...
• Thread view: Re: Problem concatenating column values into string...

[Reply to this message]