In SQL Server integer math 22801/12 = 1900 = 22800/12 😀

Something like this should do what you want:

select

a.*

from

OPENQUERY ( RHSQL ,

'

Select

Brook2.dbo.GetCurrentAdmissionDate(1) as AdminDate,

Brook2.dbo.GetDOTFromDOA(1),

Brook2.dbo.GetCurrentAdmissionDate(1) as DischargeDate

from

Brook2.dbo.Admission

' ) a

Note that you will have to build the whole query dynamically to pass the...

If anyone is wondering where 22801 came from:

Make Date function (like in VB)

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22339

Although I would have assumed that anyone would realize without explanation that 22801/12 = 1900 😉

Dan Guzman - Not the MVP (10/28/2010)

---

Michael Valentine Jones (10/27/2010)

---

Dan Guzman - Not the MVP (10/27/2010)

---

So, is this the simplest and quickest way to get the last day of any...

Ninja's_RGR'us (10/28/2010)

---

Michael Valentine Jones (10/28/2010)

---

Ninja's_RGR'us (10/28/2010)

---

Michael Valentine Jones (10/28/2010)

---

Ken McKelvey (10/28/2010)

---

While snapshot isolation can be very useful, you should google 'write skew anomolies', check your code and do a lot...

Ninja's_RGR'us (10/28/2010)

---

Michael Valentine Jones (10/28/2010)

---

SQL Server handles...

SQL Server handles this the following way:

Understanding...

Ninja's_RGR'us (10/28/2010)

---

Michael Valentine Jones (10/28/2010)

---

Have you verified you are using the normal read committed isolation level for both transactions?

Have you tried setting your database to use row-version isolation?

ALTER DATABASE MyDatabase...

You need to design the database to model the reality of the data as closely as possible. If there is a many to many relationship, even in a small...

Have you verified you are using the normal read committed isolation level for both transactions?

Have you tried setting your database to use row-version isolation?

ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE...

The database design has to be able to handle all cases. Even if 99.99% of cars have only one owner, you need to allow for the 0.01% where there...

The script on the link below does a very good job of this without making any schema modifications, so it is a safer way to go.

Truncate All Tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341

Dan Guzman - Not the MVP (10/27/2010)

---

So, is this the simplest and quickest way to get the last day of any month?

DATEADD(MONTH,x,'2010-Jan-01')

Where x is the month you are looking...

Toreador (10/27/2010)

---

Hugo Kornelis (10/27/2010)

---

For the datetime data type, The only formats that are guaranteed to work correctly in all circumstances are:

* yyyymmdd - for dates without time portion. No dashes....

Ray K (10/26/2010)

---

Speaking as someone who has collegiate...