BTW I want the name in different columns.

First name - Mary
Middle Name - B
Last Name - SMITHThanks

Sorry I mean I have a hard time to get the middle name.
Thanks

Thanks it worked.

BTW mine does not work because one of the parameter is datetime value.

I don't quite understand about the following steps.

Create a third report parameter which does not allow blank or null values.

Set its available values to be sourced from a dataset and...

Thanks it worked.

No it is just the data problem.

Yes the query is part of the stored procedure.

As I said before, the database is created from the software company, I cannot create any index.

Here is the actual execution plan with option recompile.

Thanks

This is the real query. The second insert took a long time and the table I posted is actually [cnsmr_accnt_ar_log]

DECLARE @Date1 DATETIME,

...

Here is the execution plan with option recomplile

I attached two execution plan - one with parameter, one without.

Here is the create table statement, this table is created by the software company so I can't change anything.

CREATE TABLE [dbo].[user_log](

[user_id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[actn_cd] [smallint] NULL,

[user_accnt_id]...

It is not I don't want to provide the information, but I can't post my company info on the website. I am trying to provide the info with a twist...