You can use ROW_NUMBER() to achieve the desired results

SELECT*

FROM(

SELECTROW_NUMBER() OVER ( PARTITION BY Client.ID, Patient.SSN ORDER BY StartOfCare ) AS RN,

Client.ID, Client.ClientName, Patient.ClientID, Patient.SSN, Patient.StartOfCare, Patient.PrimDiag

FROMClient Client

INNER JOIN Patient Patient...

This should help you

DECLARE@table TABLE

(

IDINT,

StartDateDATETIME,

EndDateDATETIME

)

INSERT@table( ID, StartDate, EndDate )

SELECT1, '2013-02-17 10:33:10', '2013-02-17 20:14:40' UNION ALL

SELECT1, '2013-02-13 12:42:55', '2013-02-14 14:30:50' UNION ALL

SELECT1, '2013-02-12 15:04:32', '2013-02-15 12:22:25' UNION ALL

SELECT1, '2013-02-16 20:08:18', '2013-02-18...

My version

DECLARE@date DATETIME

SET@date...

Compassionate (2/5/2013)

---

folks,

i have 10 to 20 tables to be joined to get required results but i heard joins on so many tables is not an ideal option. could you tell...

bhushan_juare (2/4/2013)

---

[font="Courier New"]Hi All,

I Have table where it includes fields model_size, model_type, actual_qty, process_qty, order_type. Now I want to display all fields + model_size who has order_type = 'Some X'...

If you are confused, ask the question in the forum that seems best fit according to you

As far as your question is concerned, I think you can ask your question...

Great Question. But the link provided has no information specific to this behavior.

You did not get any results because you probably did not have records in table "Tickets" where "Reported_by = Assign_to"

SELECTUsersTbl.Name AS first, UsersTbl.Name AS second

FROMTickets

INNER JOINUsersTbl ON Tickets.Reported_by = UsersTbl.Id...

A nanosecond (ns) is one billionth of a second (10-9 or 1/1,000,000,000 s)...( From Wikipedia http://en.wikipedia.org/wiki/Nanosecond )

As an example, a variable with data type TIME may store a data like...

Any particular reason for avoiding the use of sp_MSforeachdb?

You can implement this with Dynamic SQL as well

DECLARE@TableName VARCHAR(100), @sql VARCHAR(1000)

SET@TableName = 'agent'

SET@sql= ' SELECT* '

+ ' FROM ' + @TableName

+ ' WHERE ' + CASE WHEN @TableName IN...

scotdg (1/10/2013)

---

I browsed tha article and to be honest I am not sure I know enough SQL to write what I am trying to do in a way that would...

venki83k (1/8/2013)

---

Hi

I am executing this against database i got above error .

Basically using this to track db growth of all database on a server.colud you please suggest anybody on...

In SQL Server 2008, there is a concept of filtered indexes.

You...

You can look up INNER JOIN and GROUP BY Google or Books Online

Using these two concepts, you can get the desired result

If you face any further issues get back to...