Skip to Content
avatar image
Former Member

Hello Experts,We run this Stock Query many times a day and probably more than 50 times a week

/* SELECT FROM [dbo].[Owhs] T0 */
DECLARE @whs AS nvarchar(20)
/* WHERE */
SET @whs = /* T0.whscode */ '[%0]'

/* SELECT FROM [dbo].[Obin] T1 */
DECLARE @sublvl AS nvarchar(20)
/* WHERE */
SET @sublvl = /* T1.sl1code */ '[%1]'


exec stock_queryV2 @whs,@sublvl

The problem is it would be nice if it showed the Last Purchase Price after the Lot Number column.Many thanks Adrian




bzdco.png (21.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 03 at 01:46 AM

    Hi,

    You have share complete query to add new column in your query. To get query, login in SQL server management studio and look for stored procedure stock_queryV2.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded