I take it that you've looked at the missing indexes suggested by the query optimiser?

/*

Missing Index Details from

The Query Processor estimates that implementing the following index could improve the...

Looks like Mark beat me to it, but here were my thoughts.

First, we need a row number in the sample data to guarantee row ordering (as mentioned before). For this,...

Have you no row number? Or time stamp? Really, to guarantee that the results are correct we need to be able to have some way of determining the row order....

--== SAMPLE DATA ==--

SELECT stockcode, order_count, qty_required, location, release

INTO #yourSampleData

FROM (VALUES(231756, 9, 12, 1, 'N'),(231756, 2, 2, 1, 'Y'),

...

OK, this is a skeleton and would need editing to include however many params that you want to go in there.

IF object_id('tempdb..Equal') IS NOT NULL

BEGIN

DROP FUNCTION...

_simon_ (11/28/2012)

---

@Cadavre: The function should be able to compare multiple values (for example up to 20), then I would need to write a lot of 'default's to compare just 3...

If you could post some sample data and ddl scripts as per this article --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D, then I'm sure lots of people would be happy to help. Otherwise, we're just...

_simon_ (11/28/2012)

---

Yes, with stored procedures this is easily achievable, but I cannot use it in scenarios like:

declare @t table (Id int, I1 int, I2 int, I3 int, I4 int, I5...

deba_20032004 (11/28/2012)

---

Dear Sir,

I am in great trouble, I have a table which contain two fields my table structure is

ColumnName DataType

ProductId...

Why do you need the temporary tables?

SELECT TOP 10

[OS WAIT STATS - WAIT TYPE] = a.wait_type,

[TASKS WAITING COUNT] = a.waiting_tasks_count,

[TIME WAITING (MS)] = a.wait_time_ms,

[MAX TIME WAITING (MS)] = a.max_wait_time_ms,...

No cursor required.

Try this: -

SELECT...

freecoder (11/26/2012)

---

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.

A user can...

Another option, based on your description.

DECLARE @searchParam VARCHAR(9) = 'YYY';

SELECT CLIENTCODE

FROM (SELECT CLIENTCODE, CASE WHEN MAX(b.TIDM) IS NULL THEN 1 ELSE 0 END

FROM #holding...

Hello and welcome to SSC,

If you could knock up some sample data and DDL scripts, then your expected results based on the sample data provided that would be extremely useful...

Firstly, when you ask a question it is polite to provide readily consumable sample data like this: -

--==CONDITIONALLY DROP THE SAMPLE DATA TABLE==--

IF object_id('tempdb..#yourSampleData') IS NOT NULL

BEGIN

...