Search results for query: *

Hello all and thanks for the help. At the moment I have a SQL UNION within a CTE as follows (simplified for the thread) ... WITH InvTrans AS ( SELECT po.unitQty AS qtyIn, po.POLineID FROM dbo.tblPOLine AS po LEFT OUTER JOIN dbo.tblPOLedger AS poL ON po.POLedgerID =...

Hi All, I was hoping to move our ASP.NET PasswordRecovery control functionality into a silverlight control that duplicates its process.Is there code behind or methods that can reproduce its functionality without too much heavy lifting? I was hoping to keep the user within the application...

Hi All, I was hoping to move our ASP.NET PasswordRecovery control functionality into a silverlight control that duplicates its process. Is there code behind or methods that can reproduce its functionality without too much heavy lifting? I was hoping to keep the user within the application...

Hi all and thanks for the assistance ... I'm trying to (logically) combine to tables for a total inventory count, then subtract items from a third table. I UNION two tables as such: /* Inventory Purchased Afloat */ SELECT unitQty AS qtyIn, POLineID FROM dbo.tblPOLine AS po...

Hi all, I have the following CTE query which I need to convert to a nested query. Any help in converting is appreciated. WITH InvAtA AS ( SELECT SUM(Lin.qty) AS qtyOut, Lin.POLineID, Led.locationID FROM dbo.tblTRLedger AS Led INNER JOIN dbo.tblTRLine AS Lin ON Led.TRLedgerID = Lin.TRLedgerID...

Thanks for the help. Here is the logic. I need a View that will return the total available inventory. This inventory is the logical difference from tblRDLine and tblRSTLine. In addition there is a lookup to determine a multiplier that normalizes the two numbers. The parts look basically...

Thanks for reading / helping. I need a bit of guidance in creating the proper table structure for the following ... I need a table to keep "blends" which I'm calling tblBlends. A blend will be made up of one or more items from the varietal table (tblVarietal with PK varietalID). Each blend...