also, please give us the reasons for not wanting to use Dynamic SQL, don't make us grope around in the dark.

What is the format of @ordercol?

emily:

Why do you want to cram two different functional tasks into one procedure? Thats been bad design in software development for over forty years. This obviously belongs in...

It's sad, when the cure is worse than the disease.

Oh well, I'll be killing swine and birds all weekend for...

In what context do you mean?

Huh, thats odd. When I tested it on my system this morning, with a million rows, no GROUP BY (did I miss that requirement?) and an index on...

Glad we could help, Randy.

This seems a bit more efficient:

SELECT

date_value = CASE WHEN (COUNT(*) > COUNT(date)) THEN NULL ELSE MIN(date) END

FROM test

🙂

RBarryYoung (2/24/2010)

---

Paul White (2/24/2010)

---

RBarryYoung (2/23/2010)

---

Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see...

Paul White (2/24/2010)

---

RBarryYoung (2/23/2010)

---

Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if...

Heh, I hadn't even noticed...

If you want to see what a SPID is doing, then Profiler/trace is how to do it.

Sorry, but I do not have any Java Persistence API experience. And yes,...

Paul White (2/24/2010)

---

RBarryYoung (2/23/2010)

---

Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if...

mansshah (2/24/2010)

---

I have tried buffering the data and updating them in a second duration with XML datatype. It has improved throughput 3 times with single connection. I have also implemented...

mansshah (2/24/2010)

---

Table Definition:

=====

CREATE TABLE [dbo].[FLOAT_DATA](

[FD_TAG_FK] [int] NOT NULL,

[FD_DATETIME] [datetime] NOT NULL,

[FD_VALUE] [real] NULL,

[FD_UNIT_FK] [smallint] NULL,

[FD_QUALITY] [tinyint] NULL,

CONSTRAINT [PK_FLOAT_DATA] PRIMARY KEY CLUSTERED

(

[FD_TAG_FK] ASC,

[FD_DATETIME] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...