Try using this procedure.  I just wote it and didn't even check for syntax but you should get the ides.

CREATE PROCEDURE usp_ExecuteMyProc

    (@ProcedureName       varchar(256)

    ,@Parameter1          varchar(1000) -- Use as manu...

I did some basic research and found the following SQL commands.  Look at READTEXT, TEXTPRT and UPDATETEXT.  From what I read this seems to allows you to read chunks of the ntext...

Your query looks right.  I'd add some more dates to the test and continue testing... but by-golie I think you've got it.

Well this gets you the max dates of each month not to include the first or last month.

SELECT   YEAR(dte)

        ,MONTH(dte)

        ,max(DAY(dte))

from     dbo.tst

WHERE    dte >= (SELECT DATEADD(day, (DAY(DATEADD(MONTH, 1, MIN(dte))) *...

Oops.  I just saw the requirement for Max of each month descending.  I'll have to think about this one.

What University are you attending?  This has got to be an academic...

Try this using the table 'dbo.tst' designed in a previous reply.

SELECT   *

FROM     dbo.tst

WHERE    dte           = (SELECT MIN(dte) FROM dbo.tst)

UNION

SELECT   *

FROM     dbo.tst

WHERE    dte           = (SELECT MAX(dte) FROM dbo.tst)

UNION

SELECT   TOP 4 *

FROM    ...

I assume you need to solve the problem and can then take time to analyse and discuss the problem.

First of all, locate all instances in your C++ code where you...

You are confusing CONSTRAINTS with INDEXES.

First of all a PRIMARY KEY is a CONSTRAINT that sits on top of a UNIQUE INDEX.  It is used in conjunction with FOERIGN KEY...

Is it more efficient on large tables to maintain a heap table with all non-clustered indexes than to maintain a clustered table with non-clustered indexes?

I didn't see your post before I posted my question.  See "Efficiency of non-clustered index in Heap Tables."  We can both find out what the answer is.

Yours,

SQL Server has been around for a while and the nerds developing SQL Server have already thought of your situation.

In SQL Analyzer create an SQL Statement that performs your agrregation. ...

Try the BeginTransaction property of the connection.  This will build an explicit transaction around the delete.  When the execute statements is finished then use the Rollback or Commit property.

If this...

You are correct.

Clustered indexes are indexes with root, non-leafed and leafed blocks.  The difference between non-clustered indexes (on table with clustered index) and clustered indexes is that clustered index leafs...

Good question!

I'd say it depends on who and how error resolution is going to be accomplished.  If network administrators are going to try and solve the e-mail error failure this...

There is a way to use permanant tables in conjunction with Dynamic SQL and SUSER_SNAME().

Each process can create it's own Permanant Table named 'mytable_' + SUSER_SNAME using Dyanmic SQL.

Since you...