I want to update the price of items in the database. I am extracting a list of items from another list( of class type having other information also). After that I am sending it(item number) one by one as a stored procedure parameter to get the price updated.
But I am getting a Procedure or...
I work on SQL server 2012 .really I don't understand what statement below do updatedand when
when NullFlag updated
when conflict flag updated
can you explain to me according to sample below
result of query data details rows without grouping :
Masked_ID DocumentID PartID NULLCount...
How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ?
I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1
as example below I have two rows have Flag Allow=1
family 90AM will be family 90 and family unit AM on two column...
I need to call a stored procedure in one method to get the data and display it in one column of html table. the rest of columns are displayed by another methods and actionresults. (it's a mvc repository application). right now I can show the result of stored procedure in grideview, each column...