thanks!

talked to a programmer and found the other 2 fields in a table that I don't need, but will try to join in anyway and see if it works.

patrickmcginnis59 (6/28/2012)

---

In order to you to just use the first row, you'll have to give some ordering criteria to let SQL know what constitutes the order of the rows of...

Thank you, I am trying out the Cross Join now. Of course, I was told there would only be 1 row in the database and there are actually 10....

SQLKnowItAll (3/8/2012)

---

Change this:

SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

FROM SalesTransactionDtl

INNER JOIN WarehousePickingGroup

ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

To this:

SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

FROM SalesTransactionDtl

INNER JOIN WarehousePickingGroup

ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

AND...

No, I did not know the difference. I changed it to a LEFT and now I get too many rows! It is still doing the same thing, where...

Well of course the data wasn't correct! It wasn't returning enough rows, so I am narrowed it down and found one of the issues and I can't figure out...

I am only using test data right...

SQLKnowItAll (3/7/2012)

---

When you alias the table as something like ter5, you have to make sure that is the alias used in the join (change ON ter.colname = sth.columnname to ON...

Ok, well this is fun! :w00t:

I have gone through them all and found the culprit. While trying to debug, I have found that some of the columns that are...

Sorry!

When I view the first 1000 rows of data in SQL Server, every row is exactly the same, which isn't what I expected. Same data in every field for...

Well I got this working, but it looks like the data isn't correct 🙁

the first 1000 rows are all the same...

Any ideas?

Here is the view, same as yours Jared, just...

Thanks for all the help, if we have more issues maybe my company can hire Jared! The other consultant was specifically for Talend and I'm not sure that he...

Funny thing is, a consultant did create that! I was hired to create reports based off that view. They have created a non-normalized table based off this view so...

Thanks Jared!

That fixed that error and now I am getting another one...

Msg 512, Level 16, State 1, Line 2

Subquery returned more than 1 value. This is not permitted when the...