Yes, there is. But it's not like "just add an output=EXCEL parameter"...

An example can be found here [/url].

Another option using an DTS package can be found here...

I didn't mention to get the column information from the flat file you've been talking about.

What I've been talking about is to export the relevant column definitions from the Cache...

Is there any specific reason you have to use flat files (e.g. large amount of data using the performance gain of bcp)?

Would it be possible to add the Cache database...

Isn't that an expected effect when running a DELETE statement? :ermm:

If this...

Hi,

attached please find a SQL2000 compliant solution. As far as I can see you need to use a subquery to get the order of the names...

Just out of curiosity: What's...

Would you mind to provide some sample data as an attachment so we can test if a solution someone may think of actually works and is giving the expected result?

20...

Please don't cross post.

Answers please here .

You're welcome. Glad I could help. 🙂

Would something along those lines help?

SELECT ar.ArchiveID,

PublishedPosition,

MAX(ar.SequenceID) AS SequenceID

FROM dbo.tblArchiveRecords ar

INNER JOIN dbo.tblPublishPosition pp

ON ar.ArchiveID=pp.ArchiveId

GROUP BY ar.ArchiveID,pp.PublishedPosition

/*

ArchiveIDPublishedPositionSequenceID

1-9223372036854775808-9223372036854775806

2-9223372036854775808-9223372036854775803

3-9223372036854775808-9223372036854775800

*/

As always, the answer is "it depends".

If you refer to the first option in the article for deleting just one row I would agree that this is the best way.

What...

Hi,

in addition to your DDL statements please provide sample data together with expected results and what you've tried so far.

For details on how to post sample data please see the...

He's back... ->...

You might have a missing index issue (probably missing for your temp table).

We can't tell for sure since there is no more information available from your site.

Please read and follow...

triple post.

please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...

triple post.

please see here and here . All posts have one answer so far, making it hard to tell where to continue if required...