Comments by Atanu Ghosh

Atanu Ghosh 18-Jun-15 5:44am View

ok. can you give me some idea about how to get the current image id. Thanks!!

Atanu Ghosh 10-Mar-15 23:00pm View

I have fixed that. Thanks a lot for your help :)

Atanu Ghosh 10-Mar-15 21:37pm View

For the same ItemBatchNumber SerialNumber should be same for a day. Suppose on 03/10/2015 for WB101 Itembatchnumber generated SerialNumber is 'xyzB1'. So it should be stick to 'xyzB1' if I choose WB101 again on 03/10/2015. Instead of that its generating as 'xyzB2' if I choose same ItemBatchNumber on same day.

Atanu Ghosh 9-Mar-15 10:23am View

Sorry for late response

Atanu Ghosh 9-Mar-15 10:22am View

What's the function of @serialnumber1 and @count here??

Atanu Ghosh 2-Mar-15 21:28pm View

I have edited ques. Please go through it. still I am not getting expecting result. Please help.

Atanu Ghosh 1-Mar-15 13:19pm View

I am getting error while executing stored procedure: Conversion failed when converting the varchar value 'R' to data type int.

Atanu Ghosh 1-Mar-15 12:24pm View

yes I have to store it. But for now I just have to show the generated SN it. I am thinking of creating a column 'Serial Number' on ItemMfg table to store the generated SN.

Atanu Ghosh 1-Mar-15 10:20am View

yes Item Type is single character like 'r',b,s. So its data type should be char right? I am facing problem on how to increment the value of fifth digit checking with dates when next different item batch number of a same item type or different item type is used. Please help.

Atanu Ghosh 1-Mar-15 10:19am View

Deleted

yes Item Type is single character like 'r',b,s. So its data type should be char right? I am facing problem on how to increment the value of fifth digit checking with dates when next different item batch number of a same item type or different item type is used. Please help.

Comments by Atanu Ghosh (Top 10 by date)