Search results for query: *

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...

Thanks once again, simple, straightforward, works-first-time answers that we all hope for but much too often get over-complicated. EXCELLENT

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'

Is there a statetment that finds a field name (ie SECCODEID) in all the tables across a SQL DB ?

Hi Rocco, Sorry, yes - qty product sold, customer are in same table(stock). data like: stock table =========== code status A1 SP A2 SP A3 BTO A4 SP A5 YT . . order table =========== code customer ord_no date qty A1 WALLY 103 2003-01-01 6 A1 SMITH 123...

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 Shaleen, Try this: select Firstname + ' ' + Lastname + ',' as FullName from ........

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...

You got it man!!! Excellent - Thanks James

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...