Remote Support: SQL Server 2005 Error:, The multi-part identifier could not be bound

Log in Remote on GoToMyPc and resolve the following error.

The multi-part identifier "[url removed, login to view]" could not be bound

I get the following message.

---------------------------

Windows Internet Explorer

---------------------------

The multi-part identifier "[url removed, login to view]" could not be bound.

The multi-part identifier "[url removed, login to view]" could not be bound.

The multi-part identifier "[url removed, login to view]" could not be bound.

---------------------------

OK

---------------------------

It looks like the table names use a prefix of ERPSales_ where as the lookup from the .Net code is looking for ERPSales only. It looks like this should be modified so that the snytax matches. Which would be the best to modify the stored procudure or the .net code?.

See Atachement for Code Listing

## Deliverables

1) Solution or information leading to the resolution of the error described above.

## Platform

SQL Server 2005

Visual Studio 2005

Ironspeed 5.1.0

.NET ASP Γλώσσα Προγραμματισμού C# MySQL SQL Visual Basic

Ταυτότητα Εργασίας: #3168882

Σχετικά με την εργασία