Search results for query: *

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

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

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 )

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

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

I mean UNION!! dumb day

DOh, ignore me, I can use COLLATE of course

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

Oh i see, great thankyou

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

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

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

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

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.

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

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

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

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

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

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