sammyIT (7/11/2012)

---

Sorry about that.

Table "Product" has items with descriptions.

Table "Keywords" is a running list of keywords that we would want to exclude from the outcome of some queries.

What I...

This has pretty much every format imaginable for datetimes. http://msdn.microsoft.com/en-us/library/ms187928.aspx

cjcolton (7/10/2012)

---

Hey Bob,

Thanks so much for your help; just to clarify, is the first step is to create a new table with the same records but a new primary?...

As Jason already said you need to wrap your sum with an ISNULL.

Select ISNULL(SUM(ISNULL(Amount, 0)), 0)

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