Viewing 7 posts - 1 through 7 (of 7 total)
Good day!
it duplicate results when i run this query below;
SELECT
ILE.[Entry No_]
,ILE.[Location Code]
,BAR.[Barcode No_] AS [Barcode No]
,ILE.[Item No_] AS [Item No]
,ILE.[Variant Code]
,IT.Description AS Description
,ILE.Quantity AS Quantity
FROM [BBI$Item...
May 25, 2023 at 11:32 pm
Good day!
is it okay if i share to you the sample data table via dropbox or google sheet.
thank you again
It's missing a comma at the end of line 6. ...
October 6, 2020 at 4:08 am
Good day!
thank you for reply
i run your query, but im getting this error;
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 19
Incorrect...
September 29, 2020 at 3:06 am
A couple of things
1. Opening an xlsx file is going to be a tough sell around here. Not a good practice.
2. Table aliases are essential for readable code. Please...
September 28, 2020 at 8:01 am
good day!
thank you for your reply
1. sorry, my mistake
2. well noted on this
3. i will try this, ill remove the where clause at the part of my query
again thank you
September 28, 2020 at 4:32 am
thank you very much scott arendt
September 7, 2020 at 7:19 am
thank you very much for your help
btw;
how can i not include the "0" (zero) from Total result
Thank you again
August 30, 2020 at 4:13 am
Viewing 7 posts - 1 through 7 (of 7 total)