You know, it's painful to populate the tree, have someone from the 'paper work' department type it in an xsl 😉

or here's a few inserts for the sample:

insert btree values('00499133-96F8-444A-A938-003E7D5648B6','F32ED73E-2537-439A-8F3F-8EB18260FB4D','holly...

I don't know, but I like that it doesn't have any stack limit and it's more clear what's going on.

sense of humor, please

If I wanted to know that I'd ask my 3 year old daughter...

>Nothing says that you will get unique results.

Exactly. Or more precise 'no one'. So, what's checksum_agg() good for (in real life s/w world)?

Still don't see where the subnet comes to play. I want to query a different subnet than the one the app is running on.

haha...not really....

nice.... looks like the most people are pretty dry here....

Most likely you are referencing TargetServerURL in deployment properties as:

http://my_server/Reports

instead

http://my_server/ReportServer

Hope it helps,

peter

exactly...

i just dropped couple hundred tbls, which were developer's 'ooops...'

"you cannot select from a variable unless it is a table variable"

That's what I wanted to hear, thnx.

@t contains table name ('Admit')

If the date string has constant length, this will work in crystal

CDate(ToNumber(Mid('20030826',1,4)),

ToNumber(Mid('20030826',5,2)),

ToNumber(Mid('20030826',7,2)))

or on the sql side:

cast('20030826' as datetime) and then pass it to crystal

That's cool too, thanx

Exactly, Brian.