Search results for query: *

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

I have a sql query that I need to run in microsoft access and create a report based on this query. Is any way I can run the query in microsoft access without using pass-through query, for some reason when I try to create the report it keeps prompting to select the data source, even I selected...

I have a sql query that I need to run in microsoft access and create a report based on this query. Is any way I can run the query in microsoft access without using pass-through query, for some reason when I try to create the form is keeps prompting to select the data source, even I selected the...

Version 6.1 Thanks

I am trying to install ColdFusion MX 2004 my server box uses windows 2003. As soon the installion starts the ColfFusion application goes away (flashes and goes aways) nothing happens. Is any advise of what can I check, I have gone throught the installation requierements. Do I need to install...

I have a store procedure that output the Customer table to a .txt. I need this Customer.txt to be fixed length ASCII and delimited by " . How can I do it? Thanks