a

USE [Orderex]

GO

/****** Object: StoredProcedure [dbo].[GetReverseHoldingsByStockTIDMDetailed] Script Date: 11/30/2012 12:06:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Alter PROCEDURE [dbo].[GetReverseHoldingsByStockTIDMDetailed]

(

@user-id as varchar(7),

@LoginType as varchar(5),

@AccType varchar(3),

@AccountActive varchar(1),

@SFAClientType varchar(20),

@TIDM varchar(7),

@SEDOL...

d

thanks mate..I am just going in a meeting at 11. Will get back to you. Actually I can removed the 'ALL' parameter from the query. But some on the remiser...

deleted

I cannot change the table def. Let me try crazyss answer.

CREATE TABLE [dbo].[Client_oe_info](

[Acct_no] [varchar](7) NOT NULL,

[Client_name] [varchar](70) NOT NULL,

[ClientShortName] [varchar](60) NULL,

[Remisier_code] [char](7) NOT NULL,

[ADDRESSCODE] [decimal](18, 0) NULL,

[Branch] [tinyint] NULL,

[Acct_type] [char](1) NULL,

CONSTRAINT [PK_Client_oe_info_1] PRIMARY KEY CLUSTERED

(

[Acct_no] ASC

)WITH (PAD_INDEX ...

ok I have attatched the execution plan for actual stored proc.

Hello I have completed the post. How do I attach the execution plan in here?

sorry if i was unclear.

basically I am writing a stored procedure for a user to check if a certain clientcode does not hold a certain tidm.

CREATE TABLE #holding(

[TIDM] [varchar]...

use like

something like.

(name like '%' +@name + '%' name is null)

when total < 100 then '< 100'

when total >= 100 and total < 1000 then '>= 100 and < 1000'

when total >= 1000 and total < 10000 then '>= 1000...

Sorry I am back again. I need to manipulate the order in which the value is displayed. Is it possible>?

Hey anthony thanks for the reply. The query works fine but I was just curious about the with clause as I have never used it before. can you through some...

??