Gaby, jcrawf42 - thanks for the info!

thanks for the info Kit!

SAT_SQL (6/29/2009)

---

Hi All

This my sution

there are two tables i am mentioning , but there is 900000 records ,

...

Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... ) to Niagra Falls. Does anyone here know anything about this...

Gianluca Sartori (6/29/2009)

---

I'm still offering 5 dollars, better than nothing.

Anyway better than "I want (you) to cut...

:rolleyes:

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when I had my...

Well, if it were in a busy city, I'd ask for someone to drive me around.

The code I posted produces the results that you requested. What did you...

Hey Rajan, why don't you start your...

CREATE TABLE #RawData (LineText varchar(max))

BULK INSERT #RawData FROM "MyFile"

I've tried:

BULK INSERT #RawData FROM "MyFile" WITH (LastRow =...

This ought to get you on the road...

select Client = c.Name,

Bank1 = max(case when b.bid = 1 then BID else NULL end),

...

For those that use the FireFox web browser (you can stop reading now Jeff:-)) - what do you use for blocking ads? The one I used wrecked havoc on this...

Thank you for the code - it makes helping out so much easier.

The #tempClient table looks pretty straight-forward. That's not the case with the #tempBank table. Normally, I would say...

lmu92 (6/24/2009)

---

@Wayne: When the request is to get the values for more than one Callernum, I'd go with your solution, but I would change

ROW_NUMBER() OVER (PARTITION BY Callernum order by...