Search results

Kodo, what part of Syracuse do you live in?

didn't work. any other ideas?:confused:

i shall try thanks

good idea thanks

I moved into SQL Server DB myself

I have a table in an SQL database. The field data is in the format "12/29/2003 1:00:00 PM" I cannot change that! I was wondering how to run a query that will change all the dates with "12/29/2003" irregardless what the time was. I have this UPDATE POSTransHist SET POSTransHist.DateTime =...

youll be back. You can not escape this forum!

I need to uninstall MSDE for a program to install it. When I uninstall it and reinstall the software it give me an error every time that it cant find the path c:\program files\microsoft SQL Server\data\osql.exe or similar to this. It use the uninstall in the add remove programs, and I delete...

well judging by the fact that you give us the example of you using Kazaa could be some sort of corruption or virus or something.

do they do these seminars on other days other than Tuesdays and Thursdays? It's kind of hard to leave work to go to this.

Here is what I ended up using: UPDATE Customers SET Customers.Phone = (mid(Customers.Phone,2,14)) WHERE ((left(Customers.Phone,1) = '1')) I forgot I actually was writing to a temporary Access Db before importing into SQL Server Thanks for everyones help!

Thank! I'll shall try tomorrow

Mid is not a recognized Access statement. Does anyone know what the SQL Server equivelant would be? The phone number should look like this: "(555) 555-5555"

this is not Access it is SQL Server. Will that make a difference?

I have a sql statement. It is a phone number field. I want to if there is a 1 infront of the phone number to take it out. The phone would look like this: 1 (315) 344-3312 The statement I am using is this: UPDATE Customers SET Customers.Phone =...

what has happened here? Since 2 weeks ago there seems to be a lot of arguing and complaining. It seems such a shame b/c it was never like that before. Guess a good thing cant last forever!:(

just found this link http://www.simtel.net/pub/pd/8092.html

that seemed to work but now it ask me to save the spreadsheet everytime.

I se automation to fill in data from Access into Excel to email to a customer. The automation works fine and it fills it in with the correct data. However the part that doesnt workquite right is closing Excel. I will keep an instance open in the Task Manager. So if the I try to ipen another...

thanks a million! I was searching for this for some time guess I missed it somehow