Search results for query: *

Hi ! My "Clients" table contains among others the following fields: "Name", "Address", "ID", "Phone". The Primary key is set to none of these. I'd like each client to show only once in that table but this doesnt happen. Some clients' names appear twice or more an so the phone, id etc.. i want to...

Thanks a lot. I needed the 2 ways.

Hi ! a very basic question: I have a table in a database. I'd like to copy it to another database. how is it done ? [blush] Thanks !

Thanks a lot !

Hi my table contains 10000 lines. my second table contains 8000. i want to update 1st table's column "present" based on second table. i a person i 1st exists in 2nd table, 1st's "present" will get 1, else = 0. the code should be like: select a.present, b.name from first as a full join second as...

I 'll do that, i need to know a lot about dates[dazed]

Hi mutley1 ! I couldnt check the code but i'll do it tommorow and if i have troubles i'll tell you about it. But by now i can only thank you !

Hi mutley1 and thank you ! when i substract a date from another date i get a third date. I like to show an age. Something like: 31/12/2000-31/12/1920 = 80 by substracting someone's birthdate from today's date i want to know his age. Could you help me with that ?

Hi ! i'd like to calculate clients' ages whereby using today's date minus "birthdate" colomnn. Code should look like: select today()-mytable.birthdate "Age" from mytable where today()-mytable.birthdate < 80 evidently "today()" is wrong. Could any one tell me which function shows the "now" date...

Thanks a lot !

Hi ! Could anyone explain me how a word template is made ? I want my template to have a table (or few) and a certain font size/color at each location of that table. Thanks a lot !

Hi Catadmin ! Relating to your first question: This is not the case and the link you provided didnt relate to my problem. The problem is:table 1 contains 2 rows: Bob,Smith. Table 2 contains 200000 rows of which 50000 contain Bob as lastname and 100000 contain Smith as lastname. I only want Bob's...

Inner join didnt help either... Any idea how i can get 2 rows only ?

Seems i dont know how to use it. Hi ! I'm having 2 tables. The first one containes 2 rows which i get wherby importing a text file. It has all the information i need except Phone numbers. The other one contains 100000 rows and contains all the clients plus their telephones. I want to add table 1...

Thank you very much. I'll be using your instruction.

Thank you so much fellows ! I thought i'd need a week's time to learn it....

Hi ! I'd like someone to explain me something but i dont know what it is. An excel sheet is made of, say , 4 columns. Column 1 lists names of companies. Column 2: products. Column 3 location and 4th: price. Near the first cell of each column, there is an arrow situated next to the title...

Thank you ESguared. If i want to insert value to that datetime parameter, how do i do that: exec myProc '12-11-2006' or exec myProc convert(varchar,12-11-2006,110) could you help me with that please?

Very shamefull indeed but i couldnt find it anywhere...[blush] My stored procedure's parameter are of "datetime" type and it starts with: CREATE PROCEDURE myProc @start_d datetime(8), @end_d datetime(8) The error i get is: I guess the length is wrong. Someone saves me from that ?

hi ! i found a system table:"sysobjects" where the name of my table resides under "name" column. I implemented the code you sent on that table rather then on Information_Schema.Tables and it worked. Do you think that this is the solution? If that is the case do you still want me to find out...