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

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 !

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

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

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 !

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

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

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 delete a table using: drop table mytable If mytable exists then i get an error message. What should be the right code to delete a table if it exists ? Thanks !

Hi ! I'm searching a select statement to show my table in groups. Id like to show al members living in city: "a" and at the end of the list a number showing how many living in "A". Than city "B" and at the end the total of members. i wrote: select lastname, city, count(city) from mytable group...

Hi ! i want to operate arithmetic calculations on varchar data types. How do i transform it into numeric ? Thanks.

Hi ! An error message is appearing while adding data to tables preventing them from inserting data. ERROR Could not allocate space for object 'MYTABLE' in database 'MYDB' because the 'PRIMARY' filegroup is full. Could any one explain me what "filegroup" stands for? how i can allocate more...

Hi ! My table contains phone numbers. I want to show all the phone numbers but each number once only: select distinct phone from my phones but i get all the phones including few of each number. How do i write that distict to show me each number once only ? Phone number is not a primary key...

Hi ! Could any one tell me me please how do i make a copy of a line in a table, paste it to another table and then delete it from its old table ? Thanks !

Hi ! My code is such as: select phone from myphones if some tel. numbers show more than once, i want it to appear once only. Is that possible ? Thanks !

Hi ! I have a table with 2 columns: cola, colb. In cola i have alphabetic characters: "a", "b", "c"... and in colb i have digits: "1","2","3","4"... I'd like to display all the digits in colb that match a letter in cola : a 1, a 3, a 9.... one row per letter. Means, first row in my select query...

Hi ! I imported a table from a text file and got a numeric column as a varchar. I need to process arithmetic operations on the numbers of that column but i get an error message saying that arithmetic operations on a varchar column are impossible. How can i transform a varchar digit into a...

Hi ! I only found "import" menu item... I'd like to have a text file containing the excel data. Could anyone tell me if it is possible to export excel 2003 data to a text file and how it is done ? Thanks !

is that possible ? Hopefully yes ! If this is the case, can anyone kindly show me how to do that ? Thanks a lot !

Hi ! I'm having a "dateTime" column in a table. In order to get rid of "time", I transform it to a Varchar and then read 10 first characters only. But now i need the date to be in the format of: "dd/mm/yyyy" rather then its' contemporary format which is: "mm/dd/yyyy". Could anyone tell me please...