Hi Bob

Yes, if you want to use a pivot you have to define an aggregation between the X and Y axis.

If you just want to show the data of your...

Hi Bob

In your case (32/10 matrix) I wold do it within the report. The graphical interface is more simple to handle and has more features.

Greets

Flo

Hi

Maybe you should have a look to database replicatin and mirroring.

Greets

Flo

Hi Juwel

Try this on your SQL Server (connected over local host 😉 )

PRINT @@SERVERNAME

Greets

Flo

Hi Juwel

I know this from other versions of SQL Server. Have a look to the SQL Server Configuration Manager at:

"Start"->"Programs"->"Microsoft SQL Server 2005"->"Configuration Tools"->"SQL Server Configuration Manager".

On left tree go...

Not with SQL Server on-board means. Thats the reason for SSIS. Sure you can write any external program or script to handle this.

Greets

Flo

Hi

There sizes is only some MBs but it will depend on the things you are doin'. Especially the tempdb may become huge while working with the server.

Why does this sizes...

Doesn't matter. Sometimes I would wish to forgett only this. 😀

Hi

I thought the part "I don't want to mess with temp tables, but rather find more elegant way to do this." was more a general statement than a specific requirement....

Hi

Not yet an answer to your question...

Could you post your table definition DDL. Then we can investigate the problem.

Greets

Flo

Hi

And my one 🙂

[font="Courier New"]

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

SET @sql = ''

SELECT @sql = @sql +

      CASE WHEN @sql = '' THEN '' ELSE ' UNION ALL ' END +...

Hi

I really didn't want to discredit your reply! How should this happen? SQL and data will be send over networkt and in my oppinion any information about the bit-rate of...

Hi

I would like to affirm Perry. If you do not components of the third party application on the same server as the SQL Server it doesn't matter if the application...

So I think the only way may be an IDENTITY column within your destination table to extend the primary key and remove the duplicte values after the insertation.

Greets

Flo

Another way (which seems more simple in my oppinion):

* Use the BCP, no matter if any data are availale but to another directory

* After that use xp_cmdshell again to execute...