Search results for query: *

I have a Dell Inspiron 6400 and I recently was trying to clean all the unwanted softwares from my laptop. In the process I may have uninstalled either a program or a driver mistakenly. As a result, the DVD R/RW does not read DVD anymore. It still plays audio CD, but when I insert a DVD, it does...

Am I right in coming to the conclusion that there is no built in method for creating crosstab queries in MS SQL 2000? I have form the reference under "Pivot" in SQL books that demonstrates how to build your own but it doesn't account for scenarios where I don't know how many column headings I...

Earing Hold-Type Name Address $100 Address John Italy $100 DOB John Italy $50 Address Mike Canada $30 DOB Rose Dallas $30 Address Rose Dallas $200 Address Jenny New York My desired output: Earing Name Address $100 John "Hold" $50 Mike Canada...

I am trying to UPDATE a table and my syntax: Update table1 Set Name = "Held" where Name_Hold = 'Yes' OR Set Address = "Held" where Address_Hold = 'Yes' OR Set Phone = "Held" where Phone_Hold = 'Yes' is not working. Any help would be appreciated. Thanks

I have a simple query that runs against a DB2 database table with 200,000 rows of data. The table has about 10 columns. But my SQL query takes too long to run almost filling up the log. It is a simple logic. Can anyone suggest me anything I can do to make this any faster? My SQL is: delete from...

Does anyone know the SQL code to get Age from Date of Birth (YYYY-MM-DD)? Thanks

I have two tables: Table A Field 1 Field 2 3 A 5 D 5 E 6 A 6 B Table B Field 1 Field 2 3 A 5 A 5 B 6 C 6 D Now I want an output table that has fields from Table A where...

I have the following table ID No Color A 2 RED A 1 RED B 3 RED B 4 RED C 2 RED D 2 RED D 1 RED And my desired output Table A 2 RED A 1 BLUE B 3 BLUE B 4 RED C 2 RED D 2 RED D 1 BLUE Basically the Color column has to be changed to...

In a situation like the following: A 05-05-2005 Blue A 05-05-2005 Red A 05-05-2005 Red A 04-04-2004 Red B 05-05-2005 Red B 05-05-2005 Red B 04-04-2004 Yello How do I get the following table: A 05-05-2005 Red A 05-05-2005 Red A 05-05-2005 Blue...

What is the SQL function to get the age from a birthdate? I know in MS ACCESS, it is DateDiff("yyyy",BIRTHDATE,Now()) Thanks

Need help to produce two SQL queries on the following situation: I have a table that looks like this: Column A Column B A B C D E F G H B A D C F E H G These two columns are co-requisite of each other. In other words, A is a co-requisite of B, and B of A. I need to produce two...