question

Chancefichterjet avatar image
Chancefichterjet asked

Keep getting this answer for a query I'm trying to run = "Conversion failed when converting from a character string to uniqueidentifier"

Here is the Query "select count(distinct thor.PickTicketId) as 'Shipments', ActualShipMethod from thor.prod.PickTicketDetail thor inner join flashbidata.bi.order_items_mart flash on thor.MerchantOrderId = flash.merchant_order_id where slowdown_config_shipping_cost > 0 and ShippedDate >= '08-01-2018' group by ActualShipMethod order by 1 desc"

query
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
jasmy avatar image
jasmy answered

Please make sure that you are matching the same datatype in inner join and where clause.

,

in this query either in the inner join or in the where clause you are matching Character data and unique-identifier column. Please make sure the data types

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.