Search results for query: *

Hi Ben. Yes I tried to reinstall Dell Media Experience, and still that did not solve the problem. I called DELL, but since the warrenty was over they wanted me to pay $49 before I could have any help or suggestion. My Dell Inspiron 6400 has a small button that I can press after inserting a DVD...

In fact, I had tried system restore a number of times and unfortunately that did not solve anything. So I a left to think that something is wrong with Dell's DVD software. Anyway, now I can watch DVD on Windows Media Player. So thank you everyone for all their help. Prad

Hi Ben, Ok I did what you have told me to. When I tried to open it by selecting Dell Media, Dell Media opened and displayed an error message "Dell Media Experience is unable to detect your VCD." So it still does not play with Dell Media Experience. However, it now plays in Windows media player...

Hi Ben, I installed the K Lite Codec package and it still did not solve the problem. I am still getting "The file does not have a program associated with it for performing this action. Create an association in the folder options control panel." error when I click on my DVD drive after inserting...

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

Gmmastro, Your solution worked (awesome) but the response time was greatly slow. I guess I will have to run this query in Access and import the output table. Thanks to everyone who tried to help.

Could you please elaborate? Thanks

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

Thanks for all your suugestion. But I figured out the easiest, clear and efficient would be to go with three Updates like Vongrunt suggested. Thanks again to you all.

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

Thanks all you guys for your help and time. I have learnt a lot here today. Thanks again.

That's right Vongrunt.

The easiest logic I can think of and have tried using MS ACCESS is by creating a 'KEY' field which is a combination of field1 and field 2, on both the tables. So now, all I have to do is, table A LEFT OUTER JOIN table B on A.key = B.key where B.Key is NULL. But I was trying to use the same...

Amrita, I tried your code, but it did not work either. I have decided to just use the LEFT OUTER JOIN suggested by Vongrunt and that has worked. The reason why your code did not work was Table A Table B A Null A 1 A Null A 2 A 3...

VONGRUNT, If you have tables like the following: Table A 4 A 5 A 5 B Table B 4 B 5 A 5 B Will your suggestion give me an output table like this: 4 A The main problem is, I have two supposed to be exactly similar tables, but some how the second field seems to...

This is getting quite confusing. But simply having INNER JOIN and putting DISTINCT does not work. Like gmmastros and I mentioned before, it would bring back the record where both the fields match. We just one records were field1 matches and field 2 doesn't, in general.

No that still won't work because if we have tables like this Table A 5 A 5 B And Table B 5 A 5 B The query should not be getting any output since the records match on both the tables ( I am looking for records that match on first field but not on the second...