Bascially I want to UPDATE a particular column
Essentially I want to do the following:
ALTER PROCEDURE WriteStockStatus
(@asin varchar(10), @asinStockStatus varchar(15))
AS
UPDATE OnSale
SET StockStatus=@asinStockStatus
WHERE ASIN=@asin
Ok, but, I don’t want to have to call...
Bascially I want to UPDATE a particular column
Essentially I want to do the following:
ALTER PROCEDURE WriteStockStatus
(@asin varchar(10), @asinStockStatus varchar(15))
AS
UPDATE OnSale
SET StockStatus=@asinStockStatus
WHERE ASIN=@asin
Ok, but, I don’t want to have to call...
Hi,
I have an issue while trying to put in a formula...
all I need is for it to check if a field is < 0.0005 ...The problem I'm having is that Excel is reading the < as value rather than the less than symbol.
Any ideas on how to fix this?
I'm trying to write code for when the submit button is clicked and everything is filled in correctly, the filled out form will be sent to my job as an attachment. Do you have any idea how to do this? I'm
using the ASP server side language.
Hi,
I would like to know how to create a formula that would search for an asterisk *.
If I write:
=IF(ISNUMBER(SEARCH(""*"",A1)),"<myfield>","")
Excel treats the * as a special charecter
is there any way around this?
Thanks
Hi,
I have created a “submit” button on a form. When the button is clicked, I want the results to appear in a word document. Can I make this happen? If so, how? The form results display names for labels.
Hello,
Is there a fast way to delete defined names in an excel worksheet? I'd rather not go line by line in the defined name dialog box. Is there another way I can delete groups of defined names? They all start with "act".
Hi,
I have a query which pulls the number of people we serve by converting text to a integer via Cint(). The original value was #Served:23. The numbers after the colon were extracted and converted via the Cint() function. Now I am to create a report that contains a sum of that field.
Here is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.