I am trying to find out how to change the LANGUAGE property of the SQL Server Properties to British rather than it's current setting of English(United States).
I know how to change the default language for logins but when I check the 'Properties->General' for the Sql Server Group and my (local)...
I am deploying a commerce site and am in the test stage.
The commerce site worked fine but i needed to change
Currency References in order to match our back-office
system.
I am now getting the following error on the Order Creation
pipe:
*******************
Error Type:
Commerce.MessageManager...
That is perfect - i may be pushing my luck here but, further to your answer, how would i construct a sql statement that did the following:
Where ANY table has the field SECCODEID = 'abc123'
update SECCODEID to equal 'xyz321'
Don't quite know how to make thisa simple but here goes..
I have 2 tables, an order table 'orders' and stock table 'stock'
(fields used are: stock.product,stock.status, orders.product, orders.customer,orders.order_date)
I am trying to UPDATE a flag ('status')in the stock table depending on...
Iker -
I like the concept but cannot apply it to my actual fields (don't completely understand all syntax)
could you possibly use my actual table / field names:
table = scheme.stquem
fields = unit_cost, date_received, product
i know this sounds stupid, but when i attempted to change your...
If i have a purchase order table with many rows for the same product, how do i return the COST of a product based on the MAX of date_purchased - ie:
PRODUCT DATE_OF_PURCHASE COST
abc123 10-02-2003 21.20
abc123 25-05-2003 20.00
abc123 17-03-2003 22.60
abc123...
Hi royjimenez,
I don't need to REPLICATE, i need to COMPARE a live back-office database with a live CRM database then
UPDATE IF value in DB1.Field x <> value in DB2.Field x
WHERE DB1.unique = DB2.unique
Hi all,
I have 2 sql databases where 1 loads info from the other on scheduled jobs.
I am interested in investigating if there are comparison tools that allow me to compare things like stock tables - ie: DB1 TABLE 'stock' FIELD 'product' [where product = 'xyz' returns 23 , but
DB2 TABLE...
Any ways around this:
(i get a 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.' statement returned)
update account set seccodeid = (select seccodeid from...
Thanks you guys - both gave exactly correct SQL - works a treat at about 2000 times quicker than the original Crystal Report I had running to give me this :-)
Hi,
I want to do the following but can't decide / think what the simplest Sql statement would be to use:
I have an 'ORDERS' table with fields:
CUSTOMER,ORDER_DATE,PRODUCT
Data could look like this:
CUST1 03/01/03 ABC123
CUST1 17/03/03 ABC123
CUST1 23/11/01 XYZ321
CUST2 09/02/02...
That was it :-)
Just had to reverse the M columns - ie
M13 Then 0
M12 Then 1
M11 Then 2
....etc - That way it shows 2 for 2 months ago etc.
Cheers Mate !
I would like to be able to return the LAST populated column for a range of columns.
I have a table with columns:
CUSTOMER,PRODUCT,M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12
The Mx Columns represent the last 12 months and contains a qty (number).
What i would like to do is find the LAST month of an...
In a similar vein, i would also like to find the LAST month ordered:
Example Data:
M1 NULL
M2 NULL
M3 NULL
M4 NULL
M5 6
M7 3
M8 NULL
M9 10
M10 NULL
M11 NULL
M12 NULL
These are column headings so in the above example, i would like to have '4' returned - ie LAST ORDERED 4 MONTHS AGO (M9...
The problem is, how do I do this for multiple colums.
I have 13 columns - M1 -> M13 (these represent 13 months).
How would I count an occurence of non null data across these colums (for each row).
ie:
M1 NULL
M2 NULL
M3 12
M4 NULL
M5 6
M7 NULL
ETC...
I would like the value 2 returned (2...
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.