Search results for query: *

you need to download the installer sdk. http://www.microsoft.com/msdownload/platformsdk/sdkupdate/ then run the orca.msi to install it. then open it with orca. Theres a doc that describes what needs doing.. http://support.installshield.com/kb/view.asp?articleid=Q106852 Nasty ain't it?

AFAIK you can specify MAXDOP 1 as a hint/option for the query, so you do not have to reconfigure the server. (max degree of parallelism Option)

dilettante, thanks, I think this is the kind of thing I've been searching for. "a custom client that interacts with a server using SOAP." thats exactly what I've been trying to do :) I've just found the INet control (microsoft internet controls) that looks like it might be capable...

I've also been looking into this. It seems to be a big chunk thats missing from the internet API's. The only answer seems to be to use third party com/activeX solutions. There are some on component source and I'm trying one from Dart Communications as we speak. The down side of this is that...

You've just become my personal hero. Thanks, thats just what I was looking for.

Thats the sort of thing I'm after only I get: Line 1: Incorrect syntax near '='. from: SELECT IIF(DET_TYPE ='INV', DET_GROSS, DET_GROSS) AS VALUE FROM SL_PL_NL_DETAIL I've only seen examples where ISNULL(..) is used in the iif. I feel like I'm being really stupid here. My SQL knowledge is...

As databases and recordsets are objects you need to use 'set'. Off the top of my head: set rs = db.openrecordset(..... you probably need to create them as new objects too. ie. Dim db As New Database But this is more of a VB issue than SQL. You should really be using ADO objects for these...

I'm trying to create an SQL statement to pull in some values from an accounts package. The problem is that values are all stored as positive values but need to be negative for certain transaction types. eg. when [TRANTYPE] = "CRN", value = [GROSS] * -1 when [TRANTYPE] =...