You're welcome, thanks for the feedback.

Something like this?

WITH RandimisedResults AS (

select CaseNumber, AgentName,

rn = ROW_NUMBER() OVER (PARTITION BY AgentName ORDER BY NEWID())

from dbo.CaseSummary

where CaseDate >= @DateFrom

and ...

SELECT *

FROM customers c

INNER JOIN tickets t1 ON t1.CustId = c.CustId AND t1.[subject] = 'info'

INNER JOIN tickets t2 ON t2.CustId = c.CustId AND t2.[subject] = 'problem'

WHERE t2.ticketDate >...

Paul's article shows an efficient and rigorously tested method for doing this.

SQLRO (5/20/2011)

---

Hi Chris,

Thanks for the reply.

The records will not be actually preassigned. The records will be allocated sequentially& dynamically i.e. any top 10 records should be assigned which are...

Hi Rohit

This looks like a scheme for selecting and using preassigned numbers for use as identity values in a table - is this the case?

Cheers

ChrisM

ursfriend77 (5/16/2011)

---

SELECT md.number,sd.description from main_data md,sub_data sd

WHERE 1=1

AND md.vendor_id=sd.vendor_id(+)

AND md.inventory_id=sd.item_id(+)

Here i am using 2 tables main_data and sub_data, as for join rules we have to give n-1 join conditions,...

Check your data and then your code. The method works just...

How does the system deal with VAT?

Is the datatype really varchar? If it is,...

Ninja's answered the question you originally posted - it's straightforward enough to write a query which will do what you are asking.

Expanding upon his comments, you need an intimate knowledge...

How confident are you that a column in one table which has a name matching the pk column in another table is a foreign key?

Work on the inner query

select stud_code,count(*) Num_Absences

from StudAbsent

where Absent_date between @StartDate and @EndDate

and cmpy_code='10'

group by stud_code

having count(*) > 2

until you are certain that the result...

:laugh: :laugh: :laugh:

GilaMonster (5/10/2011)

---

Any order you like....

Is 29,999,999,997 rows representative of the data you wish to model? Or, with 10 names to start, 99,999,999,990 rows? Is the data itself representative?