asm1212 (7/10/2012)

---

I apologize for the way I presented my question...I do realize you all are just volunteers and I appreciate everyones work on the website...I have been helped many times...

You should take a look at what the columns mean. http://msdn.microsoft.com/en-us/library/ms186782.aspx

asm1212 (7/10/2012)

---

Not sure what else you want...

I gave you my expected result set, the query I was using, and the result set it gave back...

Does it look like what is...

phoeneous (7/10/2012)

---

I can retrieve the results just fine, it's when I have to do the sale.DollarX summation that is a problem.

See attached screenshots.

Notice that sale.Dollar5 is $50 and the date...

Take a look at the first link in my signature about best practices. You need to post ddl, sample data and desired output.

Welsh Corgi (7/9/2012)

---

I mentioned using the DataTimeOffset and they did not like that one.

If I have a TimeStamp in Oracle then why I should not use a DATE2 Datatype to...

Me neither, plus I figured it had been done before so I just used a little Googlefu. The solution I found was a scalar udf but hey, it is sql...

Lynn Pettis (7/6/2012)

---

I'll have to defer on modifying this to work on SQL Server 2000 to someone who still works with SQL Server 2000. I haven't touched a SQL...

This post from MS shows a way to do this with a UDF in 2000. From your sample data this should do exactly what you are looking for. Just make...

Well you did post this in the sql 2008 forum. 😀 This type of formatting really should be left to the front end to deal with. It is not that...

Please don't start a new thread with the same content as your other one. Please direct all replies to the original thread here. http://www.sqlservercentral.com/Forums/Topic1319707-391-1.aspx

Sounds like you either have too much text (6 characters into a 5 character field) OR you have characters that won't work in a varchar field (Meaning characters from the...

Well the last day of September is always the...

challapal (7/6/2012)

---

string starts with 3 digit same number Example 111Y,333Y, 555 H etc

string starts with NULL

string that starts with sequential digits Example 123g, 567jku

string that...

mtassin (7/6/2012)

---

Nah that gets you a point post... if you look at your correctness...