You might have better luck using SAVEASXML in the recordset object of ADO (2.6 and higher)

I have found it is possible to please all of the people all of the...

Presuming you're using SQLServer 2000 then check out the FOR XML and OPENXML keywords.

If you're on anything less, like say 7. then you can use ADO XML recordsets (ADO 2.6...

In my opinion it is best to get into the habit of enforcing Unique Constraints for primary keys. They do perform better and you protect you table against less thorough...

Not quite sure what you're trying to acheive with the 'Package Rollback'. How can the Source file be either in the Source or Destination directories, surely Source contains Source File,...

If your select is slow the first place to look is your indexing strategy on the two tables. Looks to me that you will have a primary key of Contractor...

Hi Andy, yup I agree however I thinks June's problem is a little complexe. Her example is

'Hotel name','Arrive date','Length of stay'

And the corresponding translation might be Nom D'Hotel, Jour...

I guess you're not returning the values in correct grammatical order for the language. Steve is right, all you need to do is create a column (probably numeric) giving a...

OK as I understand it so far you need to run the same procedure but have it affect different tables depending on the module number. I suspect you're right about...

Hi June

Andy's right you need some sort of order by clause or possibly a clusterd index, but I can't see how that would help in the example you've quoted.

Is it...

Hi Jan

Not quite clear as to your design problem.

Is it that you want a way of identifying database objects that belong to a specific web-service so that your php...

a propos of the usage of cursors, suggest you declare the cursor as FAST FORWARD since you are only scrolling forward and reading data, this will be more efficient than...

This is an intriguing query. Can you explain a little more as to what you're wanting DTS to do for you. Why, for instance, do you need to DTS to...

Didn't explain myself properly

SELECT * from [tablename]

LEFT OUTER JOIN [tablename2].......

WHERE [tablename.fldname_1] = [value]

AND [tablename.fldname_2] > [tablename2.fldname] (ONLY IF tablename.fldname is not null)

I have found it is possible to please all...

Thanks Dan. that's waht I thought, to be honest I've not noticed any performance gain using count(1) in SQLSERVER. I've seen a gain using the ROWS column from SYSINDEXES, but...

I'm not that clear as to what you're trying to do. Are you talking about Text as nText etc or a varchar.

Just a thought, You might find it more certain...