Search results for query: *

error message that has me stumped. Usually a PL/SQL user and not sure what to do. the SP is below the error message I'm getting is must declare @max_date, it is so I'm stumped Any help would be greatly appreciated. Thanks in advance!! SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER...

I have a group of reports associated with a database through a catalog. I require information from a flat file. Thought I could use hotfile, renamed the file to end in .ims, file is not showing on the browse list. How can I make a flat file accessable to my catalog. This is a CSV delimited file...

Trying to work out if this is possible within cognos. Data source is a very simple summary table key description value 1 reject reason 1 nn 2 reject reason 2 nn 3 reject reason 3 nn *********************************************************** what...

the statement below does not sum in the else part of the case statement so my totals are off with only 'P' flabtypes being summed. Help!? SELECT FEMPNO, fcearncode, CASE WHEN Max(Ladetail.flabtype) = 'P' THEN sum(Ladetail.Fchrglab * 60) else sum(DateDiff(ss, Ladetail.fsdatetime...

two fields fmoldval and fmnewval table field defined as text. Would like to use them both in a mathmatical equation fmnewval - fmoldval actual data is stored in a decimal(9,5) Tried both cast as decimal (9,5) and cast as int and received the error message Explicit conversion from data type...

OK so I'm drawing a blank on this one. I have a field in one table that is Order# ' ' line# + release#. Sometimes the order # is 5 characters, sometimes 6. Line# can be 1 to 6 digits, release# does not always exist but when it does it is 3 characters. I need to extract the line# to use in the...

OK here is the senerio. I am creating a cursor let's call it yield, the cursor is passed to a yield report all data prints great. Now a few months later then want cost information (yield x stnd cost) added and the stnd cost is stored in my inventory table. So off to report designor, open the...

I have an employee detail file that contains bar coding scans for times clocked in and out. I want to select for a week all employees that are over 40 hours and have at least one record that the field type <> 1,5 or 6. Any suggestions or do I need to go to outside SQL to generate Thanks Terri

I have two tables one contains header information for a return form the other is the activities against the return. There are multiple entries for the activities against one return. I only want to grab the oldest activity header fields creditno (joins to detail) customer part status detail...

I have modified an existing report by adding an addtional table. The join does work and the tables are relating because the preview shows the data I require. The clincher the printout does not all the time. I have tested all sorts of conditions, thinking first of corrupted data. Once the report...

I have two tables INTRAN with two fields that apply fmjobno and fqty JOMAST with several fields I require, for this example lets use fjobno, fordqty, ford_dt there is a 1 to many relationship where jomast with be 1 record INTRAN will be many entries for the same jobno result would be...

How do I get the cursor available in the data environment so that I can join fpartno and fpartrev to another cursor that already exists in the data environment? lnHandle = CURSORGETPROP(&quot;ConnectHandle&quot;,&quot;inonhd&quot;) lcsql='SELECT inonhd.fpartno, inonhd.fpartrev...

I am trying to modify a report that is part of a software package so some of the knowledge of 'how things work' is not always clear. The .prg creates a cursor using sqlexec called slbklg, when you enter the data environment of the report layout tool this cursor layout is available for drag and...