First and last based on same SQL

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

First and last based on same SQL

Message

From

10/10/2014 02:36:45

Walter Meester
HoogkarspelNetherlands

10/10/2014 02:15:52

Kevin Goff
Pennsylvania, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: First and last based on same SQL

Environment versions

SQL Server:

SQL Server 2012

Application:

Web

Miscellaneous

Thread ID:

01609079

Message ID:

01609113

Views:

>>
>>Be aware this will give problems if there are two invoices on the same date. Better us TOP 1 in the correlated selects
>
>Yes, and if you'll notice, up a few lines in my reply I mentioned that - yes, a TOP 1 is needed if there are 2 values for the same date or datetime.

Err... my mistake... I only read the code...

Map

View

Click here to load this message in the networking platform