there is no XML Editor in SQL 2005, unless if you are referring to the SQL Query Editor.

You can draft your xml files in the query editor, and then update...

its probably better for you to create a .net assembly which calls the compression program.

to what format are you compressing into?

Which SQL server are you looking at?

If SQL 2005 then

Firstly, yes you can connect to a live stock feed using .Net Assembly/CLR integration

secondly with out knowing further details about your...

are these sql 2000 DTS packages on SQL 2005. Try to reinstall the Microsoft SQL Server 2000 DTS Designer Components that are part of the Feature pack

http://msdn2.microsoft.com/en-us/sql/aa336314.aspx

why not try to use the IF...Else statement. I am thinking you want to use sort expressions which are mutually exclusive

try to use sql authentication.

the problem you are getting is most likely due to the network configurations on your machine.if you try to access a folder on your sql...

or rather just concatenate your columns with out bothering with the cursor

----------------------------

SELECT

'FileNumber = '+ cd.casedatauid +

you have to many columns in your query and yet you are trying to assign them to @tableHTML

see my example below

----------------------

declare

@greeting varchar(

are you dealing with definite instances of time (point in time) in a range or period in time (time range)?

hi,

can you post your script or

 get the latest service pack

http://support.microsoft.com/kb/834688

the statement which is proper depends on your system requirements specification. What are you supposed to show on the report?

Have a look at your query execution plan to determine were its spending a lot of time.

Thanks Peter that worked a treat.

I had tried using convert() using 120 but that failed as well. Had been a bit afraid to use the DATEFORMAT thingy because the column...

create a new table with a similar structure and then selecting your old data ordering by date inserting into the new table. rename your old table and rename your new...