So darn clever!

Thanks

How about creating an "official non-union" to publish a reasonable list of benefits that employers should expect to offer in order to attract and retain good employees. Workers could...

Suggestion:

Try different connection methods: ODBC, OLE DB, SQL Native Client...

Also, try changing data type to char then convert back to date or datetime as needed in the report.

-Rob

Hi Liam,

I have a client (prestigious Venture Capital firm) using PDF-eXPLODE to send Excel-based portfolio valuation reports. Each worksheet (tab) contains a different portfolio destined for a different client....

I try to use derived tables whenever possible, but I recently improved performance by changing a derived table to a temp table. It was large and joined on a...

Sorry, that post was 3 and 1/2 years ago (about 40+ projects ago) and I have no recollection of what I was working on at the time.

-Rob

So simple!  That worked (using adapter).

Thanks for tip,

Rob

Yes, I'm using 2K but can I pass the complete ntext value back from a stored proc to a VB.NET program and if so, how?

Thanks

Using a table variable is a clever workaround.  However, I treid unsuccessfully to use WRITETEXT and UPDATETEXT with a table variable.  Does anyone know whether there is a way to...

Why not use a running total in Crystal? The same amount of data will be returned to Crystal either way, and I doubt such a running total would cause...