Home Forums SQL Server 2005 T-SQL (SS2K5) SubQuery returning more one record RE: SubQuery returning more one record
SwePeso
SSC-Dedicated
Points: 39752
More actions
January 31, 2008 at 6:52 am
#773723
Replace DISTINCT with TOP 1 in the correlated subquery.
N 56°04'39.16"E 12°55'05.25"