Search results for query: *

Hello. I have a MSDE 2000 .mdf file that's about 1 gig and the .ldf that goes with it. I'm not sure how it was created, it was given to me, but I can find out. Anyway, when using the SQL Server 2008 Management Studio (SQLExpress instance), I'm connecting to my instance and then...

Software: Business Objects XI R2 Enterprise Server (Windows XP) Crystal Reports XI R2 (Windows XP) I have a report which connects to two different Sybase databases on the same physical server and same Sybase installation instance using native connections. On the desktop, Crystal reports...

Hi all, here's my problem. I have a main report with an on-demand subreport. The reports are not linked at all, and I don't want them to be. The main report has a prompt and the subreport has a prompt. I do NOT want the subreport's prompt to appear when the main report is run, just the...

Hi folks, you're all so helpful that I just had to come back. Here's the code I'm working with: select distinct .... from table a table b (select to_char((sysdate), 'dy') from dual) dt where .... AND if dt = 'fri' then ((a.date1 >= trunc(sysdate+1) and a.date1 < trunc(sysdate+4))...

Hello all, I need the syntax for to_date(trunc(sysdate) at 9:00am). Nothing I try seems to work. Thanks in advance.

Ohhh, my bad. Thanks guys, I'll post in Oracle.

No, this is for Oracle. 9i I think. I'm looking for the syntax using the to_date() function. Thanks!

Hello all, I need the syntax for to_date(sysdate at 9:00am). Nothing I try seems to work. Thank you in advance!

I haven't decided yet. I just got the correct answer returned by removing the "return", happily!. I'll see about making it cleaner and chosing a final option soon. I still need to strip the time off of the response.

Thank you all. I knew it had to be so simple it was embarrassing. I tried everything I could think of, and just never thought that you didn't have to "return" anything. :-) Thanks!

Hello all, I have a small problem I hope you all can help with. It seems pretty simple, but the resources I can find online don't help :(. I'm trying to create a stored procedure in SQL Server 2000 which takes one input parameter as a unique key and returns the max(date_field) associated with...

Thanks IBMTech. I don't have a mirrored raid set up. Only striped. I have tried booting to safe mode. It lists a long list of files on the screen that I assume it is trying to load, but after the list finishes, it just sits there. It does not ever start windows, just remains there with...

Hey, thanks for the help. I do have the CDROM as the first boot device and it will boot other CDs that I have, but not the WindowsXP disk. Hmmmmm. Anyway, I have a question about the raid driver. During POST, the raid driver is accessed and shows the functional raid array and it doesn't begin...

Shoot! One more thing. I'm not using a RAID card, I'm using a gigabyte motherboard with on board RAID. If it matters. Thanks!

Hey, thanks for the help guys! I knew the XP Install CD should have been bootable. My CDROM is set as the first boot device. I still don't know why it's not booting. I'm going to try and see if I can get another disk. I suppose it could be scratched or something (?). I also suspected that...

Hi guys. Shouldn't the WindowsXP installation CD be a bootable CD? I'm having a problem with what I think is a corrupt windows install and trying to reinstall/repair. But the install CD does not boot from the CD-ROM. (??!!) Any ideas? My problem is basically that XP loads part of the way...

Well, I have an update. I use the promise raid controller and a buddy said that this happened to him and he was able to rebuild the array with no issues. So, I did! I deleted the array and recreated it with no problems at all. Surprise - the array is now "Functional" instead of "offline"...

Hi guys, I sure could use your help. I have twin 80gig hard drives installed in a machine that I built running in a performance (striped) RAID configuration. Yesterday, the POST test indicated that the RAID array was 'offline' and it would not boot. What can I do to find out if the hard...

Yes, I know. I had Norton AV but had let the definitions lapse for about 90 days or so. When I renewed it is when I found the virus. I have read the link you posted thoroughly. Do you understand what is meant by this: &quot;When svchost.exe (the first-generation W32.Jeefo executable) runs...

Does anyone know of a tool, utility, or any other way to repair .exe files infected with the w32.jeefo virus? I would REALLY appreciate the help. ThAnKs!!