Ok I found the solution - I think. I had to filter out the data in the column in .xls that was over 255 characters. Then modified data to...

Could there be special characters in the original file im trying to import causing this like "" < > etc, if so which characters should i be looking...

same error with nvarchar (max)

.xls file even changed varchar max, no luck

Thank You Jacob - Really appreciate it. I'll make sure to give proper sample dummy next time. -- Also thanks Ed!

Thank You J Livingston..you're code worked, Also thank you Luis while you're code worked I need to see what I am overlooking on actual table.

Thanks Luis, the last one appears straightforward, concatenation with fixed characters. However when I try on actual table without the # temp tables, i get incorrect syntax near...

Thanks Guys do you mean something like this, I'm trying to add t2.[Col A] to the first select query. Looks like running into error..

SELECT

...

Thanks Hugo & Eirikur Eiriksson again. The query below seems a bit easier to understand. Is there anyway to join tables T1 with T2, where EmailAddress from T1 is joined...

Thank Eirikur Eiriksson & Hugo & everyone else..appreciate you're help. Performance at this stage is a non issue.

Hugo, I got Incorrect syntax near ';' when I tried:

SELECT ...

Data comes that way. I can't normalize. I think this is analogous to an index match function from xls, which comepares one column against the other 3 columns then return...

Sorry that doesn't really help me. Can you put the complete query please?

Data won't be identical in both tables, that's why I'm trying to compare and identify when a match...

Hi Teri,

Let me try to clarify...

On a typical select query I would have:

select [term],[position],[value_per_month]

from [dbo].[XXXX]

where [term] like ='%something%' and [position] >0 and [value_per_month] >0

so what I wanted to do i...

Thank You Adam,

Do you mean like:

create procedure spFT

@term nvarchar (250),

@position int,

@value_per_month int

as

Begin

select [term],[position],[value_per_month]

from [dbo].[XXXX]

where [term]=@term and ([position]=@position) >=0

and [value_per_month]=@value_per_month >=0

End

Hello Dwain.C,

Yes, thank you for your last update, it was spot on.

I modified you're original query and added a column to No_Of_Words, for the column result set of mw, but...