Recent content by Jimmy2128

I have a f drive shared folder which contain about 150 subfolder for different department. I need to be able to create a report of which files are older than December 2004 and identify the exact location. What would be the best way to execute this task? Thanks for any assistance. Regards,

I have a f drive shared folder which contain about 150 subfolder for different department. I need to be able to create a report of which files are older than December 2004 and identify the exact location. What would be the best way to execute this task? Thanks for any assistance. Regards...

I have set a differential back p for one of our database in accouting, Database is backing up every hours but is overwriting the existing one. I would like to be able to set up in a way where is save during 22 hours until fullback is created at 9:00 pm Example I want to save the files this...

I have a system that was running windows 98SE and the hard drive was partition to C = 40 Gig and D = 40. I have installed windows xp professional then format c to NTSF, but I did not format D so all my data still there. When I go to computer management ==> disk management / my D drive is not...

I have noticed that my TLOG Backup file is larger than the FullBackup Example: Fullbackup: 2,182,684 kb TLOGback.BAK: 33,661,280 kb Can some please explain to me how can I fix it and why the log file is larger than the full back up. Thanks James

that looks the same to me. Can you please revise it.. Thanks Jimmy

I have the following query Full Name: [FNAME] & " " & [MNAME] & " " & [LNAME]+IIf(IsNull([DESIGN]),""," ," & [DESIGN]) I am getting the follwing: John D. Doe ,PHD I want to eliminate the space between Doe and the Comma. It should read like = John D. Doe,PHD Can please help me out. I tried...

I have the following scenario: FullName:[FNAME] & " " & [MNAME] & " " & [LNAME] & " ," & [DESIGNATION] I want to add a comma after LNAME when the members has DESIGNATION field but if the DESIGNATION field is blank do not use the comma. Example: John Doe, PHD Marie Doe, (without the comma)...

I am creating a query with the following spects. BT_ID = Member ID BT_IDCompanyName = Company Name ST_ID = Member ID ST_IDCompanyName = Company Name The query pulls the Advertiser and Advertising Agencies, If the member advertise directly with us the BT_ID and ST_ID will be the same including...

I am trying to find all our members that has not email address under the email field. I have the following script select n.id,n.full_name, n.email, n. member_status,n.Member_type, n.company from name n where n.email = '' Would you please tell me if make sense. Thanks Jimmy

I want to add a field in my SQL table called YES/NO. Where the user have the choice. What Data_Type should I use.. Thanks for your help.

I have the following pass-through query select * from name n, product p, meet_master m where n.chapter=p.product_minor and p.prod_type='chapt' and ((m.meeting_type ='CHAP' and substring(m.meeting,3,2)=n.chapter)or (m.meeting_type='AFF') and...

I have a report that give the dates and the location of the annual meeting Example of fields = (Meeting_Begining_Date) and (Meeting_Ending_Date). The problem is if the meeting last only 1 day Meeting_Beginning_Date) and (Meetting_Ending_Date)will be the same. What I like to accomplish..If...

I have a server migration from SQL_Server_V to SQL_Server_S. I have some reports that run in citrix. when I go to c:\winnt\system32\drivers\etc\hosts\ I need to add v line in as in the citrix machine. Can some tell how can I do that... Thank for help!

I have an excel report that connects to a datasource, I am getting an error message when tries to connect to the sql query. Where can I check that the server name is the correct one and the location of the query. Thanks for helping..