Recent content by kramerd1506

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