Hi visbek !

It took me some time to get the picture 🙂 but after that it was obvious. I think the problem is in the way the type info view...

Hi cutespn,

try this self joinining query, I hope it'll help:

SELECT

  TI1.PositionNbr, TI1.IncentivePlanTypeCode,

  MIN(TI1.FromDate) AS Min_FromDate,

  MAX(TI2.ToDate) AS Max_To_Date

FROM

  TranscationIn AS TI1

  INNER JOIN TranscationIn AS TI2

    ON (TI1.PositionNbr = TI2.PositionNbr)...

Try this, I hope it will help:

Separate the columns in the SELECT into two groups:

1. Columns that are used in joins (mainly id's).

2. Columns that can be obtained by lookup...

Delphi treats TEXT fields as ftMemo. Try setting FieldType to ftString manually. Also, I agree with the provious suggestion about higher BLOB SIZE value.

Try this for start. It uses two temporary tables and one cursor, but it does not use recursion.

CREATE PROCEDURE MAKE_CSV

AS

SET NOCOUNT ON

DECLARE @group int

CREATE...

Are you allowed to use temporary tables ?

Assuming that the specified 5 rows are in a table tmp_a, try this:

select

t1.a, t1.min_b, (select min(c) from tmp_a where (a = t1.a) and (b = t1.min_b)) min_c

from

...

quote:

---

Function updates all records in the queue table as follows:

Update Table Set Field1 = <value>, Field2 = <value2> Where Field1 = null...

quote:

---

Stored Procedure:

CREATE PROCEDURE sp_proc_test

@PDT char

@PROJ char,

@WRKPROD char

---

If parameter types are exactly specified (char with...

Try this, I hope it will help:

 /*

   Assumption 1:

     PutawayPriority is unique for each Item (no two bins...