Search results for query: *

Hi, Thanks for the reply, It worked!!!

Hi, I cannot run the following query in Query Analyzer, I get an error: SELECT NAME_LAST, OPT_ID,OPT_NUM FROM OPTIONEE WHERE OPT_ID = '999999999'AND UPPER(NAME_LAST) = 'O'BRIEN'; My problem is that the name O'BRIEN contains a single quote. How can I work around this? Using SQL Server 2000...

Thanks, they all worked

Hi, In cell A6 I have this AU9602 Dec 15, 1995 What you cannot see in is that between the "2" and the "D" is the character for carriage return char(13); it looks like a square. Ok in cell B6 I have this formula to get the date out of A6: =MID(A6,FIND(CHAR(13),A6,1)+1,12) So the value in B6...

Thanks Ken, I will change my formula.

Thanks!!!, it worked:)

How do I get a vlookup to return 0 (zero) when the value "#N/A" is returned? My formula is =VLOOKUP(S8,$C$8:$N$3448,12,FALSE) which returns a currency value if there is a match. When I do not get a match I would like to have the value zero returned. Thanks, Mike

Hi Skip, Yes I know. However please note that I am comparing 2 columns of 35,000 rows. I line the columns up and in the first row of a third column, I put the formulas in (see above). I then auto fill the rest of my rows and this is what is taking a long time. Thanks for responding, Mike

Skip, Did you match with zero, i.e. match(m5,$c$5:$c$35250,0)? When I use match(m5,$c$5:$c$35250,1) it goes quick, but not with zero. Mike

Hi Skip, Thanks, I tried running for numbers and it goes about 10 times faster, although it still takes about a minute or two. Maybe it is my version of Excel or my PC. My processor is maxed when this function is run. Mike

Hi, Using Excel 9.0. I have 2 columns of cells about 35,000 rows each. The data in the cells is text. I need to compare the columns to each other. I need to determine values in column A that are not in column B and vice versa. I was using vlookup and match to do this and then auto filter...

LB, excellent thank you so much for your help

Wow, cool, thank you, and of course another question. I should have put this information in the original post, but I really was expecting to be told it could not be done. Lets say I am reporting on blocks. My report needs to print one line for every block that is the same color, same shape...

Hi, I am using Crystal Reports 7. I have a report that needs to be grouped on price ranges. However the ranges are not determined until the data is returned to the report. The grouping occurs as follows. First find the lowest price of the record set returned and multiply it by 1.5. This is...

HI, I am using crystal reports version 7. I need to know methods of comparing two crystal reports. Here is my situation. I was given the task of adding additional functionality to a report used by my company in their production environment. I have added the given functionality. However...

LOL

THAT DID IT!!!!! Thanks, Dave

Hi, I just reread my post and want reiterate the problem. Once the stored procedure is added to the report there is no field to add to the report. Mike

...DATETIME, @v_Look_Back_Year INTEGER, @v_WhatIDid VARCHAR(35) BEGIN SET NOCOUNT ON END OF STORED PROCEDURE CODE: SELECT @v_Count = count(*) FROM esp_25k_Summary_rpt WHERE runtime_ID = @p_Runtime_ID IF @v_Count = 0 BEGIN EXEC gl_errorHandling @p_runtime_ID, 'No Data...

Thanks, synapsevampire, I checked on SQL Server's, SQL Profiler and the it comes through.