CODEWITHSUNDEEP
sql-servernvarcharbigint
Justin
Justin

Reputation: 131

Left join - nvarchar/bigint

I'm in the last stages of building a report and I've run into this error:

Error converting data type nvarchar to bigint.

I suspect this is to do with the LEFT JOIN i am using, I am just trying to get the Label field from this table, nothing else. 

  LEFT JOIN [taxonomies_taxonomy_entry]
  ON [era_account_details].[sector] = [taxonomies_taxonomy_entry].[taxonomyentryid]

 [taxonomies_taxonomy_entry].[label] AS [Industry]

I am trying to select out the label field which is a nvarchar field.

The LEFT JOIN uses:
[era_account_details].[sector] = nvarchar
[taxonomies_taxonomy_entry].[taxonomyentryid] = bigint

Any advice?

Many thanks,

Upvotes: 0

Views: 2662

Answers (1)

Joakim M
Joakim M

Reputation: 1803

Could this do the trick?

CAST([taxonomies_taxonomy_entry].[taxonomyentryid]  As nvarchar(500))

Upvotes: 4

Related Questions