Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WurzelGummidge

    Language Frustration

    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)...
  2. WurzelGummidge

    No help for this anywhere yet :-(

    ...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 (0x80004005) Language "STG" does not exist in this MessageManager instance...
  3. WurzelGummidge

    Finding Field Name in Multi Tables

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

    Finding Field Name in Multi Tables

    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'
  5. WurzelGummidge

    Finding Field Name in Multi Tables

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

    Tricky Select ...

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

    Tricky Select ...

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

    Get a value from MAX row

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

    Get a value from MAX row

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

    Concatenate a list into one string separated by commas

    Hi Shaleen, Try this: select Firstname + ' ' + Lastname + ',' as FullName from ........
  11. WurzelGummidge

    DB Comparison Tool

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

    DB Comparison Tool

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

    Subquery returned more than 1 value

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

    Maybe EXISTS, maybe not ?

    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 :-)
  15. WurzelGummidge

    Maybe EXISTS, maybe not ?

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

    Finding last Column of data in a row?

    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 !
  17. WurzelGummidge

    Finding last Column of data in a row?

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

    COUNTIF

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

    COUNTIF

    You got it man!!! Excellent - Thanks James
  20. WurzelGummidge

    COUNTIF

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

Part and Inventory Search

Back
Top