What differentiates 720 as AM vs PM?

count(distinct i.inv_NUMBER)

As with anything in SQL, it depends. This is more than one way to get the desired results and my suggestion is in no way intended to be taken as...

SQLKicksButt (1/23/2012)

---

Jason, that is an outstanding design you have suggested. I think that will work very well. I think it also handles Chris' concern over limiting to 40 properties. Each...

Break down the properties into their own set.

Something similar to ...

Applicance

ApplianceId INT

Model VARCHAR(50)

Manufacturer VARCHAR(50)

...

Because the MONEY data type only goes out to 4 decimal places. The extraneous value of 0.00004608518933991 is dropped by rounding.

SET nocount ON

DECLARE @num1MONEY

DECLARE @num2MONEY

DECLARE @num3MONEY

SET @num1 = 2642.7100

SET...

...and if you decide to use SQL and not move this pivot to the presentation layer. What you would do is pivot with two seperate statements and join them. Either...

Please read the article referenced in my signature. It will help us help you. 🙂

Adding to the above suggestions. This site is a huge resource. Monitor the active threads as much as you can. If someone posts a question you don't know the answer...

Sounds like an ideal situation for a Report Model. There are numerous tutorials available if you google it.

good catch, we need to also include the date. One way to do this is to get the number of days since 1/1/1900

SELECT

*

FROM

(

...

SQL Kiwi (1/16/2012)

---

SELECT

Segmented.ID,

Segmented.UserID,

Segmented.Location,

Segmented.LocationDate

FROM

(

SELECT

...

So what happens in the case of identical rows that chain longer than 5 minutes?

i.e.

123,‘Columbus’,‘1/5/2012 8:00 PM’

123,‘Columbus’,‘1/5/2012 8:04 PM’

123,‘Columbus’,‘1/5/2012 8:08 PM’

123,‘Columbus’,‘1/5/2012 8:12 PM’

They all occur within 5 minutes of each...

Please read the post linked in my signature. This will help us help you. 😛

Another tool to keep in mind is the SQL Server Migration Assistant (SSMA) found here.

It may not show you the differences, but may help in your overall project/scope.