If I am right, this should work:

DECLARE @jdate int

SET @jdate = 109252

select dateadd(dd, (@jdate - ((@jdate/1000) * 1000)) - 1, dateadd(yy, @jdate/1000, 0))

Can you provide a sample of a julian date for a date in 2008? I have an idea on how it is encoded.

Avoid the coversion of datetime to char to datetime. If you want to strip off the time (ie set it to 00:00:00.000) this actually works faster (there has been...

tiaanb (8/28/2009)

---

Hi Elliot,

I see what you're saying. So it is in fact better to remove 3 milliseconds for the end date. Then to remove 1 month from the end date...

Anybody else get an email via SSC from pboyall969@xxxxxxxxxx requesting help to purge all the tables in a database?

Slick84 (8/28/2009)

---

Hey Buddy,

You really need to use aliases! In your joins just assign each table a letter or point of reference that you think makes sense.

For example... Server.Database.SchemaName.TableName AS...

Partially correct in regard to the question as the question specifies SQL Server 2005 as well....

First, I wnat to thank you for taking the time to provide everything you did in setting up your problem. It really helped a lot.

Please let me know if...

Start here:

http://msdn.microsoft.com/en-us/library/ms161959.aspx

It would help if you took the time to do some research ahead of time. This information is also available in BOL.

Unfortunately, I didn't have time yesterday like I hoped. How are you going to approach this problem? Show me what you have and I'll try to provide some...

And with some of the OP's, that is what I do. What usually happens, though, is just as you say; someone else comes along and just provides an answer,...

GSquared (8/27/2009)

---

Lynn Pettis (8/27/2009)

---

I may agree to a point.

Asking this:

tells me you haven't even tried to find an answer yourself and...

2 Tim 3:16 (8/27/2009)

---

I believe as soon as you take a Snapshot of your mirrors or have any DB in a readable state, (whether you are using them or not)...

Show us. I can't tell you anything based solely on the description of the problem. It would also help to post the DDL, including indexes, for the table(s)...

I may agree to a point.

Asking this:

tells me you haven't even tried to find an answer yourself and want someone else...