Search results for query: *

SQL Server 2000 linked server to Oracle was set up and working fine for over a year. It quit working - not sure what happened - but when I deleted it and tried to add it back, there are no providers in the dropdown. I can add it via Query Analyzer, but it still won't work (error 7399)...

Crystal XI crosstab issue: 2007 2008 2009 Total Town 1: 3 5 8 16 Don't need the total, but I'd take it if needed. What I really need is a calculation on the total (divided by 10): 2007 2008 2009 Total Target Town 1...

I may be especially stupid today, but how can I test to see if a variable value is null in CRXIR2? whileprintingrecords; numbervar v_appID; v_appID := maximum({Command.appgroupID}); v_appID; The variable defaults to 0, but if the report returns no records then it's being assigned a null value...

Anyone know anything about Enterprise XI blocking client access when using Internet Explorer 7? I haven't uprgraded yet, but I've heard there is a problem. Nothing in BOBJ hotfixes yet.

Not too strong on crosstabs, so hopefully this won't be too difficult. I have a crosstab which calculates employee terminations by week: 11/1 11/8 11/15 11/22 Total 1 2 1 3 7 I also have a static number of total employees at the beginning of the...

From archived thread 782-1164845: "paulmarr (Instructor) 13 Dec 05 18:04 Hi everyone, Perhaps someone could point me in the right direction. We are using CR v10 and CE10. We have created reports against a Progress Database using the MERANT 3.60 32-BIT Progress SQL92 v9.1D ODBC driver that...

I've inserted records into a temp table in the specific order they need to be sequenced: visit sequence 100 100 100 200 200 300 400 What is the most efficient way to update the sequence so that it resets at each change of visit? visit sequence 100 1 100 2 100...

I need to export to a text file with specified column positions, meaning that I need to right pad the results with spaces. I don't recall any problems in the past doing this, but this time I'm not getting the proper results. For example all of these return the length value of 4: create table...

Can someone please tell me why this works: select * from @missingvalues a where exists (select 1 from @v_responses b where a.questionID = b.questionID and a.response = b.response) but this does not: delete from @missingvalues a where exists (select 1 from @v_responses b where...

I'm sure there's a standard, simple technique for this but it's been one of those "beat your head on the desk" kind of days. Standard table which stores payroll history - empID, rate, changedate: 1001 15.00 1/1/2004 1001 15.50 1/1/2005 1001 16.00 1/1/2006 I need a query to...

I have inserted data into a temp table such as this: Emp Type Starttime Endtime 1 A 08:00 1 A 08:30 1 B 09:00 1 C 10:00 1 B 10:30 What is the best way to get the next starttime into the previous endtime: Emp Type...

I need to right pad some text fields with periods so that they all line up: 1. Were you treated promptly? ........... 2. Were you treated professionally? ..... I first tried using a loop that referenced the field length, but then realized that would only work with monospaced fonts. Does...

I'm new to GP but I've looked every way I know, including SQL logging, and I can't find where the lookup values for the employment type and HR status fields are stored. The numeric values for each are in the UPR00100 table. I'm assuming that the text values - "Terminated", "Full Time Regular"...

Someone please point out the error of my ways. I've tried this query several ways with the same results - as soon as I add the second total I get a cartesian join. I'm not seeing why this wouldn't give me each record from the visit table, and total payments and adjustments from the subqueries...

I have a table variable populated with teams, weeks, and start/end dates: Team Location Week Start End Calls 113 New York 1 1/1 1/7 113 New York 2 1/8 1/14 113 New York 3 1/15 1/21 114 Boston 1 1/3 1/9...

I have a crosstab that basically does what it's supposed to: ID Name Hiredate Traindate Week 1(1/1/05) Week 2(1/8/05) 1 Joe 1/1/1980 1/7/2005 99.99 100.00 The summarized field is the value for week 1, week 2, etc. What I would like to do is to change the font color...

Can someone please explain why the first query runs in a few seconds while the second query takes forever to run? 1. select todatefunction(numericfield), otherfields from table where numericfield = 1050424 2. select todatefunction(numericfield), otherfields from table where...

I've read numerous articles pertaining to timestamping rows on inserts and updates, but all of them either seem to talk about the functionality of the timestamp datatype, or else suggest using a trigger to update the row. The problem I see is that using a trigger to update the modified column...

Sorry guys (and girls)... I'm not much of a batch file programmer. I have several files that are created automatically each night. At the very least, I need a batch file that appends the prior day's date to the file name. I can get the current date on there, but I don't know how to subtract a...

My understanding is that variables of table datatype remain in scope until the completion of the stored procedure, and all the examples I've found are very similar to this piece of my procedure: declare @v_restable table(tran_date smalldatetime, rescount int) insert into @v_restable select...