.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links


Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server


I have a table variable @temp

When i am selecting records from @temp it is working fine but when i am using it in a join statement , i am getting an error as

"Must declare scalar variable @temp"


select @CorporateID=CorporateID,@PaymentRef=PaymentRef from @temp Inner join TopUp On TopUp.AutoID=@temp.TopUpID

Thanks and regards, Rishabh

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend