sp_executesql works much the same way that a stored procedure would, the declaration of in, and out parameters is a little different, but concept is the same, except that the...

I probably wouldn;t use linked server.

Try opendatasource instead.

http://www.databasejournal.com/features/mssql/article.php/3331881

it is likely the query optimizer is preparing a goofy plan for the procedure.

Have you tried dbcc dropclean buffers?

or run the procedure the with Recompile option?

Or in the procedure. Modify...

Well,

You cannot pass record sets between stored procedures.

You ultimately will have to either use a temp table in the calling stored procedure, or use an openDataset or Openquery command

use temp...

Can U post a sample create table script, some sample data, and the update procedure your using, and what you want the end result to be, and I'm sure someone...

Your Description is a little confusing.

Can you post some example table definitions, Some sample data, and what you expect the results to look like.

Just guessing here, Try this.

CREATE PROCEDURE dbo.blablalba

(

 @AssignedSP...

I guess it depends on how much time you have, and how important this is to your company. Everyone wants some Ad-Hoc Reporting tool that allows the user to do...

There's no gotcha's in that way.

The only gotcha is if you have used the DATALENGTH function on any strings to test the lengh, this presents an integer in Bytes. Otherwise,...

Very difficult to explain the entire process in a forum thread, but using books online it supplies a bunch of information on how to handle suck a predicament

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_13_8y7n.asp

I'm not sure about your logic or business rules, but you cannot selectively fire a trigger based off a sproc.

You will prbably have to remove the trigger, and put the...

Well for this instance, Count(*) counts everything including nulls, Count(Processed) counts only non null values.

If you need to differentiate between Null, and other values then use a case statement

-- Create...

Substring does allow an expression,

Use charindex nested inside the substring function.

if you have more than 1 delimiter you would want 1 statement for each distinct delimiter

-- Create test table...

are you looking for tsql syntax for an if statement?

IF Boolean_expression

    { sql_statement | statement_block }

[ ELSE

    { sql_statement | statement_block } ]

IF (SELECT AVG(price) FROM titles WHERE...

This is known as a phenomena called parameter sniffing.

But related more to a cached query plan. the optimizer is guessing at the values your going to use, based off previous...

This is known as a crosstab query,

Lots of examples on this site,

Use Case statement, and probably a group by clause

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_04j7.asp

If you post your actual table, some sample data,...