Thanks litz for ur time

may be i am unable to explain my self so i have updated my question with an example. Please check it

Did you use vb.Net to develop a Web-Frontend or is it a client based solution?

Its not web-front end its client based (windows form application)

What online functionality will you provide (full...

sorry for incomplete data

front end = vb.net

database = sql 2012 (express edition) for client end

need to connect my desktop application so that it can input data online...

i have tired that but it is still showing me items

any other ideas

ok i will try to make it simple

there are 2 tables

1 tb_item

2 tb_item_cost_ledger

tb_item has all the items in it

tb_item_cost_ledger has running stock information in it with dates

the stock...

wow 🙂 that worked well

thanks for the help bro

thanks for the reply

yes i have checked it and it adds constraints but no triggers or indexes.

and this is a create method i cant create a new table and...

ok steve i will impliment and test it and will let u guys know the results

if u get any other ideas kindly let me know thx

Lovell and alzdba thx for the replies and priceless suggestions

lovell i will be removing the cursor and will go for the set based operation but for the last suggestion...