Skip to Content
0

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

Mar 02 at 03:05 PM

39

avatar image
Former Member

/* 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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagarajan K Mar 03 at 01:46 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded