This does:

SSelect * From ClientDetails

Where InterviewDate IN (Select MAX(InterviewDate) From ClientDetails Group By ClientID)

Please just post the DDL of your table and some readily consumable sample data as a series of Insert Statements.

We'll provide the query for Pivot. post "only" the DDL of...

Phil Parkin (5/1/2012)

---

tt-615680 (5/1/2012)

---

Dear All,

Would anyone be able to let me know how to resolve the following error message please?

Msg 911, Level 16, State 1, Line 1

Database 'databasename' does...

GilaMonster (5/1/2012)

---

What do you mean by that?

Getdate...

You should be able to use all those features with the hardware you've mentioned.

CURRENT_TIMESTAMP is the ANSI standard method for getting date & time while GETDATE() is the T-SQL method.

Also GETDATE() returns the datetime specific to the database including the database time zone...

Sorry missed the group by Division part in my last post...here is the edited query:

;With CTE

As

(Select *, ROW_NUMBER() Over (Partition By DateOfBirth, SSN Order By ID) As Rownum From Employee)

Select...

Sorry missed the group by Division part in my last post...here is the edited query:

;With CTE

As

(Select *, ROW_NUMBER() Over (Partition By DateOfBirth, SSN Order By ID) As Rownum From Employee)

Select...

Have also posted the query in your original thread. Here it is again:

;With CTE

As

(Select *, ROW_NUMBER() Over (Partition By DateOfBirth, SSN Order By ID) As Rownum From Employee)

Select b.* From...

This will work.

;With CTE

As

(Select *, ROW_NUMBER() Over (Partition By DateOfBirth, SSN Order By ID) As Rownum From Employee)

Select b.* From CTE as a

JOIN Employee As b ON a.DateofBirth = b.DateofBirth...

04/30/2012 12:17:59.328 Attempting to determine security.config file path

04/30/2012 12:17:59.406 Checking to see if policy file exists

04/30/2012 12:17:59.422 .Net security policy file does not exist

04/30/2012 12:17:59.437 Attempting to create .Net security...

Please post the query and the Error that you get.

Great....good to hear that it worked 🙂

you're welcome..

I'm afraid I can't help you further. I'll keep looking. Will tell you if I find something.