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

    Reorder records

    Hello, Lets say I have a table that looks like this: ID | DisplayOrder | UserName --------------------------- 1 | 3 | Bob 2 | 1 | Tom 3 | 6 | Claire 4 | 5 | Sally 5 | 2 | John 6 | 4 | Tim And I query the table and...
  2. loydall

    Query must include "THIS" but also one of....

    Hello, I want to be able to query a table so that the results MUST contain a phrase, for example "This is my house" but must also include one or more of the following: "this is my dog" or "this is my cat" or "this is my goat" So, MUST include "This is my house" and MUST include AT LEAST...
  3. loydall

    Get ID of record just BEFORE you insert it

    OK - Getting the ID of the record I just inserted is fine but I need to insert a user record where the username is made up of the record id: MyCompany012 Or something like that. I could insert the record, grab the ID and then update the username but then I have to figure out a unique username...
  4. loydall

    A quickie - SELECT INTO

    Hello, Here's a table (TableA): ------------ id | name | ------------ 1 | bob | 2 | john| 3 | tom | 4 | tim | and here's another table (TableB): --------------------- personId | language | --------------------- 1 | Eng | 2 | Eng | 3 | Eng | 4...
  5. loydall

    Check for existence of foreign key

    Hi - I need to delete a foreign key programatically but, obviously, only if it exists. I'm in MS SQL Server 2005. I need to delete a Foreign called fkUserRoleID on a table called tblUsers. Any ideas? Thanks.
  6. loydall

    UPDATE Every record in column but group by,,

    Hi, Let's say my table looks like this id | groupName | pNumber ------------------------ 1 | 1 | 1 2 | 1 | 1 3 | 1 | 1 4 | 2 | 1 5 | 2 | 1 6 | 3 | 1 7 | 3 | 1 8 | 3 | 1 I want to update pNumber so...
  7. loydall

    Search on a phrase returning similar values

    Hi - lets say I have a table of people. Each person has a description. I have set up a full text index on the description column. Now - I want to search that column. How do I search using a phrase alowing for slight variations in what the user might enter? Bearing in mind that the results MUST...
  8. loydall

    Install full text indexing on 2005

    Hi - I've got 2005 developer edition. I installed it a while ago but now want to intall full text indexing. How do I actually install that? I go through the set up and select to install it but it then goes on to say that I can't install it.. How do I install full text indexing as an aditional...
  9. loydall

    Select * from table that aren't in another table

    Yes - thanks for your help, I know it's not ideal but unfortunately it's the only data I have to play with.. You solutions worked... thanks..
  10. loydall

    Select * from table that aren't in another table

    Hello - I have 2 tables. table1 contains a list of people. Table2 contains a list of poeple made up of SOME of the people from table1.. (So table1 has more records than table2). I need to select all the people from table1 that ARE NOT in table2.. I will be selecting using FirstName and...
  11. loydall

    Multiple e-mails from a database

    Hello, I've built a recruitment site, new jobs can be added by authorised users, job seekers can search the database and submit there cv's etc. I need to create a system where any new jobs entered into the database are matched against cv's and details of the jobs (a link to the job detail page)...
  12. loydall

    unable to create remote folder_mmDB Scripts?

    Hello, I'm trying to create a connection to a database on a remote server. The hosting company has created the dsn on their server but when I try to create a connection in ultradev I get the following message: Unable to create remote folder_mmDB Scripts. 550 Access denied. The connection works...

Part and Inventory Search

Back
Top