Basically the trigger action has to complete before the asp finishes because those actions are part of the transaction. If you need to delay that, you can flag a...

never seen that happen...

How are they changed??

do you kow you can see the generated script and manually change it?

Check out the import data wizard... really simple.

What do you mean by not matching??

Let's start over, send me :

- tables dll

- sample data (insert statements)

- sample results

- current results.

HTH, make sure that the numbers table is high enough. I'm assuming here that the qty of products sold on a single order may go higher than 8000.

SET @Param1 = ISNULL(@Param1, '') + '%'

SET @Param2 = ISNULL(@Param2, '') + '%'

SET @Param3 = ISNULL(@Param3, '') + '%'

if LEN(@Param1 + @Param2 + @Param3) > 3

begin

Select cols, list from dbo.YourQuery...

Not where it should be (or still missing some).

Also please forget the dev and split this into 3 sps. If he still insists, you can always all the sps...

Don't do that in dynamic sql, you'll be totally be missing the point of sps.

update tablename set colname = @Value where key = @key

Also read this :

As requested per PM :

Not really in this case. I'd go with 3 queries in this case. Maybe I'd have a master sp call the correct sp...

Ok course... their code works, they can't imagine that it can be slow and working at the same time .

Sorry I completly forgot to include the script for the numbers table.

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1) primary key clustered, dude bit null)

GO

INSERT INTO dbo.Numbers...

You might find this article usefull for such questions :

Dynamic Search Conditions in T-SQL

Here's how I'd do it. The only missing part is the insert to input the data into a new table.

Declare @demo table (OrderId int not null, ProductID int...

I don't think they even invented a datatype to hold such a number .

What did you put in for the group by?