I have got the answer for my query.

please see the thread on following link.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173784

Thanks,

Furrukh

Hi,

I want to see result as follows

PART_NO REPLACEMENT_LIST

999

123

456 123

789 999

777 ...

I would hope following will work.

This will always keep one item line in allocationtable by deleting the old row and keeping balance uptodate.

declare @AmountToBeAllocated as decimal(18,2)

declare @decimal18 as decimal(18,2)

declare @bigint...

Well it seems to be connection / sql statement timeout error. I never had this error but I guess from the error description that connection is timing out.

I dont think...

This is the known issue that parametter can not be passed in any inner query or inside function call like DATEADD in your case.

I have faced same problem when passing...