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

    Key constraint issue

    No, it produces the same error. I tried it with some test data that I set up and it works fine. It is failing on a particular set of data (a clients monthly db update). Oh, duh, just found out the reason while explaining the problem. Table2 does not use an index and contained duplicates...
  2. DomTrix

    Key constraint issue

    I should elaborate, sorry for double post, cant seem to be able to edit posts. It was a typo in the post, that is not what is producing the error. Thanks, DT
  3. DomTrix

    Key constraint issue

    ah yes, typo, should be: INSERT INTO table 1 SELECT table2.code, table2.name FROM table2 WHERE NOT EXISTS ( SELECT table1.code FROM table1 WHERE table1.name = table2.name )
  4. DomTrix

    Key constraint issue

    Hi, I have two tables both containing data under the same column headings and types, code and name. The name column is a unique index with an insert and update constraint. I am trying to insert data from table2 to table1 when the data does not already exist in table1 but am getting a unique key...
  5. DomTrix

    Return column names in one column of a query

    Yah, that would bring out results like: col1 col2 col3 col4 4.5 2.3 6.7 2.6 I needed results like colName average 'col1' 4.5 'col2' 2.3 'col3' 6.7 'col4' 2.6 Can be achieved with a union: SELECT avg(col1) as average, 'col1' as colName UNION ALL SELECT...
  6. DomTrix

    Return column names in one column of a query

    I mean UNION!! dumb day
  7. DomTrix

    Return column names in one column of a query

    DOh, ignore me, I can use COLLATE of course
  8. DomTrix

    Return column names in one column of a query

    Hi there, I have a table with 8 integer columns and I want to return the average value for each column in a single query. I can do it easily enough with 8 columns but I would like the query to contain only two columns, 'columnName' and 'average'. Is this possible? Thanks, dom
  9. DomTrix

    Static variables

    Oh i see, great thankyou
  10. DomTrix

    Static variables

    Ok thankyou, I am new to anything but SPs and general db design. Could you give me an example of how I might implement this (or soewhere where there is an example, can't find anything on google or here)? Would the UDF need calling to define the variable...? DT
  11. DomTrix

    Static variables

    How can you set static variables in enterprise manager? I think 'static variables' is the correct term. Basically, I would like to do something like: SELECT blah FROM tableBlah WHERE blahID = @@myStaticBlahID Can I create and set these @@ variables in EM? Thanks in advance DT
  12. DomTrix

    Access db to SQL

    Great thankyou, a user would still need to open up access to do this though wouldn't they?
  13. DomTrix

    Access db to SQL

    Yes kinda, the client should initiate the process. I.e. it is not viable to have it on a scheduled time, it must be 'triggered' by the client's action. Thanks, DT
  14. DomTrix

    Access db to SQL

    Would it be possible to trigger a DTS package? There is no definate schedule for it and there may be several updates in a month. There will be no technical person involved, the entire process must be initiated and controlled by the non techie client.
  15. DomTrix

    Access db to SQL

    We have setup an online shop for a client and are using a SQL server database for all their stock, etc. They receive a monthly stock update from there main supplier which is stored in an access db on their pc's at their bricks and mortar shop. I am looking to the most efficient way of updating...
  16. DomTrix

    CONTAINS or FREETEXT

    Yeh, I realise that it ignores them, I just think that sometimes they are important, i.e. creating a ranked list for a phrase. But I'm sure there are good reasons. Interestingly, if I put in "Sometimes the world is tough", I will get a match for a title 'Sometimes the world is tough', not...
  17. DomTrix

    CONTAINS or FREETEXT

    Being ordered by Rank. Ok the noise words makes sense although in searching for a title I would have thought noise words matter, especially when included in a phrase (as in this case). I guess Ill have to live with it. Thanks
  18. DomTrix

    CONTAINS or FREETEXT

    Not sure which to use and am finding the results they produce a little confusing. They are being used to search fields in a database. The fields are title, author and publisher. At present, using both freetext and contains, i put in a search for the title 'What on earth' and each time the...
  19. DomTrix

    Automatially submit a form

    thanks satire, its not as we're not in the U.S. but thankyou for your help anyways.
  20. DomTrix

    Automatially submit a form

    The problem I am having is that the "Instant PN" is taking, at last count, 45 mins+ (in the sandbox). Not to friggin useful if you are trying to test it and continue develoing dependant on its results! Tried calling them: "call us back in 2-3 hours". Anyways, this isnt a paypal hate forum :p...

Part and Inventory Search

Back
Top