Yes, correct

I am developing application in multi-user mode. In every screen there is header and detail part of transaction. if user1 is adding header part and detail part. but he has...

Table Structure

Create Table ##ItemMaster(Sys_Item_Num numeric (18,2), ImgFile image)

While modification, i what to check the uploading image is already in table or not.

how i can use DDL. how to check the uploading image is exist or not in table

this is my query. but the result is not retrieve correctly.

SELECT IM.Item_ID, datepart(dd,SH.Inv_date), sum(SD.Qty) S.PlanQty FROM

(SELECT PD.Item_ID, datepart(dd,PD.MDPDate), SUM(PD.Qty) FROM plan_det PD) AS S

WHERE S.Item_ID = IM.Item_ID AND IM.Item_ID...

I need to maintain opening balance and closing balance of inventory for each year and simillary opened Customer purchase Order and Job order should be posted to new year.

Inventory

For the...