Nils thats becuase its not in there yet. Thats part of my version2 design for...

Dave Ballantyne (10/7/2010)

---

ALTER PROCEDURE [dbo].[uspListExecutionTransaction]

(@SessionKey UniqueIdentifier) AS BEGIN

SELECT * FROM EXECS.tblExecutionTransaction WHERE SessionKey = @SessionKey

END

Assuming that EXECS.tblExecutionTransaction is a table with an index on sessionkey, then caching of plans...

Nils Gustav Stråbø (10/7/2010)

---

That query looks like, I'm saying looks like because I really don't know anything about the distribution of SessionKey values, a good candidate for a cached plan....

USE [ACCDB]

GO

/****** Object: Table [EXECS].[tblExecutionTransaction] Script Date: 10/07/2010 10:53:02 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [EXECS].[tblExecutionTransaction](

[TransactionKey] [uniqueidentifier] NOT NULL,

[ExecutionKey] [uniqueidentifier] NOT NULL,

[SideKey] [int] NOT...

Dave thanks for suggesting those two articles, Gail those articles you wrote helped me a lot understanding my problem.

Let for a minute assume that the problem could be a design...

ALTER FUNCTION [dbo].[fnUserExecutionKeyList]

(

@StatusKey INT = NULL,

@Strategy INT = NULL,

@DateKey INT = NULL

)

RETURNS TABLE

AS

RETURN

(

SELECT ExecutionKey FROM EXECS.tblLineUp

INNER JOIN EXECS.tblLeg ON tblLeg.LegKey = tblLineUp.LegKey

INNER JOIN EXECS.tblTrade ON tblTrade.TradeKey...

Thanks that link might do the trick.

And by the way - taking "sample data" from the database I'm working on, will consume to much of my time as it is...

It a really big procedure.

Problem with indexes (as far as I found out) is that you have to plan them carefully. They can sometimes be useless or even harmful to...

I have also been searching for a solution regarding this issue. I cant believe that MS SQL overlooked the fact that they needed to make it easier to insert values...

I have considered the triggers at a certain point.

But the Portfolio Manager will not just send one order and expect the Execution Manager to pick it up. It can send...

Thanks for all the feedback guys.

Appreciate it. 🙂

I figure that ...

Guess I'll just have to do without that for a while.

Ok ... so the database isn't as big as I thought. The biggest I ever worked on before was 800MB in SS2K.

The company are currently running SQL 2005 Standard Edition,...

The first problem there is you skipped a step - getting a FLOAT value to a STRING value.

Seeing as CONVERT AND CAST does it own freakish form of rounding...

This seems to do the job. Although process seems to be little over the top.

[font="Courier New"]

CREATE FUNCTION dbo.fnCutOff(@Value FLOAT, @Digit INT) RETURNS FLOAT AS BEGIN

DECLARE @IntValue BIGINT

DECLARE @CharValue NCHAR(50)

SET @IntValue...