Here's what I came up with.

The solution will display the first 6 followups. I added a note what to change if more followups are required.

Once you've studied the concept and...

orca (4/1/2010)

---

I have to admit that I didn't understand much of Lutz solution (but I did copy the suggestion into the Management Studio, and the result was exactly as I...

Please provide sample data that will describe the scenario you're strugglnig with.

Based on your vague description it is unclear whether you would have missing rows in #customers for a specific...

Judy-363345 (4/1/2010)

---

lmu92 (4/1/2010)

---

Did you try the solution I posted earlier?

SELECT UID, ReferenceNumber, TYPE

FROM #tbl myTable

WHERE ReferenceNumber NOT LIKE 'TR%'

AND EXISTS (SELECT 1 FROM #tbl myTable2 WHERE TYPE = 1...

Did you try the solution I posted earlier?

SELECT UID, ReferenceNumber, TYPE

FROM #tbl myTable

WHERE ReferenceNumber NOT LIKE 'TR%'

AND EXISTS (SELECT 1 FROM #tbl myTable2 WHERE TYPE = 1 AND myTable.uid...

You could use the following line to find the rows with bad data format:

SELECT * FROM YourTable WHERE ISDATE(yourColumn) = 0

IIRC DBCC TIMEWARP has 137 parameter plus 256 optional parameter.

Or will that be in the futures / was it in the past / will it be in the past? :w00t:

If...

Your WHERE condition is transformed into:

WHERE

(CardORKey='Key')

OR

(

CardORKey='Both'

AND

( LastName = @LastName

...

I'm not sure if I'm totally wrong, but isn't that WHERE condition identical to WHERE ReferenceNumber NOT LIKE 'TR%' ?

Reason:

With your first subquery you include all UIDs with Type =...

CirquedeSQLeil (3/31/2010)

---

lmu92 (3/31/2010)

---

I think question #6 cannot be answered on this forum at all:

The answer would depend on too many things, e.g.

How much money is...

I think question #6 cannot be answered on this forum at all:

The answer would depend on too many things, e.g.

How much money is offered to...

Did you try to find a solution in BOL (BooksOnLine, the SQL Server help system usually installed together with SQL Server)?

You might find a solution in section "XML Bulk...

But it's a while back since I've last seen a LMGTFY link...

Seems like we're kinda learning search engine.

How does a search engine express it's/his/her feelings anyway?

I would do it in three steps:

step 1: build an intermediate table with preaggregated values

step 2: do the quirky update

step 3: display the pivoted data using crossTab

Something like this (side...

Based on your description and ready to use sample data it was really easy to work on and to match your desired result.

This is one of the very best formats...