This is essentially a running total. Jeff has a very good article on calculating running totals: Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url]. Be sure...

I don't think that there's any hard and fast rule. It depends mostly on what your business needs are. If you need a lot of detail, then you'll...

I didn't even get that far. I saw that:

* There was no sample data

* There were no expected results

* There was no definition of the "correct...

Hugo Kornelis (12/14/2011)

---

* Schema - when you don't specify a schema when referencing an object, SQL Server will, if I recall correctly, check your default schema first (which by default...

I was about to post almost exactly the same query. The only difference was that I used an INNER JOIN rather than an EXISTS for the portfolio. Depending...

Cadavre (12/14/2011)

---

I felt you needed a reply, as you've provided us with DDL and sample data so I've had a go.

There's a possibility I haven't understood your problem correctly, so...

I have to ask, "WHY?!?!" By default, SQL is case insensitive. ...

The best way to learn is to try it for yourself. Report back on what you find.

Drew

As others have said, this is an issue with what the UI (SSMS) is displaying not with the actual data. This is one of the reasons that I prefer...

First, I want to mention that there are several issues that I see. It looks like you have represented times using strings. If you are measuring durations, you...

The DATE data type was introduced in SQL 2008. That's why you can't find it on your SQL 2000 database.

Drew

He did post usable DDL.

Why? This is a dialect specific forum and...

Use a CROSS APPLY. You can also use a CTE with ROW_NUMBER(), but I've found that the CROSS APPLY tends to perform better.

SELECT Item_No, Item_Desc_1, Item_Desc_2, Trx_Dt, Doc_Ord_No, Vend_No,...

ALZDBA (12/9/2011)

---

Keep in mind if your date columns are of datatype datetime don't use BETWEEN but use

col >= @begin and col <= @end

SQLServer has an issue with datetime data...

There are several possibilities, but without sample data, it's difficult to determine which is best. Here are just two options.

WITH DupeCheck AS (

SELECT id, date, time, location, cardnumber, amount,...