Yikes. Thanks for pointing that out Jeff.

I've only (reluctantly) used it with very small sets, mostly in pre-2K5 code.

I'll be checking my code now...

How about:

IF OBJECT_ID('MyTable') IS NOT NULL

DROP TABLE MyTable

GO

SELECT * INTO MyTable

FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)

GO

SELECTm.Id, SUM(m2.Value)

FROMMytable m

JOINMytablem2ON m2.ID <= m.id

GROUP...

Right. And I didn't have RPC:Starting in my trace definition. Well that explains it.

Thanks!

P

In my experience, it's the front ends that come and go, back ends tend to be more stable. Granted there has been a bit of a shake-up with the availability...

This might help: psftp has a public key option.

http://the.earth.li/~sgtatham/putty/0.52/htmldoc/Chapter6.html

Yeah, I know it's a cmd hack, and you're right, it'll only work for a single response.

In my particular case, that's all that would have been required.

I got around it...

Hmmmmm.

I found this on the net; the author plainly states it's a bit of a hack, but also claims to have made it work for him. I've not been able...

In fact, neither works when inserting >1 parents.

I was simply wondering if I could save myself some code and a step with some fancy DRI.

Now I see that while it...

Thanks Sean.

I'm trying to set up a parent-child relationship. Some rows will be parents (nId = nParent), and some rows will be descendants (nId <> nParent).

In the past, I've always created...

The important point here is, it doesn't have to go from Access to your final data model in SQL Server in a single step

Import it into a staging table in...

Good read, learned something new, and it seems to confirm the adage "a clustered index for every table".

Missing quote after '{4}), should be '{4}')

Server = $dbname

DatabaseName = $mdfInfo.Name

DataFileName = $mdfInfo.FileName

DataSize = ($mdfInfo.size / 1000)

DataUsedSpace = ($mdfInfo.UsedSpace / 1000)

The first two look somewhat suspicious to me...;-)

What do you see in SQL Profiler?

We did not foresee this problem arising before we went to prod.

We should have tested it with the customer -- except they have neither the means nor the expertise...