Sorry I haven't gotten back to you, I was out of town.

Yeah, that's approximately the format I was thinking of. It's just better when you have 'x' number of potential...

My well is over 700ft down. Can I just add a couple of pipes & use that?

All true.

The reason I'm chasing this down is because on another thread, someone was asking how to parse an XML file out into it's component parts for loading into...

We keep this up and I'll make it really, really scary... I'll take my shirt off

[SHRIEKS]

Thanks.

Much closer to 50/50 which was my initial assumption of worst case (boy was I shocked). I think I'll expand the tests a bit & start looking at actual memory...

Should I tape a full two-hours?

That'd be slightly more interesting than the yule log on TV.

Up in the Peoples Republic of Massachusetts we don't worry too much about cooling the house, but this GeoThermal heating sounds a heck of a lot better than the two...

I'll hazard a wild guess and suggest... compile time. That's one large plan. You can test this by going to a non-production server, run the view to get it to...

SELECT *

FROM Table1

JOIN Table2

ON Table1.Key = Table2.Key

JOIN Table3

ON Table1.Key = Table3.Key

This assumes that the PK on Table1 matches an FK on Table2 & Table3. Either way, you can then use...

day (11/1/2007)

---

Now, I need also [Balance] field in the view. Since [AmountIn] and [AmountOut] are not a physical fields, I cannot do something like this:

Can anyone help me with this?

SELECT...

kev_byrne (11/2/2007)

---

On the second server, where the database is the same in structure and programming, there is no problem at all.

The SQL when run directly against the DB, on the...

This is unlikely to run very fast, 43 seconds on my machine against 54 million rows, but it'll work.

WITH x AS (SELECT b.[ID]

,b.[Date]

,b.[Value]

,ROW_NUMBER() OVER(ORDER BY b.[ID]) AS RowNum

FROM [BigTable] b

)

SELECT...

Johannes Fourie (11/2/2007)

---

Another option is to create an index on the temp table that you want to use for sorting before inserting into it.

Then remove the ORDER BY in the...

Thinking about it more, you should be able to get reasonable performance, even pivoting the data, assuming the indexes are clean, especially the clustered indexes. How did you set those...

Unfortunately, I'm going out of town for a week, but posting a bit of code could help someone else to help you.

Based on the requirements... 30 fields each 100 characters...