Search results for query: *

I need a field to have possible mix results such as when IF SID = A then "NA" ELSE IF SID = B then DATETIME ELSE IF SID = C then "-' Thanks for the help!

I need to Schedule an Import of a Excel into a Access Database any Ideas?

I need to be able to schedule an import of an Excel spread sheet from an Email. Any Ideas?

Hello; I have the following: Datediff A)Days B)Hours C)Minutes and need to combine them into one output field. Any suggestions? Thanks in advance!

I have the following: Datediff A)Days B)Hours C)Minutes and need to combine them into one output field. Any suggestions? Thanks in advance!

Hello; I am using Crystal Reports 2008 and need to take in the following field a: Hours (value) b: Colon (:) and c: Minutes (value) and combine them into one field. I keep encountering an error when @hours + ':' + @minutes Error message reads: "a number, currency amount, date, time or...

Hello; I have locations world wide, but my times are recorded in EST. I need to convert to local time, within SQL 2008 using UTC. Has any one done this? Thanks Brian MAhler

I have a stored procedure that needs to be executed every time a certain table is allocated to the database. Thanks in Advance for the help!

I have the following in SQL Server 2008 Parm Input is Start as datetime If I hard code a Date it works: UPDATE [WORKING_SVR_CLOSED] SET [TTRHours] = 'Yes' FROM [GM].[dbo].[DATA_CLEANING] AS dc LEFT OUTER JOIN [GM].[dbo].[WORKING_SVR_CLOSED] AS o ON DC.Number = o.DimensionDataRef WHERE...

I have multiple line of input data as such: Number, Starttime, Targettime, Endtime SVR227408,3/24/2010 4:34:24 PM,4/7/2010 4:34:24 PM,4/6/2010 10:35:06 PM SVR227408,12/7/2009 2:18:27 AM,12/8/2009 9:00:00 PM,12/7/2009 8:43:14 PM SVR227408,12/7/2009 2:18:27 AM,12/8/2009 9:00:00 PM,12/7/2009...

Hello; I am taking in a Oracle database with tables that have columns that have additional commas and I do not have at present time a way to edit the import csv's. Does anyone have an idea of how to work around this? Thanks Brian Mahler Brianmahler@msn.com

Hello; I am taking in a Oracle database with tables that have columns that have additional commas and I do not have at present time a way to edit the import csv's. Does anyone have an idea of how to work around this? Thanks Brian Mahler Brianmahler@msn.com

I am using CE10 & CR10, I am unable to find where I can EXPORT in ADVERTISED MS POWERPOINT format. The admin guide refers to CR10 user guide & a off-line viewer. Has anyone used or heard of this beast? Thanks in advance... Wallie12

HELLO WORLD! Life is great, just completed acceptance testing, production testing, and have move CRYSTAL ENTERPRISE 10 PROFESSIONAL & REPORTS 10 ADVANCED into to a multi-billion dollars production envirnoment. Using ORACLE 8 & 9i, TOAD, SQL and stored procedures. Migrated some 250, 150 which...