Sorry, missed the begin further inside the code.  I am reformatting your code to see what else may be going on.

Not really sure, but have you tried leaving off the the concatenation of 'END' from your dynamic sql?

Change your GROUP BY to this: GROUP BY dept_no WITH ROLLUP

It just won't say total under deptX

Without knowing the structure of your tables or the data contained, a little difficult to help come up with the solution you are looking for, however, I hope the following...

As you do not update anything on the other server inside the transaction, can you pull the information you need from the other server outside the transaction, then do the...

Two questions need to be answered first before I can try to offer some help.  First, are you attempting to update any data on the other server where your view...

I turned to dynamic sql, but I got a possible solution.  There may be other ways to do this, but I will leave that to the SQLServerCentral community to find...

This is where your knowledge of the data is important.  Are all the possible registers known in advance, or are each of them an unknown until there is an entry...

Here is one way, but it requires you know the data to setup the query:

declare @testtbl table (

    Material    varchar(10),

    Client      varchar(10),

    Files       smallint

)

insert into @testtbl values('Paper','Alex',123)

insert into @testtbl values('Paper','Gilbert',322)

insert...

Yes, each differential backup gets stored to its own file.  These files are backed up to tape nightly.  My transaction log backups get appended to the same file for each...

Opps.  Forgot a few changes to the second query.  Here is a corrected version of the second one:

SELECT

    cm.CustomerCode,

    cm.CustomerName,

    dca.Street1,

    dca.Street2,

    dca.City,

    dca.State,

    dca.Country,

   ...

If the query above doesn't work, here is another one to try:

SELECT

    cm.CustomerCode,

    cm.CustomerName,

    ca.StreetAddress1,

    ca.StreetAddress2,

    ct.CityName as City,

    st.LongName as State,

    cn.LongName as Country,

    ca.Zipcode,

    ca.Phone1 as Phone,

    ca.Fax,

   ...

You can overwrite an existing differential backup.  Restoring a database using a combination of Full, differential, and transaction log backups is a viable solution.  You only need the most current...

Currently you can't debug a stored procedure using SSMS.  At this time you have to have Visual Studio Professional or better to accomplish this very useful feat.  Personally, if you...

Not disputing that using the order by in a view defined with a select top 100 percent doesn't work in SQL Server 2005.  I am simply stating that it isn't...