I don't want to duplicate my posts, so please be sure to read what I posted on the other thread before responding here.

And he posts it more than once!!

Also, please replace SSN's with something non-identifying, like a unique integer value or guid.

Well, well, well, the White House Window Washer is back and still doesn't know how to give us everything we need to help him and he posts something he really...

First, I hope the SSN number you have in the code above is either yours or a bogus number.

Second, without the DDL for the tables, sample data, and expected results...

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...