|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-12-12 : 10:45:56
|
| Not sure what this is error mean....SELECT Distinct CONVERT(varchar(10), [Effective Date], 101) AS [Effective Date], CONVERT(VARCHAR(10), [Termination Date], 101) AS [Termination Date], LEFT([Last Name],50) as [Last Name],LEFT([First Name,100]) as [First Name],LEFT([Middle Name],2) AS [Middle Name], LEFT(Ext,5) As Ext,LEFT([Degree],10) AS Degree,LEFT([Tax ID],9) AS [Tax ID], LEFT([Spec 1],30) AS [Spec 1],LEFT([Spec 2],30) AS [Spec 2], LEFT([Spec 3],30) AS [Spec 3],LEFT(Practice,75) as Practice,LEFT([Address 1],75) as [Address 1],LEFT(City,25) AS City, LEFT(St,2) as St, Left(Zip,10) as Zip, LEFT(Phone,12) AS Phone, LEFT(COUNTY,25) as County, left( [Billing Name],50) AS [billing name], LEFT([Billing Address],50) as [Billing Address], LEFT( [Billing City],25) as [Billing City], LEFT([Billing Zip],10) as [Billing Zip], LEFT([Billing St],2) as [Billing St], LEFT([Fee Schedule],2) as [Fee Schedule], LEFT(ID,11) as IDFROM vw_monthEndProvider |
|
Error - The left function requires 2 argument(s).