quote:

---

Msg 1038, Level 15, State 4, Procedure LeadsImport, Line 29
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

---

        INSERT INTO [dbo].[Prospect] (
			[creationDate],
			[title],
			[firstname],
			[lastname],
			[hseNoStName],
			[address1],
			[town],
			[county],
			[postcode],
			[email],
			[allow_email],
			[allow_tel],
			[callBackTime],
			[source],
			[gender],
			[notes],
			[consPeriod],
			[consWhen],
			[procedure],
			[infoPackSent],
			[infoPackRequested],
			[UcFname],
			[UcLname],
			[UcPcode],
			[leadID],
			[nextAction],
			[actionDue] )
        SELECT 
			p.[Date_added_dt],
			[dbo].[InitCap](p.[Title]),
			[dbo].[InitCap](p.[Firstname]),
			[dbo].[InitCap](p.[Lastname]),
			[dbo].[InitCap](mid([dbo].[TRIM]([dbo].[TRIM](p.[House]) &" " & [dbo].[TRIM](p.[Address1])))1,60)),
			[dbo].[InitCap](mid([dbo].[TRIM]([dbo].[TRIM](p.[Address2]) & " " & [dbo].[TRIM](p.[Street])),1,60)),
			[dbo].[InitCap](p.[Town_City]),
			[dbo].[InitCap](p.[County]),
			UPPER(p.[PostCode]),
			p.[Email],
			p.[Allow_email],
			p.[Allow_tel],
			p.[Callback_range],
			ISNULL(p.[Source],"Web Site"),
			CASE p.[Sex] WHEN  "Male" THEN "M" ELSE NULL END,
			p.[Further_info],
			p.[Cons_period],
			p.[When],
			p.[Procedure],
			p.[Info_pack] = "Email",
			p.[Info_pack] = "Post",
			p.[UcFname],
			p.[UcLname],
			p.[UcPcode],
			p.[leadID],
			CASE 
				WHEN p.[consultation]="yes" THEN 2
				WHEN p.[Info_pack]="Post" THEN 4
				ELSE 1
			END ,
			p.[date_added_dt],
        FROM ( 
			SELECT 
				p.*
			FROM [dbo].[#WebsiteLeads] p
			INNER JOIN (
				SELECT 
					MAX([leadID]) as latestLeadID,
					[UcFname],
					[UcLname],
					[UcPcode]
				FROM [dbo].[#WesSiteLeads] 
				GROUP BY [UcFname], [UcLname],[UcPcode]
			)  W 
			ON p.[leadID] = W.[latestLeadID]
        ) AS p
        LEFT JOIN [dbo].[Prospect] 
        ON 
			p.[UcFname] = [dbo].[Prospect].[UcFname]
			AND p.[UcLname] = [dbo].[Prospect].[UcLname]
			AND (Coalesce(p.[UcPcode],"") = "" OR p.[UcPcode] = [dbo].[Prospect].[UcPcode] )
        WHERE [dbo].[Prospect].[UcFname] IS NULL AND [dbo].[Prospect].[UcLname] IS NULL;

quote:

---

Originally posted by vaibhavktiwari83

Symbol " is not accepted in SQL use ' instead.

Vaibhav T

If I cant go back, I want to go fast...

---