Yes. it worked.

Then along comes your manager and says, "Hey, we need to add a flag to indicate if a position is management or not and we need to add...

Search on sp_MSforeachdb for examples of iterating DB names.

Select

  ja.Name,

  op1.PositionTitle As FirstChoice,

  op2.PositionTitle As SecondChoice

From JobApplicants As ja

Inner Join OpenPositions As op1

  On ( ja.fkFirstChoice = op1.pkPositionID )

Inner Join OpenPositions As op2

  On ( ja.fkSecondChoice...

Select HeaderID

From Header As h

Where HeaderID In (

  Select HeaderID

  From Detail

  Where Item = 'X'

  Group By HeaderID

  Having Sum(Price) > 0

)

And Not Exists (

  Select *

  From...

Seems over-complicated.

Why not take the raw captured data and use the built-in Sql Server REVERSE() string function instead of an external EXE ?

[Edit] If your design locks you into using...

It is not possible to pass a table variable to a SP or UDF. It appears to be a case of the BOL documentation not being kept up to date...

>>Could you or someone explain how this part of the update works?

It's a self-join that joins adjacent records in the sequence for each member.

"Where t1.Sequence = t2.Sequence - 1"

t1 is...

So, in cases where the gap is > 30 days, it is required to have certain records in the final temp table *twice* ?

[Edit]

What would really clarify the problem is if you took the ROODVELDT data and explain exactly what you expect to see in the temp table for that member

I would do this using a temporary table and a set-based operation rather than via cursors.

Create a table to apply a sequence number to the data:

Declare @Tbl Table (

 Sequence int...

Select BankNo,

  Sum( Fee * Case Quarter When '2004Q1' then 1 Else 0 End ) As Qtr1_Fee,

  Sum( Fee * Case Quarter When '2004Q2' then 1 Else 0 End...