FYI...here is what the code looks like when I try to incorporate it.

select vw.whse_code, vw.item_code,  vw.qty_onhand, rh.date_rcvd

from incinvw vw, incinv1 v1, podinrh rh

where v1.lot_control_ind = 0

and rh.date_rcvd = (select...

Hi Steve,

When I add your suggestion into my code, it only selects 1 line for the item 402T and nothing for the 402 item.  I had tried something very similar...

Thank you.  I have been reading alot of Books online and getting ideas from the examples but it is difficult to try and put it all together and make it...

Hi Cyrille,

Thanks for the info.  After I read your post I realized that I was using the wrong column at the end.  It should have been a numeric column so...

Sorry SQLBill.  I didn't see your last post before I replied.  I think I do need to rethink this a bit.

Thanks for all the replies and at least get me...

Maybe I'm thinking about this wrong.  I need the query to return the number of rows that are older than two days.  So I would expect any rows that have...

The interesting thing is that it is not returning the correct amount.  I used:

SELECT

COUNT(*)

FFERPSQL.MVXTST.MVXJDTA.CJBCMD

Hi SQLBill,

The column is numeric(6,0) and the values are like this: 20070114 for Jan 14, 2007.

If I just use *, it will return all the rows.  I just...

Has no one run into this problem?  The install error said to rename the .manifest files and rerun the installer again.  I did a search of all the .manifest files...

Wow.  I used your suggestion and it did work great.  But I'm trying to do this using SSIS and I have an area in the Derived Column area but not...

I'm new to SSIS.  Where do I check that?  The max length of the column on the old legacy side or the new ERP table side?  I know that some...

Good Morning.

Thanks for the info.  I will look into it and get sp1 applied.

Isabelle

Hi,

Yes I am using 2005, service pack 1:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Developer Edition on Windows NT 5.2 (Build...

I couldn't either.  When I did a comparison for the values in sysobjects and sysindexes for my database, I saw that for the table owned by dbo there was a...

Thank you.  That worked.  What does the object_id(so.name) do that it causes other schemas not to show up?

Isabelle