> Running the declare before executing the stored procedure worked in Query Analyzer, but I don't know if that can be done from a .NET application. 

When you are building...

I've had the same problem in the past when I forgot to create any of the CHECK constraints on the partition columns using the WITH CHECK clause.  That's very important. ...

For your error in the first case:

   Server: Msg 137, Level 15, State 2, Line 1 Must declare the variable '@outparam'

Did you get this message when creating...

Take a look at GROUPING and ROLLUP in BOL:

SELECT CASE WHEN GROUPING(IVAN8) = 1 THEN 'All' ELSE IVAN8 END AS [IVAN8],
       CASE WHEN...

Views and stored procedures serve different purposes, it is difficult to compare the two.

The primary purposes of views is to simplify data access (by hiding the details of joining several...

If you see that you will often join the document table to the client table to look up client information using a DocumentID, when you have no need to also...

You need to include an ORDER BY:

ORDER BY [Header!1!Id], [Child1!2!Child1Id], [Child2!3!Child2ID], [blah!blah!blahId]

-Eddie

I rolled the following procedure a few years back for the same thing.  I place it in the master database and use the sp_prefix so I can call it from...

In order to use your package variables in the SQL task, you must set them up in the Parameter Mapping page when you are editing the task.

For example, I want to...

Integrity constraints are applied on a single row.  Your definition requires checking multiple rows to determine if a single insert is valid.

Enforcing it would require analyzing the full set of...

<SP Name> is a shortcut that works if it is the only line in a t-sql batch.

EXEC <SP Name> is required when there are multiple lines in the batch.

For a...

You can add a new containter to the end of your package, and place a Script Task in it to do the work.  Below is some basic code (sans error-handling,...

  You're shooting at a moving target.  The total CPU time a process uses is measurable.  But the CPU % usage is a state of something at a particular point in...

Unfortunately, I don't have Oracle installed on a SQL Server I can get to right now, but when I had to go through this in the past, the 'MSDAORA' provider...

If I really had to know whether Customer was a table or a view - and I usually wouldn't - it would not take very long to find out, in...