If my guess is correct, try:

SELECT TOP (2)

EmpName,

MAX(EmpCommentsDate)

FROM @Employee

GROUP ...

I'm happy to write SQL for you,...

Well I hope you get enough time to try both - at least...

CirquedeSQLeil (4/3/2010)

---

If you query a large table joined to another table that does not have proper referential integrity in the database, data accuracy is thrown out the window. Furthermore,...

PaulB-TheOneAndOnly (4/2/2010)

---

sumit.joshij (4/2/2010)

---

SO when we create the relation between the PK and FK it check the statistics for PK and FK. it can take time for a huge tranasaction database...

You appear to be backing up multiple databases in one step...?

The first log entry shows State_Revenue_Dev being successfully backed up.

The second entry shows a failure for State_temp_Rev.

The log output generated...

It's not exactly clear what output you expect here - especially since there aren't any duplicates in the test data.

The problem, though, is one of logic: you want the top...

You just need to prevent the race condition.

The following code demonstrates a safe implementation:

USE tempdb;

GO

-- Create the sequence table

CREATE TABLE dbo.PrimaryKeys

(

...

RAR is a great choice - after all, it doesn't take 10 minutes to locate, download, and...

peter.roothans (4/2/2010)

---

Further analysis shows I have to improve datatype castings (float to varchar, ...) en NULL value comparison. '' or 0 is not equal NULL and neither NULL is...

This means you are not connected to a SQL Server 2008 server.

The important thing is the version of the...

An example might help:

USE tempdb;

GO

-- Test table

CREATE TABLE dbo.Test

(

row_id ...

You could do that...but it would be very silly and completely unnecessary 😛

As...

Hey Ron,

Have you every looked...

alen teplitsky (4/1/2010)

---

with 32 bit you are limited to 4GB for the process and anything above 4GB is just for caching execution plans. in reality with OS overhead you will...