Dev (12/5/2011)

---

I have another equation. 😉

UTC_Time = LocalTime +/- UTC_Offset

The difference here is you are taking UTC as base where as I am taking...

bwoulfe (12/5/2011)

---

Sean Lange (12/5/2011)

---

bwoulfe (12/5/2011)

---

Sean Lange (12/5/2011)

---

I guess the way you store your date information will be somewhat dependent on how you are using it. Personally I like to store...

bwoulfe (12/5/2011)

---

Sean Lange (12/5/2011)

---

I guess the way you store your date information will be somewhat dependent on how you are using it. Personally I like to store everything in UTC...

Well then much like your transactions it is most important that you store all your data in the same base (timezone or currency). Then you figure out how to display...

Languages and timezones are not the same thing. You can two people standing next to each other that speak different languages but are obviously in the same timezone. Or you...

I assume you mean multiple timezones not languages? It is best if...

An insert statement? Seriously though, you need to provide a bit more detail. Are you trying to figure out how to store them? Since you are on 2005 the best...

marge0513 (12/2/2011)

---

Yes, that makes sense. That tells me why the "Distinct" does not work in this case.

I would need to show all activities for every file and not just...

marge0513 (12/2/2011)

---

Thanks for responding!

Yes, you are correct. If "Cindy" had only downloaded the file and that was all that was recorded for that file then one row would be retrieved...

marge0513 (12/2/2011)

---

Hello everyone, I have this SQL that returns the correct amount of rows which should be 2:

Select Distinct A.File_Name, A.File_Desc, A.file_location,

A.location_date, A.downloaded_date, A.downloaded_id, A.file_size, ...

kyle.doouss (12/2/2011)

---

I need to create the following for a fixed width file. I haveput the script I am using and the error I am getting. Any idea?

Some of...

Phil Parkin (12/2/2011)

---

The easy way to find which column is the problem is to change the Insert statement into a Select Into using a temp table as the target, then...

DOH! I forgot the one I posted is strictly for images (not exactly going to work for you).

Just remember that without an extra sort column you can't be sure what order they will appear.

;WITH CTE AS

(

SELECT Number,Type,Name,ROW_NUMBER() OVER(PARTITION BY Type ORDER BY Type, Name...

nancy g (12/1/2011)

---

Sean good question. The multiple rows are NOT versions. There are actually more columns in the db than I posted and one of them is [version]....