December 21, 2011 at 8:34 am
When i run this Query i get the error below i cannot see what wrong.
may someone help?
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "a.CustomerID" could not be bound.
SELECT a.TransactionNumber ,
a.StoreID ,
a.Transaction_Date ,
a.CustomerID ,
a.StoreName ,
a.LogicalStoreName ,
a.ItemLookupCode ,
a.Description ,
a.ClassID ,
a.Quantity ,
a.FullPrice ,
a.Full_Cost ,
a.SalesRepID ,
a.Name ,
a.Ship ,
b.EmailAddress ,
b.PhoneNumber ,
b.FirstName ,
b.LastName ,
b.HQID
FROM dbo.SalesReportRMS AS a ,
[10.1.1.18\RMS20].ICLHQ.dbo.Customer AS b
JOIN [10.1.1.18\RMS20].ICLHQ.dbo.Customer ON b.HQID = a.CustomerID
WHERE a.Transaction_Date BETWEEN 'dec 1 2011 17:00:00'
AND 'dec 1 2011 23:59:00'
AND a.StoreID IN ( 40, 5, 10, 13, 14, 19, 23, 24, 30, 31, 28 )
December 21, 2011 at 8:39 am
Slightly unusual syntax. Try this
SELECT a.TransactionNumber ,
a.StoreID ,
a.Transaction_Date ,
a.CustomerID ,
a.StoreName ,
a.LogicalStoreName ,
a.ItemLookupCode ,
a.Description ,
a.ClassID ,
a.Quantity ,
a.FullPrice ,
a.Full_Cost ,
a.SalesRepID ,
a.Name ,
a.Ship ,
b.EmailAddress ,
b.PhoneNumber ,
b.FirstName ,
b.LastName ,
b.HQID
FROM dbo.SalesReportRMS a JOIN
[10.1.1.18\RMS20].ICLHQ.dbo.Customer b
ON b.HQID = a.CustomerID
WHERE a.Transaction_Date BETWEEN 'dec 1 2011 17:00:00'
AND 'dec 1 2011 23:59:00'
AND a.StoreID IN ( 40, 5, 10, 13, 14, 19, 23, 24, 30, 31, 28 )
December 21, 2011 at 8:40 am
Thank you, i think i am losing my skills!!
December 21, 2011 at 8:40 am
Does this help?
SELECT
--FROM SalesReportRMS
a.TransactionNumber, a.StoreID, a.Transaction_Date, a.CustomerID, a.StoreName,
a.LogicalStoreName, a.ItemLookupCode, a.Description, a.ClassID, a.Quantity, a.FullPrice,
a.Full_Cost, a.SalesRepID, a.NAME, a.Ship,
--FROM [10.1.1.18\RMS20].ICLHQ.dbo.Customer
b.EmailAddress, b.PhoneNumber, b.FirstName, b.LastName, b.HQID
FROM dbo.SalesReportRMS AS a
JOIN [10.1.1.18\RMS20].ICLHQ.dbo.Customer b ON b.HQID /*[10.1.1.18\RMS20].ICLHQ.dbo.Customer*/ = a.CustomerID /*SalesReportRMS*/
WHERE a.Transaction_Date BETWEEN 'dec 1 2011 17:00:00' AND 'dec 1 2011 23:59:00' AND a.StoreID IN (40, 5, 10, 13, 14, 19, 23, 24, 30, 31, 28)
--EDIT--
Arrgh, way too slow
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy